Special logic
The result is in Customer level. So, Invoice Amount, Balance Amount and Total Payment Amount is for a Customer.
Report Description
The AR Aging DSO (Days Sales Outstanding) report displays outstanding customer AR dollars. This AQ is useful to review AR and track the AR Status of Customer.
Parameters
Parameter Name |
Options |
Description |
Start Date |
|
|
End Date |
|
|
Customer Name |
|
Filters results by Customer Name. |
Date Type |
Accounting Period Date, Due Date, Invoice Date |
Invoice Accounting Period Date, Due Date or Invoice Date |
Branch |
All available branches |
|
Report Fields
Field Name |
Description |
Branch |
Invoice Branch. |
Customer Name |
Customer Name from Invoice. [Invoice To Customer] |
Department Name |
Customer Department |
Invoice Amount |
Invoice Amount from Invoice [Total Invoice Amount in selected date range] |
Balance Amount |
Total Balance Due of Invoice [Calculation: Invoice Amount – Payment Amount] |
Total Payment Amount |
Total Amount paid by client to the Invoice as per End Date [Total Payment Amount in selected date range] |
DSO |
If No of Days = 0 then 0 If Invoice Amount = 0 then 0 Else DSO = Balance Amount / [Invoice Amount / No of Days] |
No of Days |
(End Date – Start Date) + 1 |