Standard AQ - AR Aging As Of AQ

Report Description

Parameters

Parameter Name	Options	Description
Branch (Invoice)
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.
Customer Name
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.

Report Fields

Field Name	Description
StaffingCompany	Supplier Name
BranchName	Invoice Branch Name
CustomerID	Customer ID [Customer who receives the Invoice] – This field will vary according to Roll Up To Parent Customer parameter
CustomerName	Customer Name from Invoice. [Invoice To Customer] – This field will vary according to Roll Up To Parent Customer parameter
DepartmentName	Customer Department
InvoiceNumber	Invoice Number
InvoiceDate	Invoice Date
DueDate	Due Date from Invoice
DaysPastDue	Days Past Due Date from Invoice
AccountingPeriodDate	Accounting Period Date from Invoice
InvoiceAmount	Invoice Amount from Invoice
FinanceCharge	Total Finance Charge accumulated to the Invoice as per AsOfDate
BalanceAmount	Total Balance Due of Invoice [Calculation: Invoice Amount – Payment Amount + Finance Charge]
PaymentAmount	Total Amount paid by the client to the Invoice as per AsOfDate
Current_Age	This Column shows the Balance Due of Invoice whose DO is lesser 1 (i.e.,0). Otherwise, is left blank
Age_1_30	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
PaymentTerms	Customer Payment Terms from Billing Setup
DSO	Shows number of days it takes to collect payments due from customers after the date the invoice is issued
PhoneNumber	Customer Primary Contact Method
CreditLimit	Maximum amount of credit / Limit set for credit amount
HighLimit	Calculated as the highest amount, when the total of the outstanding amount for the invoice has been so far
LastPaymentDate	Last Paid Date for invoice as per AsOFDate.
LastCustomerPaymentDate	Last Paid Date for Customer as per AsOfDate. There is another field with the same title [Last Payment Date] which is for Invoice.
AccountManager	Name of the Account Manager of the Customer
CreditHoldCode	Reason for holding the credit (For e.g., Over Credit Limit, Past Due Invoice)