Invoice Age to Start Generating A/R Statement (B86)

Purpose: Use this screen to define the minimum number of days the newest A/R open item must age before the system generates an A/R statement for the bill-to customer.

Number field: Enter the number of days that must elapse after the invoice date or invoice due date (based on the Age by Date Type (C02) system control value) before the system generates an A/R statement for the bill-to customer. This is a 7 position, numeric field.

A/R statement generation logic: This system control value works with the Invoice Age to Stop Generating A/R Statement (B87), Statement Interval (B88), and Age by Date Type (C02) to determine whether to generate A/R statements through Printing Statements (PSTS):

• Is it too soon to generate a new statement for the bill-to customer? The system determines it is time to generate a new periodic statement for a bill-to customer by checking the Last statement date and determining whether the number of days specified in the Statement Interval (B88) system control value has passed.

Example: The current date is August 27. The Last statement date is July 24. The Statement Interval (B88) is 30. Since July 24 is more than 30 days earlier than August 27, it is not too soon to generate a new statement for the customer.

• How are you evaluating invoice aging? The Age by Date Type (C02) system control value determines whether the system checks the invoice date or the due date for open items when determining the age of open items.

• Are there any open items for the bill-to customer that fall within the statement period? The system looks for open items whose invoice date (if the Age by Date Type (C02) is set to INVOICE) or due date (if the Age by Date Type (C02) is set to DUE) between the Invoice Age to Start Generating A/R Statement and the Invoice Age to Stop Generating A/R Statement (B87). If there is at least one open item whose date is on or later than the Invoice Age to Start Generating A/R Statement, and is also earlier than the Invoice Age to Stop Generating A/R Statement (B87), the system can generate a statement for the bill-to customer.

Example: The current date is August 27. The Invoice Age to Start Generating A/R Statement is set to 1, and the Invoice Age to Stop Generating A/R Statement (B87) is set to 120. The Age by Date Type (C02) is set to DUE. If there is at least one open item for the bill-to customer whose due date is between April 29 (120 days earlier) and August 26 (1 day earlier), then the system can generate a statement for the bill-to customer. However, if the Age by Date Type (C02) is set to INVOICE, the system uses the invoice date for the open item rather than the due date to make this determination.

Which A/R open items to include on the statement: You can specify a range of dates when Printing Statements (PSTS) to indicate which open items to include on the A/R statement.

Example: The current date is August 27, and you enter an Invoice date range of July 1 to July 31. Only open items whose invoice dates are within that range of dates are included on the A/R statement.

This selection takes place regardless of the Age by Date Type (C02) setting that you use to determine whether to generate the statement. However, if you leave the Invoice date range blank when generating statements, all unpaid open items for the bill-to customer are included on the invoice, even if their dates are not within the Invoice Age to Start Generating A/R Statement and the Invoice Age to Stop Generating A/R Statement (B87).

Example: The bill-to customer’s earliest unpaid open item has an invoice date of January 15, and the latest unpaid open item has a date of August 10. These dates are not within the Invoice Age to Start Generating A/R Statement and the Invoice Age to Stop Generating A/R Statement (B87). If you leave the Invoice date range blank when generating statements, these open items are still included on the statement.

If you leave this field blank, the system generates an A/R statement for bill-to customers regardless of the invoice date or due date for the customers’ open items.

For more information: See A/R Printing Functions for information on the Printing Statements (PSTS) menu option and sample statements.