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

From AutoCount Resource Center
Revision as of 07:20, 23 October 2017 by Keatmeng (talk | contribs) (Created page with "'''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 3...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 (span style='color:red'>Show All), and then click on span style='color:red'>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