Customer Statements

This produces Statements for selected Customers.  The Statement periods shown in the report are user-defined in File>Financial Configuration>Statement Periods

 

Parameters

 

Run Statements as at: This is prefilled with the system date.  However you can amend the date from the drop-down calendar and run the Statements ‘As At’ any selected date

 

Include Fully Applied Transactions From: All fully applied transactions completed on, or after, this date will appear on the Statement.  This field is prefilled with the first day of the current month but can be amended by selecting a new date from the drop-down calendar.

 

Include Zero Balance Customers: ‘Check’ this checkbox if you wish to include Customers that currently have a zero balance.

 

Selection Criteria

 

Three distinct selection criteria are available:

Select specific Customer

Select all Customers linked to a Billing Customer

Select a range of Customers

 

For specific Customer or Billing Customer: ‘Check’ this checkbox if you are selecting a Specific Customer or Billing Customer.  This will activate the following two Radio Buttons

 

Specific Customer: If this Radio Button is selected then also select the specific Customer from the adjacent drop-down list

 

All Customers linked to this Billing Customer: If this Radio Button is selected then also select the specific Billing Customer from the adjacent drop-down list

 

From Customer Type: From the drop-down list select the first Customer Type record in the range to be printed.  If nothing is entered then the first record in the ‘Customer Type’ file is assumed.

 

To Customer Type: From the drop-down list select the last Customer Type record in the range to be printed.  If nothing is entered then the last record in the ‘Customer Type’ file is assumed.

 

From Invoicing Group: From the drop-down list select the first Invoicing Group record in the range to be printed.  If nothing is entered then the first record in the ‘Invoicing Group’ file is assumed.

 

To Invoicing Group: From the drop-down list select the last Invoicing Group record in the range to be printed.  If nothing is entered then the last record in the ‘Invoicing Group’ file is assumed.

 

From Statement Cycle: Statement Cycles are user-defined (Sales>Settings>Statement Cycles) and linked to a Customer record.  This enables you to select Customers within a specific Statement Cycle range.  From the drop-down list select the first Statement Cycle record in the range to be printed.  If nothing is entered then the first record in the ‘Statement Cycle’ file is assumed. 

 

To Statement Cycle: From the drop-down list select the last Statement Cycle record in the range to be printed.  If nothing is entered then the last record in the ‘Statement Cycle file is assumed.

 

Specific Site: 'Check' this checkbox if the selection is to be restricted to a specific site.  In this instance a Site must be selected in the next field

 

(Site Selection): If checkbox 'Specific Site is 'checked' then select the site from the drop-down list

 

 

Buttons

 

OK: The program will go through the Invoice file using the above parameters and display the following ‘Batch Invoice Printing’ screen containing the requested Invoices

 

Cancel: This will close this selection panel.

 

 

Customer Statement List Screen

 

This screen allows you to select specific Statements for printing, define the output media, and then print them.

 

Data Display Options

 

Field Position - On this screen you can move the field position by dragging the column heading left or right to the position where you want it to appear.

 

Input and Display

 

Select: ‘Check’ the checkbox if you wish to ‘print’ the Statement.  You have the option to select or unselect all displayed Customers by clicking the appropriate button at the bottom of the screen

 

Output Method: This displays the ‘Statement Default Output’ method as held against the Customer master record.  It can be amended here if required by selecting from the drop-down list.  The options are:

Print Only

Email Only

Print and Email

 

You should be aware that the email option automatically creates and sends an email using the facilities on your computer.  The Customer master record must contain an email address in the Statement Email address field or (be default) a single Email address against the Billing Customer.

 

Customer: Display only field showing the Customer Name

 

Total Balance: Display only field showing the current outstanding Balance held against this Customer

 

Unapplied Deposits: Display only field showing the total value of Deposits from the Customer that have yet to be applied to Invoices

 

Unapplied Payments: Display only field showing the total value of Payments from the Customer that have yet to be applied

 

Buttons

 

Select all Statements: Click on this button to the ‘check’ the ‘Select’ field against all Customers

 

De-select all Statements: Click on this button to the ‘uncheck’ the ‘Select’ field against all Customers

 

Print Current Statement: Highlight a single Customer and click on this button to output a Statement for this Customer only.  In this instance the Output Method’ held against the record is ignored and the three output options (Screen, Printer, or Email) are presented

 

Print All Selected Statements: This will immediately perform the following action for each selected Customer:

If the ‘Output Method’ is ‘Print Only’ then the Statement will be printed directly to the default printer

If the ‘Output Method’ is ‘Email Only’ then the Statement will be generated as a pdf file and attached to an email then sent to the email address defined in the Customer master record

If the ‘Output Method’ is ‘Print and Email’ then both the above actions will take place

 

Close: This will close the Batch Invoice Printing screen.