Detail Aging Report

How to print: This report prints when you press F9 at the A/R Aging Reports Screen if the Detail aging report field is set to Y.

CWDirect Rel 3.5 Detail Aging Report EKAPLAN ACR0087 9/29/98 12:27:39 Page 3

EZK Mail Order

Current period: 9/01/98 - 9/30/98

Selection criteria:

Balance Due (greater than or equal to) 500.00

121 days past due

Account No. Name/Address

155 Credit limit . : 10000

MR. PETER W VAN VOORHIS Open A/R . . . : 592.18

78 HARLEM STREET 3 On Order . . . : 20.96

Phone #'s - Day : (508) 555-1111

Eve :

Fax :

WORCESTER MA 01701

Invoice No. Inv date Due date Amount Discount Paid Balance Pay date

IN 1348 9/26/97 9/26/97 210.00 .00 .00 210.00

IN 1351 9/28/97 9/28/97 20.96 .00 .00 20.96

IN 1352 9/28/97 9/28/97 20.96 .00 .00 20.96

CM 1355 9/29/97 9/29/97 210.00 .00 .00 210.00

CM 1356 9/29/97 9/29/97 20.96 .00 .00 20.96

CM 1354 9/29/95 9/29/97 20.96 .00 .00 20.96

IN 1365 10/12/97 10/12/97 20.96 .00 .00 20.96

IN 1689 11/30/97 11/30/97 6.19 .00 .00 6.19

IN 1692 11/30/97 11/30/97 36.19 .00 .00 36.19

22 964 1/25/98 1/31/98 25.00 .00 .00 25.00

CURRENT 1-30 31-60 61-90 91-120 121+ Open A/R

Aging . . : .00 .00 .00 .00 .00 592.18 592.18

Cash aging : .00 .00 .00 .00 .00 592.18 592.18

----------------------------------------------------------------

CURRENT 1-30 31-60 61-90 91-120 121+ Open A/R

Aging . . : 0.00- 1,174.10- 960.18 123.20 3,784.00 18,189.83 21,883.11

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

• bill-to phone numbers:

• day

• evening

• third (fax or mobile, based on the setting of the Third Phone Number Type (L53) system control value)

• fr each of the customer's open items:

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

• 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 file 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

AR04_03r CWDirect 18.0 August 2015 OTN