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.

InvoiceStatus.png

 

 

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.

 

Articles in this section

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

Comments

0 comments

Please sign in to leave a comment.