Viewing Customer A/R Information

Field

Description

Cust

The customer's name.

Start

The date the customer account was originally opened.

As of

The date that determines what transactions are listed and the aging of all account balances displayed.

Contact/Phone

The first two contacts and associated phone numbers. The system populates this field from the information in the Customer/Phone field on the Customer Maintenance screen.

Future

The part of the customer's balance that is due but that has not yet appeared on a statement.

Current

The part of the customer's balance that has been billed and is due in the current period.

31-60

The part of the customer's balance that is between 31 and 60 days overdue.

61-90

The part of the customer's balance that is between 61 and 90 days overdue.

91-120

The part of the customer's balance that is between 91 and 120 days overdue.

Over 120

The part of the customer's balance that is over 120 days overdue.

Total

The total balance due from the customer.

Deposits

The total of all deposits made by the customer against open orders.

Orders

The dollar value of material that has been ordered but not yet shipped to the customer.

MTD Sales

The customer's month-to-date sales total.

YTD Sales

The customer's year-to-date sales total.

6-Mo Avg

The average balance due from the customer over the six or twelve months prior to the last running of the Credit Statistics Calculation program.(A/R / Utilities/ Credit Statistics Calculations).

Note: This information is updated only if the cash receipt information is entered using the customer's name.

6-Mo or 12Mo High

The highest total balance due from the customer over the six or twelve months prior to the last running of the Credit Statistics Calculation program.

Note: This information is updated only if the cash receipt information is entered using the customer's name.

Pmt Days

The average of the number of weighted days to pay since the last time the customer had a zero balance. This number is based on data from the previous six months, and is calculated when the Credit Statistics Calculation program is run.

For example, if the transaction includes three cash receipts for an invoice of $400, the receipts might be laid out as follows:

$100 is paid seven days from the invoice date

$200 is paid 14 days from the invoice date

$100 is paid 21 days from the invoice date

The formula for calculating the average days to pay for all three invoices works as follows:

{(100 x 7) + (200 x 14) + (100 x 21)} / 400 = 14 days.

Note: Negative invoice amounts will not be included in the payment days calculation.

Terms

The customer's payment terms. The system populates this field with information from the Terms Code field on the Customer Maintenance screen.

Cr Limit

The customer's credit limit. The system populates this field with information from the Credit Limit field on the Customer Maintenance screen.

Avl

The difference between the customers Credit Limit and Total balance due.

This amount can be affected by the addition of lot items to open orders and the invoicing and payment of lot items. For more information, see Lot Billing.

Last Sale

The date and amount of the last sale to the customer.

Last Pmt

The date and amount of the customer's last payment. This field reflects actual cash receipts, not zero dollar cash receipts that you enter to adjust an account.

Total Discount Avl

The amount of the discount available to the customer if future balances are paid off on or before the due date.

Balance after Disc

The amount of payment due if future balances are paid off on or before the due date and the discount is applied.

Reference #

The sales order number, check number, or cash payment number of the transaction.

If you enter a reference number and there is a match between sales order numbers or associated purchase order numbers, the system displays a list of those numbers that match.

Br

The branch that receives credit for the transaction.

Date

The posting date of the transaction.

Amount

The amount of the transaction.

Payment

The amount that was applied to the original transaction.

Pmt Date

The date the payment was made.

Balance

The remaining balance for the transaction.

Age

The aging category to which the transaction belongs.

Hot Key

Function

$

Allows you to change the currency used on this screen. For more information, see Foreign Exchange Rates Overview.

Note

Displays the Customer Activity Log Entry screen, where you can enter notes regarding the customer. For more information, see Creating and Viewing Trackers For Specific Customers.

Dt

Moves the cursor to the As of field, where you can change the as of date for this inquiry.

Prt

Prompts you to enter a date range and then produces reprints of all the invoices within that range. For more information, see Reprinting Invoices.

Rank

Displays the Customer Ranking screen, where you can view how this customer compares to other customers based on the ranking methods defined on the Customer Ranking screen. For more information, see Ranking Customers.

AR Led

Displays the A/R Ledger screen, where you can view every transaction that has affected an account's A/R balance. For more information, see A/R Ledger Overview.

View

Displays order entry information for the transaction on which the cursor is placed in view-only mode.

Edit

Displays order entry information for the transaction on which the cursor is placed in edit mode.

If the cursor is on a deposit, using this hot key displays the Deposit Viewing screen, but does not let you edit the deposit. You must edit a deposit from within the sales order.

Audit

Displays the A/R or A/P Item Audit screen, which displays aging information for the transaction. For more information, see Viewing A/R Aging Information.

Inq

Displays the Additional A/R Inquiries screen, which contains hot key links to screens containing additional information related to this customer.

Log

Displays the Customer Activity Log Viewing screen, which lists the activity log entries for this customer. For more information, see Activity Logs Overview.

AR Sum

Displays the A/R Summary screen, which displays the balance due and aging buckets for both bill-to and ship-to customers, as well as pay-to and ship-from vendors. For more information, see Viewing A/R Balances Summaries.

LogCall

Displays the A/R Collection Log Call screen, where you can log a call, or other collection action, as well as schedule a Next Call date. For more information, see Logging Collection Calls.

6/12

Changes the display of the 6-Mo Avg and 6-Mo High fields to 12Mo Avg and 12Mo High, and then allows you to change them back again.

Reset

Resets the screen to the Balance Forward view after you have used the View hot key.

This hot key is only active when the Display Aging Invoices From Balance Forward Perspective control maintenance record has been set to Y, and the Bal Fwd/Open Time field on the Customer Maintenance screen has been set to B. For more information, see Creating Customer Records.

ChgV

Changes the information available on the screen. Select from one of the following:

• Reference # – Displays information based on the system-generated reference number. This is the default.

• Customer /PO #– Displays information based on the customer or purchase order number.

• Old Invoice # – Displays information based on the legacy invoice numbers.

For each of these options you can search for a customer in one of two ways:

• Enter a reference number to select a particular transaction. If the system finds a match, it places the cursor on the line item of the related order.

• Enter a partial reference number and select from the displayed selection list of reference numbers that match the criteria you entered.