Standard AQ - AR Aging As Of AQ

Report Description

mceclip1.png

 

 

Parameters

mceclip0.png

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)

 

 

Articles in this section

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