Understanding Statement Generation

When you generate statements, in addition to creating records in the F03B20 and F03B21 tables, the system updates these fields in these tables:

Table	Updated Fields
Customer Ledger (F03B11)	Statement Number (CTL) Statement Date (SMTJ)
Invoice Revisions (F03B112)	Statement Print Flag (STPF)
Receipts Detail (F03B14)	Statement Number (CTL) Statement Date (SMTJ)

You use processing options to customize statements for the organization. For example, you can select the statement print program and version that you want to use to print statement detail. This enables you to specify whether to print aging or account summary information on the statement, whether to print each invoice pay item or summarize the pay items for each invoice, and the date that you want to print on the statement.

These print programs, which are set up on user defined code 03B/ST, are available for generating statements:

• R03B5001 - Statement Print

  This is the standard statement print program.

• R03B5001JP - Kagami Invoice Statement

  This is a localized statement format for Japan.

• R03B5002 - Italian Statement Print

  This is a localized statement format for Italy.

• R03B5003 - Statement Print Credit Card

  This is the print program that you use to print statements in a credit card format. The system prints only new invoices and summarizes invoices previously printed into a balance forward amount.

• R03B506 - Statement Print with Draft

  This is the statement print program that you use when you want to include draft information.

You can also create a custom print program to use.

When you want to limit the invoices that print on the statement or change the order in which invoices print, you use the data selection and data sequence for the statement print program. For example, you might want to exclude paid invoices from the statement.

Note:

To exclude paid invoices from the statement, use data selection in the version of the statement print program:

Open Amount is not equal to {ZERO}

This data selection enables credit amounts and debit amounts to appear on the statement, but excludes paid invoices.

The data selection for Statement Notification Refresh (R03B500X) controls which statements are generated, not which invoices are printed on the statement. You should not change the data sequence for R03B500X.