Standard AQ - AR Aging DSO

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