Submit a ticket

Standard Report - Invoice Status

Updated on Follow
0 out of 0 found this helpful

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 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

 

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 parameter has “Invoice Date” selected.

 

 

 

 

Report Fields

Field Name

Explanation

Branch

Invoice Branch.

Will be visible when 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.

 

 

 

Required Setup

The Payment Terms need to be set up by client in the Back Office Billing Setup for the customer.


Have more questions? Submit a request

0 Comments


This space is for article feedback only. To make a request of the Avionté Support Team, please submit a ticket to https://support.avionte.com.