|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
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 between 1 and 30
|Age_31_60||This Column shows the Balance Due of Invoice whose DO is between 31 and 60|
|Age_61_90||This Column shows the Balance Due of Invoice whose DO is between 61 and 90|
|Age_Over_90||This Column shows the Balance Due of Invoice whose DO is over 90|
Customer Payment Terms from Billing Setup
Customer Primary Contact Method
Calculated as the highest amount, when the total of the outstanding amount for the invoice has been so far
Last Paid Date for Customer as per AsOfDate. There is another field with the same title [Last Payment Date] which is for Invoice.
Please sign in to leave a comment.