Troubleshooting: Sales amount different between Multi-Dimensional Sales Analysis Report and Monthly Sales Analysis Report

From AutoCount Resource Center
Jump to navigation Jump to search

Question: Why the sales amount is different when I inquiry Multi-Dimensional Sales Analysis Report and Monthly Sales Analysis Report?

E.g.: From 01 October 2017 until 31 October 2017, in Multi-Dimensional Sales Analysis Report show amount 2399, but in Monthly Sales Analysis Report show amount 6599.

**Note: No other filter criteria was defined from the Filter Options for both reports.


Mds1.png

Multi-Dimensional Sales Analysis Report


Mds2.png

Monthly Sales Analysis Report


Possible Reason:

In Multi-Dimensional Sales Analysis Report, there are some column fields being filtered. This will result the sales amount deducted from the filtered columns.

E.g.: Sales Agent column are being filtered to show the particular Sales Agent’s sales amount.


Mds3.png


Solution:

Remove all the column fields filtered in Multi-Dimensional Sales Analysis Report to show all transaction amounts.

1. In Multi-Dimensional Sales Analysis Report, if a column field's right top corner indicates a filter label, it means that column field is being filtered.


Mds4.png


2. Click on the filter label, click on (Show All), and then click on OK.


Mds5.png


3. Now, the sales amount in Multi-Dimensional Sales Analysis should be tallied with your Monthly Sales Analysis Report.


Mds6.png



By: Lay Swan 170929, CY171005, KM 171006, P171020



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations