Print

1. Amount Open to be Exceeded

Specify an amount against which the customer balance is compared to determine whether to print the customer on the report. The system uses the currency code from the Currency Code of Open Amount processing option for the amount specified in this processing option. The system retrieves the exchange rate to use to restate customer balances from the F0015 table, and then compares the restated balance with the amount specified to determine whether to include the customer on the report. The system includes only customer balances with amounts greater than or equal to the amount specified in this processing option.

Note: The system prints the customer balances in the currency specified in the A/B Amount Codes field of the customer master record (CRCA in the F03B12 table), not in the currency specified in the Currency Code of Open Amount processing option.

2. Currency Code of Amount Open to be Exceeded

Specify the currency of the amount entered in the Open Amount to be Exceeded processing option. The system calculates open amounts based on the currency specified, and then compares the customer's balance with the amount entered in the Open Amount to be Exceeded processing option to determine whether to print the customer on the report.

If you leave this processing option blank, the system uses the currency code USD.

Note: The system does not print amounts in the currency specified; it uses the currency code only for data selection.

3. Standard or Insured Credit Limit

Specify which customer records to include on the report. Values are:

Blank: Include all records.

1: Include records with the open amount greater than or equal to the credit limit that is set up on the customer master record.

2: Include records with the open amount greater than or equal to the insured credit limit.

If the Open Amount to be Exceeded processing option contains a value, that value overrides this processing option.

4. Date - As Of

Specify the date to use to recalculate and print open invoice amounts. The system compares the date that you enter with the general ledger date of the receipt to determine whether the invoice was open or paid as of the date specified. If the invoice was open, the system includes it on the report. If you leave this processing option blank, the system does not perform as of processing.

Note: Using as of processing increases the report processing time.

5. Currency Code - Restated for Foreign and Aging Columns

Specify the currency to use to restate amounts that appear on the report. The system retrieves the exchange rate from the F0015 table. If an exchange rate is not set up, the system prints a blank report. If you leave this processing option blank, the report prints amounts in the domestic currency.