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.

ARAgingDSO.png

 

 

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

 

 

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.