Field

Description

Summary aging report

This field indicates whether to print the Summary Aging Report, which presents summary information for each bill-to customer, including complete address information. Valid values are:

Y (default) = print the Summary Aging report

N = do not print the report

Alphanumeric, 1 position; required.

Summary aging

This field indicates whether to print the A/R Aging Summary Report, which presents summary information for each bill-to customer, including account number, name, and phone number only. Valid values are:

Y (default) = print the A/R Aging Summary

N = do not print the report

Alphanumeric, 1 position; required.

Detail aging report

This field indicates whether to print the Detail Aging Report, which presents complete information for each bill-to account, including open item details. Valid values are:

Y = do not print the Detail Aging report

N (default) = print the report

Alphanumeric, 1 position; required.

Balance due amount

Enter the minimum total A/R balance for all bill-to accounts to include on the report(s). For example, if you enter 100.00, only bill-to customers whose total A/R balances are $100.00 or greater will be selected for the report(s) you are printing.

Negative number: You can enter a negative balance due amount. For example, if you enter 500.00, bill-to customers whose total A/R balances are -$499.99 or more will be selected for the report(s).

If you enter a # of days past due: If you complete the # of days past due field and not the Balance due amount field, the system interprets the Balance due amount as a zero; as a result, only bill-to accounts whose total A/R balances are greater than zero will be selected for the report(s).

If you leave this field blank and if the # of days past due field is also blank, all bill-to accounts will be selected for the report(s).

Numeric, 7 positions with a 2-place decimal; optional.

# of days past due

Enter the minimum number of days past due a customer bill-to account must be to be included in the report(s). Any account that has a balance (positive or negative) within the aging bucket specified by the number of days will be selected for printing. For example, if you enter 45 in the # of days past due field, and an account has a balance in the 31-60 days past due aging bucket, that account will be selected for printing.

How are balances aged? The Customer Bill To Aging periodic function evaluates open items and assigns them to aging buckets based on their due dates. The periods covered by each aging bucket are defined in the System Control file.

If the Net A/R credits in each age 'bucket' when aging A/R items system control value is set to Y, credit open items age in the same way as debit open items, and the totals within each bucket represent the net of debits minus credits. See About Aging for more information.

If you enter a Balance due amount: If you complete both the Balance due amount field and the # of days past due field, only bill-to accounts that meet both criteria will be selected for the report(s). See Balance due amount for more information.

If you leave this field blank, all bill-to accounts will be eligible to print on the report(s) regardless of their aging.

Numeric, 3 positions; optional.