Open main menu

A/R Monthly Sales and Collection Analysis Report

A/R Monthly Sales and Collection Analysis Report

This report shows analysis of A/R monthly sales and collection.


 


Filter Options

Date Range: define the date range from and to.

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

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

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


Report Options

Sort by: choose one of the following options: Debtor Code, Company Name, Sales Agent, Area, Debtor Type.

Group by: choose one of the following options: None, Sales Agent, Area, Debtor Type.

Show Criteria in Report: to show selected options in report


Other Options

Report Type: choose one of the following options: Sales Analysis Report, Sales & Collection Analysis Report, Collection Analysis Report.

Include CN and DN: to include Credit Note and Debit Note in the analysis report.

Show Total with Tax Amount: to include or exclude tax amount in transaction


More Options


Filter Options

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

Currency: choose either Show All, Show Cancelled or Show Uncancelled.

Cancelled Status: choose either Show All, Show Cancelled or Show Uncancelled.


Other Options

Include Zero Balance: to include accounts with zero balance

Show Group Company: to show debtors marked as Group Company, also to show sub-company.

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

 


 

Go to menu