Detail Aging Report

How to print: This report prints when you select Accept at the A/R Aging Reports Screen (MPAR) if the Detail aging report flag is selected.

For more information: See the sample report in PDF format.

Note: This report is also available as a CSV (comma-separated value) file, which you can open in a spreadsheet application such as Microsoft Excel^®. See Reports Available in CSV (Spreadsheet) Format for more information.

Contents:

• selection criteria:

• balance due minimum, if specified

• minimum number of days past due, if specified

• bill-to account number

• company name and address

• bill-to customer's credit limit

• bill-to customer's total open accounts receivable

• total open orders for the bill-to customer

• phone numbers: daytime, evening, and third (fax or mobile, based on the setting of the Third Phone Number Type (L53) system control value)

• for each of the customer's open items:

• open item type, as defined in the A/R Type table

• invoice number

• date when the invoice was created

• date when the invoice is/was due

• total invoice amount; a minus sign indicates a credit

• discount, if any

• paid amount, if any

• balance remaining on the invoice

• date when the open item was paid in full

• totals due in each aging bucket you have set up in the System Control table for each bill-to customer (Note: The first row of aging buckets represents the regular aging buckets for the bill-to customer, calculated either by the open items' due date or the invoice date depending on the setting of the Age by Date Type (C02) system control value. The second row of aging buckets represents the cash aging buckets for the bill-to customer, calculated based on the open items' expected receipt date.)

• totals due in each aging bucket for all customers on the report