All the Debtors and Creditors related Reports are available under this menu.
Under Debtors / Creditors Reports, you will find two types of Reports:
1. Debtors / Creditors Age analysis
2. Debtors / Creditors Due Statement.
1. Debtors / Creditors Age analysis
Debtors / Creditors Age analysis report shows your debtors/receivables or creditors/payables outstanding with length of time for that particular outstanding.
1.1 Debtors Age Analysis Report
This report categorizes a company's accounts receivables according to the length of time an invoice has been outstanding.
It can be filter as follows:
Date – To select as at date
Project – To select relevant project
Account – To select debtor account
Address Cat – To select relevant address category
BU – To select relevant business unit
No of Days 1 – To select number of days for 1st column
No of Days 2 – To select number of days for 2nd column, ext.
Clicking the + button and you can expand the heading. After that, it will show the breakdown for each heading.
Click on the red + button, it will expand the whole report.
Clicking on the like green + buttons, it will expand one by one record.
1.2 Creditors Age Analysis Report
This report categorizes a company's accounts payables according to the length of time that payable amount has been outstanding.
It can be filter as follows:
Date – To select as at date
Project – To select relevant project
Account – To select creditor account
Address Cat – To select relevant address category
BU – To select relevant business unit
No of Days 1 – To select number of days for 1st column
No of Days 2 – To select number of days for 2nd column, ext.
2. Debtors / Creditors Due Statement
Debtors / Creditors Due statement report shows your debtors/receivable or creditors/payable outstanding. You can filter this by Customer/Supplier Account.
2.1 Debtors Age Analysis Report
It can be filter as follows:
Date – To select as at date
Project – To select relevant project
Account – To select Debtor account
AdvAnalysis – To select debtor address
Address Cat – To select relevant address category
Tran type - Transaction type (sales/ sales return, ext.)
BU – To select relevant business unit
2.2 Creditors Age Analysis Report
It can be filter as follows:
Date – To select as at date
Project – To select relevant project
Account – To select Creditor account
AdvAnalysis – To select debtor address
Address Cat – To select relevant address category
Tran type - Transaction type (sales/ sales return, ext.)
BU – To select relevant business unit