Reporting {#opencart-wkfw-reporting}
====================================

The plugin provides reporting functionality for merchants who also use the `Business Center`. You can import these reports from the `Business Center` into OpenCart:

* **Transaction Request Report:** includes details for individual transactions that are processed each day.
* **Payment Batch Detail Report:** includes transactions that are processed with the applications. This report is available shortly after captured transactions are batched.
* **Conversion Detail Report:** includes Case Management changes recorded in the `Business Center` to ensure that updated orders are also included in `OpenCart`. This report is generated at regular intervals and includes the results of the converted orders for each reviewer. This information provides an overview of all orders that were not immediately accepted.

Scheduling
----------

The Plugin reporting functionality works with a system scheduler to generate and update reports for `OpenCart`. There are some Cron Job modules available for `OpenCart`, such as the Cron Tab, that support reporting. Merchants can use any Cron Job module that `OpenCart` supports, or any other online Cron service provider to generate reports.  
See [Scheduling Report Generation](/docs/vas/en-us/isv-plugins/admin/all/rest/isv-plugin-o/built-by-us/opencart-overview/opencart-cron-tab.md "") for information about how to schedule report generation.

Workflow
--------

The reports are processed and orders are updated in `OpenCart` using this workflow:

1. Orders with an *AUTHORIZED_PENDING_REVIEW* or *AUTHORIZED_RISK_DECLINED* status are included in the *ps_cybersourceofficial_order* table in the OpenCart database.
2. If a review is trigged for an order based on the profile rule in Decision Manager, a *Payment pending for review* order status displays for that order on the `OpenCart` Back Office Orders page.
3. The merchant uses the `Business Center` to accept the order that is in review, and, if not already enabled, enables the reports using the Report Settings on the Plugin Configuration page.
4. The scheduler runs the report at regular intervals according to the intervals the merchant configured. The order is accepted or rejected by the merchant in the `Business Center`, is retrieved, and the new status is updated as *AUTHORIZED* or *DECLINED* . The updated order status displays in the *op_cybersourceofficial_order* table in the `OpenCart` database.
5. The original decision and the new decision are updated and displayed in the *op_cybersourceofficial_conversion_detail_report* table in the `OpenCart` database.
6. The order is updated as *Awaiting payment* status for the authorization and displayed on the `OpenCart` Back Office Orders page. The payment is accepted for the sale and any associated follow-on transactions (capture, void capture, refund, void refund, and full authorization reversal).