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) |
Comments
0 commentsPlease sign in to leave a comment.