Sales Analysis By Document Report

From AutoCount Resource Center

Sales Analysis by Document Report

This report shows analysis of sales by document types.



Filter Options

Date Range: define the date range from and to.

Debtor: choose either No filter, Filter by range or Filter by multi-select

Stock Code: choose either No filter, Filter by range or Filter by multi-select (this criteria will be enabled if criteria selected in Other Options is stock-related)


Report Options

Show Criteria in Report: to show selected options in report

Show as Sales Summary: to show total sales in one column (instead of several document types).

Show Description: to show item description


Other Options

Group Level 1/2: choose the criteria for grouping purpose. Choose one of the following criteria: Debtor Code, Sales Agent, Area, Debtor Type, Sales Location, Item Group, Item Code, Item Type, Item Location. (Item Brand, Item Class and Item Category if you enabled Advanced Item module)

Show Branch: to show in new column (Branch Code, Branch Name) sales analysis by debtor's branch(s)

Show Empty Branch: to show also debtors transaction with no branch (or branch is not defined).


More Options


Filter Options - Filter 1

Sales Agent: choose either No filter, Filter by range or Filter by multi-select

Area: choose either No filter, Filter by range or Filter by multi-select

Debtor Type: choose either No filter, Filter by range or Filter by multi-select

Sales Location: choose either No filter, Filter by range or Filter by multi-select

Stock Group: choose either No filter, Filter by range or Filter by multi-select

Stock Item Type: choose either No filter, Filter by range or Filter by multi-select

Stock Location: choose either No filter, Filter by range or Filter by multi-select

Currency Code: choose either No filter, Filter by range or Filter by multi-select


Filter Options – Filter 2 (If you enabled Advanced Item module)

Stock Brand: choose either No filter, Filter by range or Filter by multi-select

Stock Category: choose either No filter, Filter by range or Filter by multi-select

Stock Class: choose either No filter, Filter by range or Filter by multi-select


Document Options

to include Invoice, Cash Sale, Credit Note, Debit Note.


Other Options

Calculate Bal b/f for This Fiscal Year only: to calculate the value of balance b/f for this related fiscal year only.

Show in Local Currency: to show in local currency, usually in RM


Inquiry: to refresh and show the result of filter options and report options.

Preview: to preview report to be printed

Print: to select printer and print report

Hide Options: to hide the Options portion so that the screen has more space for details. Click on Show Options to show it again.

Close: close the screen


Click on Preview

You may select from the following reports:




Go to menu

AutoCount Accounting 2.0 & 2.1


AutoCount Accounting 1.8 / 1.9
AutoCount Payroll
AutoCount POS


AutoCount On The Go
AutoCount Accounting Plug-In Documentations