Use the Print Statements screen to generate a .csv file encoded with all of your statement information and send it to your billing service's FTP site. The billing service then creates professional statements from the data provided and sends them to your customers. You can generate statements based on a variety of parameters, including due dates, branches, zip codes, and customer names.
Note: You cannot generate a statement batch while another is running. You can, however, generate an invoice batch at the same time, if needed.
To send statements to your billing service using FTP:
From the A/R menu, select Print Statements to display the Print Statements window.
In the Data Through field, enter either the fiscal end-of-month date or the statement date.
The system populates this field with today's date, but you can change it, if needed.
In the Age as of field, enter the date from which to age the invoices.
The system populates this field with the date from the Data Through field, but you can change it, if needed. For example, if you run a statement for a customer from a prior accounting period, use an earlier date to age the invoices.
In the Home Branches field, enter the number that represents the branch (or branches) for which to generate statements. For example, to generate statements for branches 1 and 2, type 1,2.
Select the Include Blank Home Branch check box to include those customers for whom no home branch has been assigned. To exclude customers who do not have an assigned home branch, leave the check box blank..
In the Sale Branches field, if you sell product out of other branches than the home branch, enter the number that represents the sale branch (or branches).
For example, to generate statements for branches 1 and 2, type 1,2.
In the Customer field, do one of the following:
|
To generate statements for... |
Do this... |
|
all customers |
Leave this field blank. |
|
one customer |
Enter the customer's name. |
|
a group of customers |
Use the Multiple button to select a group of customers. |
In the Statement Options field, select one of the following:
Individual Customer(s) - Includes only the customers whose names you entered in the Customer field.
All Batch Stmt Customers - Includes all customers who have an entry in the Batch Statement field in their customer record, regardless of their balance.
Positive Balance - Includes all customers who have a balance greater than zero and who have an entry in the Batch Statement field in their customer record.
Current - Includes all customers who have a balance that is not past due and who have an entry in the Batch Statement field in their customer record.
30 Days - Includes all customer who have a balance that is from 31 to 59 days past due, irrespective of whether or not they have an entry in the Batch Statement field in their customer record.
60 Days + - Includes all customers who have a balance that is more than 60 days overdue, irrespective of whether or not they have an entry in the Batch Statement field in their customer record.
Negative Balance - Includes all customers who have a credit balance, irrespective of whether or not they have an entry in the Batch Statement field in their customer record.
In the Also Print Invoices field, enter one of the following:
Batch Ready Invoices - Includes all invoices with a print status of B along with the statement.
All Open Invoices - Includes all open invoices for each customer along with the statement.
Statement Month Open Invoices - Includes all invoices that appear on this month's statement.
No - Does not include any invoices. This is the recommended setting.
Note: If you print statements and invoices, the batch number includes an S (statement) or an I (invoices) in case you need to resend them.
Select the Ovrd Cust Batch Stmt Flag check box to override the print flag parameter set in the Batch Statement field on the Customer Pricing/Printing screen.
In the Batch Sort By field, select one of the following:
Zip - Sorts first by ZIP code, then by bill-to account, and then by ship-to account. Sort your statements by ZIP code if your company takes advantage of reduced postal rates by sending statements as presorted first class mail.
Customer Name - Sorts first by customer name, then by bill-to account, and then by ship-to account.
Note: The system default value for this field is set in the Default Invoice/Statement Sort control maintenance record.
In the Customer Statement Cycle field, indicate for which customer group to generate statements.
Customer groups are typically identified by how often you send the customers statements, such as at the end of the month or on a specific date each month.
Note: Codes are set up in the Valid Customer Statement Cycles control maintenance record, and are assigned to customers on the Customer Pricing/Printing screen in Customer Maintenance.
In the Send via FTP (Y/N) field, Select Y.
Note: You can change this field to No to print, fax, or e-mail your own statements at any time.
To change the standard message that prints on all of the statements, use the Msg hot key to move the cursor to the Statement Message field. Enter the information and press Esc to save it.
Do one of the following:
To... | Use this menu option... |
send the batch to the FTP site now
| File > Print Note: Set the FTP information in the FTP tab. |
view the batch before sending it | File > Hold You can then send the batch using the File >Print menu option from the Report Queue window. |
Note: We do not recommend scheduling statement runs that include invoices, as this may cause unexpected results.
See Also: