I use Microsoft Dynamics AX2012 to run 3 stores.
I tried to compare daily report between Z-Report and Retail Sales report, however, I find differences between both reports.
Though the difference is small, in our perspective the data between Z-report and retail sales report should be match since both report use the same data source.
Is there any solution/ justification about this issue?
Any help and opinion for this matter is highly appreciated.
What version of your application? 2012 R3 CU10, CU11 ...?
If you do not have any kind of customization in the POS, the first action would be to update the POS to a lasted version.In recent years, microsoft has fixed some problems related to totals values, payment methods, discount ....Such as this:
A recalled order on POS creates duplicate transactions. This causes incorrect values being printed on the X and Z-reports.
The changes in the hotfix resolve the X/Z-report issue on EPOS by making sure that no pickup order transactions amount is added to the total amount, such as the "Sales total amount", "Tax total amount", and "Discount total amount."
As for the same issue on MPOS, it has been fixed in the hotfix KB 3217394 (https://fix.lcs.dynamics.com/Issue/Details?kb=3217394&bugId=3799209&qc=ee0f492ddbdaa9385f225311d8dedf751a24c3a843c0101b94e7d07690158158), and the current fix depends on it.
This hotfix also fixes the "Retail sales" shows pickup order transactions issue in Microsoft Dynamics AX. This issue is fixed by filtering out that type transaction with "customer order mode" equaling "pick up."
Important: This hotfix contains one or more reports. Make sure that you have imported all of your modified reports into the AOT, and then install the hotfix, and redeploy the reports.
Business Applications communities