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 |
