Display Accounts Receivable Statistics

When you click AR, the Executive Information Summary (EIS) program displays accounts receivable statistics.

The following rules apply to customer account data views when accounts receivable consolidation (ARC) is used:

  • Sales, bookings, cancellations, and RMA returns are only updated to the sold-to customer number.

  • Invoices, payments, A/R adjustments, and finance charges are only updated to the ARC customer number.

Field Name

Displays

Invoices/debit memos

Month/period column: Total value of invoice (DI) and debit memo (DM) transactions in the current period; this value equals MTD net invoices on the first Executive Information Summary screen

Actions that update this value:

  • Invoice a shipment with AR Invoice Register (RR)

Other columns: See below.

Credit memos

Month/period column: Total value of credit memo (CM) transactions during the current period; credit memos can be entered in the One-Step Invoice Entry (RE) program, issued with the RMA Maintenance (RMA) program, or by the system when you receive returned material

Actions that update this value:

  • Invoice a credit with AR Invoice Register (RR); the credit memo can be entered with One-Step Invoice Entry (RE), issued with RMA Maintenance (RMA), or the system when you receive returned material

Other columns: See below.

Adjustments

Month/period column: Total value of adjustments (CA and DA transactions) entered in the Cash Receipts Entry (RCE) or AR Adjustments Entry (RB) programs during the current period

Actions that update this value:

  • Process an credit (CA) or debit (DA) adjustment with Cash Receipts Entry (RCE) or AR Adjustments Entry (RB)

Other columns: See below.

Write-offs

Month/period column: Total value of write-offs (WO transactions) made in the Cash Receipts Entry (RCE) or AR Adjustments Entry (RB) programs during the current period

Actions that update this value:

  • Process a write-off (WO) with Cash Receipts Entry (RCE) or AR Adjustments Entry (RB)

Other columns: See below.

Deposits

Month/period column: Current total value of all deposits (DP transactions) entered in the Cash Receipts Entry (RCE) program, although not necessarily applied to orders

Actions that update this value:

  • Process a deposit (DP) with Cash Receipts Entry (RCE)

Other columns: See below.

Payments

Month/period column: Total value of all payments (PY transactions) applied in the Cash Receipts Entry (RCE) program during the current period; this value equals MTD payments on the first Executive Information Summary screen

Actions that update this value:

  • Process a payment (PY) with Cash Receipts Entry (RCE)

  • Reverse a payment with AR Payment Reversal (RVC)

Other columns: See below.

Finance charges

Month/period column: Total value of all finance charges (DI transactions) processed with the Finance Charge Calculation (RFC) and Finance Charge Register (RFR) programs for the current period

Actions that update this value:

  • Process finance charges with Finance Charge Calculation (RFC)

Other columns: See below.

Discounts given

Month/period column: Total value of all terms discounts given when payments are processed in the Cash Receipts Entry (RCE) program in the current period; this value equals MTD discounts on the first Executive Information Summary screen

Actions that update this value:

  • Process a payment (PY) that qualifies for a terms discount with Cash Receipts Entry (RCE)

  • Reverse a payment with AR Payment Reversal (RVC)

Other columns: See below.

Column heading:

Year-to-date
This month last year
Last month
Enterprise
Enterprise YTD
Last year total
Last YTD

For each category of statistics:

Total for the year-to-date
Total for the current month/period last year
Total for the last month
Month-to-date total for the enterprise
Year-to-date total for the enterprise
Last year total (end of year) for the enterprise
Last year's year-to-date total

  1. Choose the appropriate options:

To

Do This

Display transactions for the selected category

Highlight the category and click Detail or double click the line. See Display AR Transactions. Click OK to return to this screen.

Display AR balances for customers

Highlight the category and click Customers. See Display AR Customer Balances. Click OK to return to this screen.

Display the balance due for each aging category

Highlight the category and click Aging. See Display AR Aging. Click OK to return to this screen.

Print the displayed data

Click Print. See Print an Inquiry.

Return to the Executive Information Summary screen

Click OK See Display Executive Information Summary Statistics.

Exit and return to the menu

Click Quit.