|As of Date
Select Date on basis of which the data are obtained
|Aging Date Type
|Accounting Period Date / Due Date
Select to choose to Group Invoices by Branch or not.
|Root Customer ID
|Roll up to Parent Customer
|True / False
Based on this parameter, the result will either displayed per individual customer department or rolled into Root Customer.
Invoice Branch Name
Customer ID [Customer who receives the Invoice] – This field will vary according to Roll Up To Parent Customer parameter
Customer Name from Invoice. [Invoice To Customer] – This field will vary according to Roll Up To Parent Customer parameter
Due Date from Invoice
Days Past Due Date from Invoice
|Accounting Period Date from Invoice
Invoice Amount from Invoice
Total Finance Charge accumulated to the Invoice as per AsOfDate
Total Balance Due of Invoice [Calculation: Invoice Amount – Payment Amount + Finance Charge]
Total Amount paid by the client to the Invoice as per AsOfDate
|This Column shows the Balance Due of Invoice whose DO is lesser 1 (i.e.,0). Otherwise, is left blank
This Column shows the Balance Due of Invoice whose DO is between 1 and 30
|This Column shows the Balance Due of Invoice whose DO is between 31 and 60
|This Column shows the Balance Due of Invoice whose DO is between 61 and 90
|This Column shows the Balance Due of Invoice whose DO is over 90
Customer Payment Terms from Billing Setup
|Shows number of days it takes to collect payments due from customers after the date the invoice is issued
Customer Primary Contact Method
|Maximum amount of credit / Limit set for credit amount
Calculated as the highest amount, when the total of the outstanding amount for the invoice has been so far
Last Paid Date for invoice as per AsOFDate.
|Last Paid Date for Customer as per AsOfDate. There is another field with the same title [Last Payment Date] which is for Invoice.
|Name of the Account Manager of the Customer
|Reason for holding the credit (For e.g., Over Credit Limit, Past Due Invoice)