Standard Report - Invoice Status

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

1. The page is separated per Supplier.
2. There are two Summary Boxes; Supplier Total and Report Total.
   1. Supplier Total shows the Total amount and counts of invoice details for the Supplier.
   2. Report Total shows the Total amount and counts of invoice details for the whole report.