Required Setup
The Payment Terms need to be set up by the client in the Back Office Billing Setup for the customer.
Report Description
See the invoices that have been billed with the invoice information and payments made to those invoices. This report makes it easy to pull information on the status of all invoices during a specific time period for a specific customer.
Parameters
Parameter Name |
Options |
Explanation |
Roll up to Root Customer |
True/False |
Based on this parameter, results will either be displayed per individual customer department or rolled into Root Customer. |
Customer Name |
|
Filters results by Customer Name. |
Date Type |
Accounting Period Date, Invoice Date |
Invoice’s Accounting Period or Invoice Date. |
Start Date |
|
|
End Date |
|
|
Group By |
Branch, Customer, Invoice Date |
|
Branch |
All available branches |
Filters data from Invoice's branch |
Include Zero Balance Invoice |
True/False |
When set to True, also pulls invoices with a 0 balance amount. When set to False, does not pull invoices with a 0 balance amount |
Also Show Payment |
True/False |
When set to True, displays the detailed information of the payments (Date Posted, Payment Type, Payment Amount, Check number) made on a particular invoice.
Note: This parameter functions only when at least one of the Group By parameters has “Invoice Date” selected. |
Report Fields
Field Name |
Explanation |
Branch |
Invoice Branch. Will be visible when the Branch is selected under Group By Parameter. |
Customer |
Name of the Customer. Will be visible when Customer or/and Invoice Date is selected under Group By Parameter. |
Department |
Department name Will be visible when Customer or/and Invoice Date is selected under Group By Parameter. |
Payment Terms |
Payment Terms Will be visible when Customer or/and Invoice Date is selected under Group By Parameter. |
Invoice Date |
Date of the Invoice. Will be visible when Invoice Date is selected under Group By Parameter. |
Inv. No. |
Invoice number. Will be visible when Invoice Date is selected under Group By Parameter. |
Invoice Amount |
Pulls the sum total of invoice amount based upon the group by parameter. So, if only “Customer” is selected in the Group By parameter, then Invoice Amount column pulls the sum total of invoice amount per Customer. Similarly, if “Branch”, “Customer” and “Invoice Date” is selected in Group By parameter, then Invoice Amount column pulls the sum total of invoice amount per invoice per customer per branch |
Payments |
Pulls the difference of the sum total of invoice amount and sum total of Balance Amount based upon the group by parameter. So, if only “Customer” is selected in the Group By parameter, then Payments column pulls the difference of the sum total of invoice amount and sum total of Balance Amount per Customer. Similarly, if “Branch”, “Customer” and “Invoice Date” is selected in Group By parameter, then Payments column pulls the difference of the sum total of invoice amount and sum total of Balance Amount per invoice per customer per branch
*(Formula) Payments=SUM(InvoiceAmount) - SUM(BalanceAmount) |
Balance |
Pulls the sum of Balance Amount based upon the Group By parameter selected. |
Finance Charge |
Pulls the sum of Finance Charge based upon the Group By parameter selected. |
Special Logic
- The page is separated per Supplier.
- There are two Summary Boxes; Supplier Total and Report Total.
- Supplier Total shows the Total amount and counts of invoice details for the Supplier.
- Report Total shows the Total amount and counts of invoice details for the whole report.