Summary Record

These processing options determine which records the system selects for updating the F03B16S table.

1. Number of Days for Summary

Use this processing option in conjunction with the Thru Date processing option to specify the subset of detail records from the A/R Statistical History table (F036B16) that you want the system to summarize into records to include in the A/R Statistical Summary table (F03B16S).

For example, if you enter 365 in the Number of Days for Summary processing option and enter a Thru Date of 9/30/13, the system updates the F03B16S table with periodic records from the F036B16 table that have dates between 10/01/12 and 9/30/13.

If you do not specify a number of days, the system chooses all records that have a date that is less than the Thru Date you enter (inception-to-date). For fields that require calculations, processing time greatly increases. If you do not need to maintain inception-to-date information, update this processing option with a value to reduce the overall processing time of the program. You must enter at least the number of days in one period, as defined in the credit and collection date pattern, for the system to update the summary records with amounts. Otherwise, the system updates summary records with date values only.

The system updates the F03B16S table only for completed periods as defined by the credit and collection date pattern. For example, if the credit and collection date pattern is set up for a regular calendar year and you enter a date of 4/15 in the Thru Date, the system updates the F03B16S table with information only through period 3 (March). If you want the system to update the information in this table daily, set the through date ahead to the beginning of the next period or through the end of the fiscal year.

Note: The system determines the high balance amount in the Summary Statistics table (F03B16S) by using the highest balance amount of all of the periods being processed in the Periodic Statistics table (F03B16). The system determines the number of periods to process based on the date range in the Number of Days for the Summary and Thru Date processing options.

2. Thru Date

Use this processing option in conjunction with the Number of Days for Summary processing option to specify the subset of detail records from the A/R Statistical History table (F036B16) that you want the system to summarize into records to include in the A/R Statistical Summary table (F03B16S).

For example, if you specify 365 in the Number of Days for Summary processing option and enter a Thru Date of 9/30/13, the system updates the F03B16S table with periodic records from the F03B16 that have dates between 10/01/12 and 9/30/13.

If you do not specify a number of days, the system chooses all records that have a date that is less than the Thru Date that you enter (inception-to-date). For fields that require calculations, processing time greatly increases. If you do not need to maintain inception-to-date information, update this processing option with a value to reduce the overall processing time of the program. You must enter at least the number of days in one period, as defined in the credit and collection date pattern, for the system to update the summary records with amounts. Otherwise, the system updates summary records with date values only.

The system updates the F03B16S table only for completed periods, as defined by the credit and collection date pattern. For example, if the credit and collection date pattern is set up for a regular calendar year and you enter a date of 4/15 in this processing option, the system updates the F03B16S table with information only through period 3 (March). If you want the system to update the information in this table daily, set the through date ahead to the beginning of the next period or through the end of the fiscal year.