Your client has reported a problem with the sales reports in Magento compared to the reports in their ERP system. Their ERP store are hosted in…

Magento's sales reports rely on pre-aggregated data tables for performance. When the store's time zone is changed, this action does not retroactively update the aggregated data that was calculated using the previous time zone. Consequently, historical reports remain inaccurate. The "Refresh Lifetime Statistics" function forces Magento to re-process and re-aggregate all historical order data from the beginning, applying the newly configured time zone. This recalculation corrects the aggregated report tables (e.g., salesorderaggregatedcreated), aligning Magento's reports with the source data and resolving the discrepancy.

A. Resync your data between the ERPJ and Magento: Resynchronizing order data might align individual transaction records but will not fix Magento's internal, pre-aggregated reporting tables, which are the source of the report discrepancy.

B. Update the time zone on the ERP system along with Magento: The scenario explicitly states this step has already been completed ("After updating the time zones in both your system..."), so it cannot be the solution to the remaining problem.

D. Refresh the daily statistics on your reports: Refreshing only daily statistics is insufficient as it would only correct the most recent data, leaving the vast majority of historical report data inaccurate from the previous time zone setting.

1. Adobe Commerce User Guide

Reports > Dashboard > Refresh Statistics: "The data that is used for reports is collected and stored in aggregate. If you have a large amount of data

you might need to refresh the statistics... To bring the statistics up to date

you can refresh them for the last day or for the lifetime of the store." This documentation confirms the existence and purpose of refreshing lifetime statistics to update aggregated report data.

2. Adobe Commerce Developer Documentation

Modules > magento/reports: The documentation for the Reports module explains that report data is aggregated from primary sales tables (like salesorder) into aggregate tables (like salesorderaggregatedcreated). The aggregation process applies the configured locale and time zone settings. Changing these settings requires a refresh to ensure the aggregated data is correct. (Reference: Analysis of the \Magento\Reports\Model\ResourceModel\Order\Collection and related aggregation cron jobs).

3. Adobe Commerce Developer Documentation

Database schema > salesorderaggregatedcreated table: The schema definition and its purpose illustrate that it stores aggregated data based on a specific period (day

month

year). The period column is derived from the createdat timestamp of orders

a process that is sensitive to the configured time zone. A change in time zone necessitates a recalculation to correctly populate this table for historical periods.