Using A/R Inquiry (DARI)

Using A/R Inquiry (DARI)

Purpose: Use Accounts Receivable (A/R) Inquiry to display and, in some cases, change specific details of bill-to accounts. Using A/R Inquiry you can:

• work with open invoice items

• display the details of an order

• display the details of an invoice

• display the details of customer payments

• display current and past due open balances

• enter notes for bill-to accounts

• perform an inquiry against an order

In this topic:

• Select Customer Bill-To Screen (A/R Inquiry)

• Work with Open Items Screen

• Second Work with Open Item Screen (Changing A/R Open Items)

• Display A/R Open Item Screen

• Display Payment Detail Screen

• Display Order Detail Screen (A/R Inquiry)

• Display Customer Bill To Payments Screen

• Customer A/R Sales History Screen

• Display Aging Pop-Up Window (A/R Inquiry)

• Work with Bill To Notes Screen (Entering Notes About an A/R Account)

Select Customer Bill-To Screen (A/R Inquiry)

Purpose: Use this screen to select a bill-to customer for inquiry.

Customer Workflow Management window: The Customer Workflow Management Window automatically displays when you select a bill to customer if open or in use ticklers exist for the bill to customer. Select Ticklers at this window to advance to the Work with Ticklers Screen (bill-to customer view) where you can review and work with ticklers associated with the bill to customer.

How to display this screen: Enter DARI in the Fast path field at the top of any menu, or select A/R Inquiry from a menu; see Using A/R Inquiry (DARI).

Field	Description
Customer bill-to	A system-generated customer number assigned to a bill-to customer. See Creating and Updating Bill-to Customers (WCBT). Enter a valid bill-to customer number to advance to the Work with Open Items Screen. Numeric, 7 positions; optional.
Customer sold-to	A system- generated customer number assigned to a sold-to customer. See Creating and Updating Sold-to Customers (WCST). Enter a valid sold-to customer number to advance to the Work with Open Items Screen. Numeric, 9 positions; optional.
Invoice #	A system generated number assigned to an invoice. Enter an invoice number to advance to the Work with Open Items Screen. Numeric, 7 positions; optional
Order #	A system generated number assigned to a customer order. Enter a valid order number to advance to the Scan Customer Bill To by Order Number (see Working with Scan Customer Bill-to Screens) or the Work with Open Items Screen. Numeric, 8 positions; optional.
Postal code	The Post Office zip code that identifies the customer's location. Enter a postal code to advance to the Scan Customer Bill To by Zip/Last Name screen (see Working with Scan Customer Bill-to Screens). Scan length: The Postal Code Scan Length (F61) system control value controls how many characters of the postal code to use when searching for a customer. See that system control value for a discussion. Note: You can combine postal code and last name, or the postal code and the company name to narrow your search. See the Last name and Company field descriptions. Numeric, 10 positions; optional.
Last name	The customer's last name. Enter a full or partial name to advance to the Scan Customer Bill To by Last Name screen (see Working with Scan Customer Bill-to Screens). If you combine postal code and a full (not partial) last name, you advance to the Scan Customer Bill To by Zip/Last Name screen, which displays accounts that follow your entry alphanumerically. Alphanumeric, 25 positions; optional.
Company	The name of the customer's company. Enter a full or partial company name to advance to the Scan Customer Bill To by Company name screen (see Working with Scan Customer Bill-to Screens). If you combine postal code and company, you advance to the Scan Customer Bill To by Zip/Company screen. Alphanumeric, 30 positions; optional.
Telephone #	The customer's telephone number. Enter a full or partial phone number to advance to the Scan Customer Bill To by Phone number screen (see Working with Scan Customer Bill-to Screens). You can define a telephone number format for each country to map to the phone numbers operators enter into the system. See Setting Up the Country Table (WCTY). You can also define an external program to validate the phone numbers you enter. See Setting Up General Usage Values. Optional.
Alt cust number (Alternate customer number)	An additional number that further identifies a sold-to customer. This might be a serial number or a customer number from another system. Enter an alternate customer number to advance to a subsequent scan screen that lists customers by alternate customer number. See Display Alternate Customer Cross Reference Window (I84) for more information. Alternate Customer Number Label Description The field label name on this screen is based on the name you enter in the Alternate Customer Number Label Description (H95) system control value; if you do not enter a name in this system control value, the field label is Alt cust number. Example: If you enter the field label name MEMBER# in the system control value, the field label name on this screen is MEMBER#. Alphanumeric, 15 positions; optional.

Screen Option	Procedure
Work with Cash Receipts	Select Cash Receipts to advance to the Cash Receipts Screen (Cash Batch Settings).

Work with Open Items Screen

Purpose: This screen displays all accounts receivable (A/R) invoice records on a customer account. You cannot change any information on this screen; however, you can:

• display an invoice

• display payment details of an invoice

• display order details

• display invoice details and payment methods

• advance to standard order inquiry

How to display this screen: At a Scan Cust Bill To screen, select an open item and or enter a valid bill-to, sold-to, open item, or order number at a Select Customer Bill To screen. See Select Customer Bill-To Screen for information on scanning.

Field	Description
Cust (Bill-to customer number)	A system-assigned number that identifies a customer billing account. See Creating and Updating Bill-to Customers (WCBT). Numeric, 7 positions; display-only.
Company name	The name of the company associated with an A/R customer account. Alphanumeric, 30 positions; display-only.
Bill to name (Unlabeled field below the Cust field)	The name associated with an A/R customer account. Alphanumeric, 35 positions; display-only.
A/R on order	The total dollars on open, unshipped orders with an accounts receivable payment method for this account. Note: The balance in this field may not accurately reflect customer on order balance if you have maintained an order by adding or cancelling a line, and during the same transaction deleted the order’s original pay type and added an A/R pay type. When you reset customer bill-to on order amounts, using the Resetting Open A/R (TARO) menu option, the inaccuracy will be corrected. Numeric, 9 positions with a 2-place decimal; display-only.
Total A/R	The total dollar amount due from or owed to the accounts receivable customer; a negative amount indicates a credit balance. All credit open invoices, regardless of their status and type, decrease this balance; all debit open items increase it. Numeric, 13 positions with a 2-place decimal; display-only.
Credit limit	The total amount available for a customer to order on-account. Numeric, 7 positions; display-only.
Last statemnt (Last statement date)	The date when you last generated a statement summarizing the status of the customer's account. The statement lists each open (unpaid) invoice on the customer's account and readily identifies the total account balance. Numeric, 6 positions (MMDDYY format); display-only.
Terms	The description of the method by which payment is due. For example, one term requires payment within 30 days of the invoice date, while another requires payment at the end of the month. Alphanumeric, 30 positions; display-only.
S (Status)	A code identifying the current status of an invoice item. Status codes are: • A = Allocated. Allocating credit open items toward a different order is available only if the Allow A/R Credits as Payments (E81) system control value is selected. You can also allocate a credit toward unshipped lines on the same order when you process a return or exchange if the Process A/R Credits Immediately (E80) system control value is selected. You can not apply allocated open items against invoice open items until the order is billed or canceled, or the open item is unallocated; see Second Work with Open Item Screen (Changing A/R Open Items). • O = Open. An unpaid (for an invoice) or unrefunded (for a credit) balance exists. • P = Processed. Indicates that an invoice open item is paid, or a credit open item has been fully refunded, used as payment on an order, or applied toward an invoice open item. Also, indicates that an invoice open item was written off.
	Note: If an open item of the default refund check open item type is in a processed status, it does not necessarily indicate that a check was sent to the customer. If a credit open item is allocated as payment of a new order and to produce a refund check for the unused balance ( at the Select A/R Credit pop-up window in order entry/maintenance), but the entire credit balance is exhausted when it is applied to the order, the open item will also have a status of P and a refund check open item type. • D = Disputed. An unpaid or unrefunded balance is in dispute. Alphanumeric, 1 position; optional.
Inv # (Invoice number)	A system-assigned number that identifies a bill for an accounts receivable purchase or a credit invoice. Certain open items, such as on-account payments or credit resulting from a cancellation of a prepaid order, will have an invoice number of 0. Numeric, 7 positions; optional.
TC (Type)	A user-defined code that identifies an A/R open item type. A/R type categories may include credits, debits, credit memos, invoices, and on-account items. A/R type codes are defined in and validated against the A/R Type table. The system retrieves the appropriate A/R type for a transaction by checking the values from the System Control table (or, for on-account and sundry transactions, the system retrieves the first appropriate type it finds in the A/R Type table). See Establishing Accounts Receivable Types (WART) for more information on the default A/R types you can create.
	You can flag a credit open item to produce a refund check or a credit card credit, which you can then process through the Process A/R Refunds menu option (see Processing A/R Refunds (MARC)). These credit open items are indicated by their A/R types, from the Default Check Credit Open Item Type (E82) and Default Credit Card Credit Open Item Type (E83) System Control values. You cannot apply these credits as payment toward invoice open items. Numeric, 2 positions; optional.
Order #	A system-assigned number that identifies the order that produced the credit or invoice open item. Numeric, 7 positions; optional.
Inv date	The date when an invoice was paid in full, or when a payment was most recently applied from a credit. Numeric, 6 positions (MMDDYY format); display-only.
Due date	The date when payment is required for the open item. Numeric, 6 positions (MMDDYY format); optional.
Select Pay date/Due date to switch the display between due date and pay date.
Amount	The total, original amount of the invoice or credit before applying any credits, payments, or discounts. Both credits and invoices are presented as positive amounts. Numeric, 9 positions with a 2-place decimal; optional.
Discount	The dollar amount that is credited to an open invoice. Numeric, 10 positions with a 2-place decimal; optional.
Balance	The dollar amount that the customer still owes on an invoice, or that is still available on a credit. Numeric, 9 positions with a 2-place decimal; optional.

Screen Option	Procedure
Display an open item	Select Display for an open item to advance to the Display A/R Open Item Screen.
Display payment details	Select Display payment details for an open item to advance to the Display Payment Detail Screen.
Change an open item	Select Work with open items for an open item to advance to the Second Work with Open Item Screen (Changing A/R Open Items).
Switch between Pay date and Due date display	Select Pay Date/Due Date. See the Inv date and Due date field descriptions.
Work with ticklers associated with the bill-to customer	Select Ticklers to advance to the Work with Ticklers Screen (bill-to customer view).
Review payments	Select Payments to advance to the Display Customer Bill To Payments Screen.
Review account aging	Select Aging to advance to the Display Aging Pop-Up Window (A/R Inquiry).
Review sales history	Select Customer History to advance to the Customer A/R Sales History Screen.
Print statements	Select Print Statements. See Printing Statements (PSTS).
Enter notes about a bill-to account	Select Notes to advance to the Work with Bill To Notes Screen (Entering Notes About an A/R Account).

Second Work with Open Item Screen (Changing A/R Open Items)

Purpose: Use this screen to change a open item record, including:

• putting an open item into or out of dispute (using the Disputed and the Dispute reason fields)

• unallocating an allocated credit open item (using the Status field)

• changing a credit open item to another credit open item type (using the Type field)

How to display this screen: Select Work with open items for an open item at the Work with Open Items Screen.

Field	Description
Open item #	A system-assigned number that identifies an invoice, credit, or on-account open item. Numeric, 7 positions; display-only.
Type	A code that identifies an A/R record type. You can change the A/R type field only under the following conditions: • only credit (not invoice or on-account) open items can be changed • you can change a credit open item only to another type of credit (for example, from a refund check credit open item to a regular credit open item, if you no longer want to produce a refund check to the customer for the credit balance) • you can change a credit to a credit card credit open item type only if the credit was produced by an order that used a credit card A/R type codes are defined in and validated against the A/R Type table; see Establishing Accounts Receivable Types (WART). Note: The Change A/R Credit Open Item Status/Type (A68) secured feature controls access to this field. Numeric, 2 positions; optional.
Pay category	A code that identifies a pay category. A pay category is a group of payment methods. Pay categories are: • Cash/check • C.O.D. (Cash on delivery) • A/R • Credit card • Coupon/Credit Display-only.
Status	A code identifying the current status of an invoice item. Status codes are: • A = Allocated. This is a credit open item that is currently allocated as payment toward an open order. Allocating credit open items toward a different order is available only if the Allow A/R Credits as Payments (E81) system control value is selected. You can also allocate a credit toward unshipped lines on the same order when you process a return or exchange if the Process A/R Credits Immediately (E80) system control value is selected. You can not apply allocated open items against invoice open items until the order is billed or canceled, or the open item is unallocated.
	Changing status: You can change the status of the open item only if the current status is A and you want to change it to 0. You would make this change to unallocate an allocated credit; in this case the Allocated to order number will be deleted as well. • O = Open. An unpaid balance (for invoices) or unapplied credit balance (for credits) exists. • P = Processed. The credit open item has been applied, or the debit open item has been paid. Also, for open items whose entire balance has been written off. • D = Disputed. An unpaid balance is in dispute. To change an open item's status to D, enter an amount in the Disputed field, and a reason code in the Dispute reason field. The status remains D until you clear these fields. The transactions you can perform if an open item is in dispute are restricted. See Working with Invoice Open Items. Note: The Change A/R Credit Open Item Status/Type (A68) secured feature controls access to this field. Alphanumeric, 1 position; optional.
Allocated to order number	The order number on which the credit open item is allocated to be applied as payment. Allocating credit open items toward a different order is available only if the Allow A/R Credits as Payments (E81) system control value is selected. You can also allocate a credit toward unshipped lines on the same order when you process a return or exchange if the Process A/R Credits Immediately (E80) system control value is selected. If you change the status of the open item from allocated (A) to open (O), the allocated order number is deleted from the open item record. The order number is also deleted when the order is billed or canceled. You cannot apply an allocated credit against an invoice open item. Numeric, 8 positions; display-only.
Currency	The currency used on the order. This field is not currently implemented. Alphanumeric, 3 positions; display-only.
Open item date	The date the invoice or credit open item was created. Numeric, 6 positions (MMDDYY format); display-only.
Discount due date	The date when the customer must pay an invoice open item to be eligible for a discount. Numeric, 6 positions (MMDDYY format); optional.
Due date	The date when the customer is required to make payment on an open invoice. Numeric, 6 positions (MMDDYY format); optional.
Expected receipt date	The date when you expect to receive payment against the invoice. Numeric, 6 positions (MMDDYY format): display-only.
Total A/R	The amount the customer originally owed for the invoice, or was due for the credit. Both invoice and credit balances are presented as positive values. This is the value in the Total amt field on the Pay Open Items Screen. Numeric, 10 positions with a 2-place decimal; display-only.
Discount	The total amount of any discount that applied to the invoice open item. Numeric, 10 positions with a 2-place decimal; display-only.
Balance	The amount the customer currently owes for the invoice, or is due for the credit. Both invoice and credit balances are presented as positive values. This is the value in the Balance field on the Pay Open Items Screen. Numeric, 9 positions with a 2-place decimal; display-only.
Disputed	The total amount of the balance that is in dispute. Enter a dispute amount here and a reason code in the Dispute reason field to change the status of an invoice to D. The open item will remain in dispute until you clear these fields. You can put both credit and invoice open items in dispute. See Working with Invoice Open Items for more information on the transactions you can perform against disputed open items. Numeric, 9 positions with a 2-place decimal; optional.
Paid	The total payment or credit amount that has been applied to an invoice, or applied from a credit. This is the value in the Paid amt field on the Pay Open Items Screen. Numeric, 10 positions with a 2-place decimal; display-only.
Paid date	The date an invoice open item was paid in full, or the most recent date when a portion of a credit open item was applied. Numeric, 6 positions (MMDDYY format); display-only.
Debit G/L # (Debit general ledger account number)	A number that identifies the sales general ledger account used for posting the debit transaction. General ledger numbers validate against the General Ledger Accounts table. See Working with G/L Accounts (WGLA). Numeric, 8 positions; display-only.
Credit G/L # (Credit general ledger account number)	A number that identifies the sales general ledger account used for posting the credit transaction. General ledger numbers validate against the General Ledger Accounts table. See Working with G/L Accounts (WGLA). Numeric, 8 positions; display-only.
Order #	A system-assigned number that identifies the order number that generated the open item. Numeric, 7 positions; display-only.
Invoice #	A system-assigned number that identifies the debit or credit invoice that produced the open item. Numeric, 7 positions; display-only.
Cust sold to (Customer sold-to)	The customer who places an order. See Creating and Updating Sold-to Customers (WCST). Number: numeric, 8 position; display-only. Name: alphanumeric, 41 positions; display-only.
Cust bill to (Customer bill-to)	The customer responsible for paying for an order. See Creating and Updating Bill-to Customers (WCBT). Number: numeric, 8 position; display-only. Name: alphanumeric, 41 positions; display-only.
Salesman	The sales representative credited for the order. Salesman codes are defined in and validated against the Salesman table; see Working with Sales Representatives (WSLS). Code: numeric, 7 positions; display-only. Name: alphanumeric, 30 position; display-only.
Terms	A code that identifies when and under what conditions payment is due. Terms codes can apply to accounts receivable, accounts payable, or both, and are defined in and validated against the Terms table; see Working with Terms (WAPT). Numeric, 2 positions; display-only.
Dispute reason	A code that identifies why an invoice is in dispute. Enter a code here and an amount in the Disputed field to change the status of an open item to D (disputed). Dispute reasons are defined in and validated against the Dispute Reason Code table. See Establishing Dispute Reason Codes (WDSR). You can put both credit and invoice open items in dispute. See Working with Invoice Open Items, for more information on the transactions you can perform against disputed open items. Alphanumeric, 2 positions, optional.
Short note	Text entered about changes made to the open item. Alphanumeric, 25 positions; display-only.

To change: Update the necessary fields and select OK.

For more information: There are additional updates available to an open item available through the cash receipts menu option. Specifically, you can change the Discount due date, Expected receipt date, Terms, and Short note fields by selecting Change for an open item at the Pay Open Items Screen and advancing to the Change A/R Open Item Screen.

Display A/R Open Item Screen

Purpose: Use this screen to display the details of an invoice or credit open item issued against a customer account.

How to display this screen: Select Display for an invoice at the Work with Open Items Screen.

Field descriptions: Each field on this screen is described under Second Work with Open Item Screen (Changing A/R Open Items).

Screen Option	Procedure
Toggle between displaying the Total A/R, Discount, Balance, Disputed, and Paid amounts in the local currency and the alternate currency	Select Toggle Alternate Currency. The system toggles the Total A/R, Discount, Balance, Disputed, and Paid amounts between the local currency and alternate currency. Additionally, when viewing the amount in the alternate currency, the Currency code field displays in the upper right corner of the screen indicating the currency of the alternate amount. This function displays only if the Use Alternate Currency Pricing (H89) system control value is selected. If you select Toggle Alternate Currency and the open item is not associated with an alternate currency, an error message indicates: No conversion rate for offer.

Screen Option

Procedure

Toggle between displaying the Total A/R, Discount, Balance, Disputed, and Paid amounts in the local currency and the alternate currency

Select Toggle Alternate Currency. The system toggles the Total A/R, Discount, Balance, Disputed, and Paid amounts between the local currency and alternate currency. Additionally, when viewing the amount in the alternate currency, the Currency code field displays in the upper right corner of the screen indicating the currency of the alternate amount.

This function displays only if the Use Alternate Currency Pricing (H89) system control value is selected.

If you select Toggle Alternate Currency and the open item is not associated with an alternate currency, an error message indicates: No conversion rate for offer.

Display Payment Detail Screen

Purpose: Use this screen to display the details of each payment posted to an invoice or applied from a credit. You can scan for a specific payment by the payment type, pay date, amount paid, amount discounted, or amount written off or adjusted.

Note: Depending on the user’s authority to credit card information, the system writes a record to the Credit Card Audit table when this screen is displayed. See Logging Credit Card Data Access in the Data Security and Encryption Guide for more information.

How to display this screen: Select Display payment details for an invoice at the Work with Open Items Screen.

Field	Description
Currency code	The currency of the payment amounts. You can toggle between displaying the amounts in the local currency and alternate currency if you Use Alternate Currency Pricing (H89) and you select Toggle AC. If you are viewing the amounts in the alternate currency, the currency is indicated; if you are viewing the amounts in the local currency, the currency is not indicated. This field is included only if the Use Alternate Currency Pricing (H89) system control value is selected and the order is associated with an alternate currency. Alphanumeric, 3 positions; display-only.
Open item #	A system-assigned number that identifies an invoice or credit open item. Numeric, 7 positions; display-only.
Type	A code that identifies the A/R type. A/R type categories may include; credits, debits, credit memos, invoices, and on-account categories. A/R type codes are defined in and validated against the A/R Type table; see Establishing Accounts Receivable Types (WART). Alphanumeric, 2 positions; display-only.
Status	A code identifying the current status of an invoice or credit open item. Status codes are: • Allocated = Allocated. This is a credit open item that is allocated toward payment of an open order. • Open = Open. An unpaid or unapplied balance exists. • Processed = Paid. The item is paid in full or the item’s entire open balance is written off. • Disputed = Disputed. All or part of the balance is in dispute. Alphanumeric, 1 position; display-only.
Cust bill to (Customer bill-to number)	A system-assigned number that identifies a bill-to customer. Numeric, 8 positions; display-only.
Bill to name (Unlabeled field next to the Cust bill to field)	The name on a bill-to customer account. Alphanumeric, 42 positions; display-only.
Order #	A system-assigned number that identifies the order that generated the open item. Numeric, 7 positions; display-only.
Invoice #	A system-assigned number that identifies the invoice or credit invoice that produced the open item. Numeric, 7 positions; display-only.
Due date	The date when the customer is required to make payment on an open invoice. Numeric, 6 positions (MMDDYY format); display-only.
Disc due date (Discount due date)	The date when a customer must pay for an invoice to receive a discount. Discount percentages are defined in the Terms table. Numeric, 6 positions (MMDDYY format); display-only.
Open item amt	The original dollar amount of the open item. Alternate currency pricing: You can toggle between viewing the open item amount in the local currency and the alternate currency by selecting Toggle Alternate Currency if the Use Alternate Currency Pricing (H89) system control value is selected and the open item is associated with an alternate currency. Numeric, 9 positions with a 2-place decimal; display-only.
Balance	The dollar amount remaining to be paid or credited on the open item. Alternate currency pricing: You can toggle between viewing the balance in the local currency and the alternate currency by selecting Toggle Alternate Currency if the Use Alternate Currency Pricing (H89) system control value is selected and the open item is associated with an alternate currency. Numeric, 9 positions with a 2-place decimal; display-only.
Crdt G/L	The account against which a credit transaction is posted. General ledger numbers validate against the General Ledger accounts table. See Working with G/L Accounts (WGLA). Numeric, 8 positions; display-only.
Type	A code that identifies an A/R record type. This field is not currently implemented. Alphanumeric, 2 positions; optional.
Pay date	The date when cash is received for an invoice or applied from a credit. Numeric, 6 positions (MMDDYY format); optional.
Paid amount	The amount applied to an invoice or from a credit. Alternate currency pricing: You can toggle between viewing the paid amount in the local currency and the alternate currency by selecting Toggle Alternate Currency if the Use Alternate Currency Pricing (H89) system control value is selected and the open item is associated with an alternate currency. Numeric, 10 positions with a 2-place decimal; optional.
Disc amount (Discount amount)	The amount deducted from the open invoice at the time of this payment. Alternate currency pricing: You can toggle between viewing the discount amount in the local currency and the alternate currency by selecting Toggle Alternate Currency if the Use Alternate Currency Pricing (H89) system control value is selected and the open item is associated with an alternate currency. Numeric, 10-positions with a 2-place decimal; optional.
Wrt-off/adj amt (Write-off/adjustment amount)	The dollar amount credited to the open invoice at the time of this payment. Alternate currency pricing: You can toggle between viewing the write-off/adjustment amount in the local currency and the alternate currency by selecting Toggle Alternate Currency if the Use Alternate Currency Pricing (H89) system control value is selected and the open item is associated with an alternate currency. Numeric, 10-positions with a 2-place decimal; optional.
Balance remaining	The dollar amount on the invoice that the customer still owes after posting this payment. Alternate currency pricing: You can toggle between viewing the balance remaining in the local currency and the alternate currency by selecting Toggle Alternate Currency if the Use Alternate Currency Pricing (H89) system control value is selected and the open item is associated with an alternate currency. Numeric, 9-positions with a 2-place decimal; display-only.
G/L numbers	A number that identifies an account used for posting this transaction. The general ledger account number appears below the corresponding transaction. General ledger numbers are defined in and validated against the General Ledger Accounts table. Numeric, 8-positions, display-only.
Routing #	The routing number, if any, associated with the A/R payment. This field is informational only. Typically, a routing number is provided when you upload A/R payments using the ARBATCH_IN process in Working with Integration Layer Processes (IJCT). See Uploading A/R Batch Payments for an overview. Numeric, 9 positions; display-only.
Account #	The account number, if any, associated with the A/R payment. This field is informational only. Typically, a routing number is provided when you upload A/R payments using the ARBATCH_IN process in Working with Integration Layer Processes (IJCT). See Uploading A/R Batch Payments for an overview. Alphanumeric, 20 positions; display-only.

Screen Option	Procedure
Toggle between displaying the payment amounts in the local currency and the alternate currency	Select Toggle Alternate Currency. The system toggles the Open item amount, Balance, Paid amount, Discount amount, Write-off/adjustment amount, and Balance remaining between the local currency and alternate currency. Additionally, when viewing the amount in the alternate currency, the Currency code field displays in the upper right corner of the screen indicating the currency of the alternate amount. This function displays only if the Use Alternate Currency Pricing (H89) system control value is selected. If you select Toggle Alternate Currency and the order is not associated with an alternate currency, an error message indicates: No conversion rate for offer.
Display order details	Select Display Order. See Display Order Detail Screen (A/R Inquiry).
Display invoice details	Select Display Invoice. See Reviewing Order Details for a complete description of the fields and options on this screen.
Advance to standard order inquiry	Select Order Inquiry. See Using the Order Inquiry Scan Screens (OIOM).

Display Order Detail Screen (A/R Inquiry)

Purpose: Use this screen to review the details of each item on an order. Use the fields at the top of the screen to scan for the details of a specific item.

How to display this screen: Select Display Order at the Display Payment Detail Screen.

Field	Description
Order #	A system-assigned number that identifies an order. Numeric, 7 positions; display-only.
Shp (Ship-to number)	A system-assigned number that identifies the shipping address for an item. Numeric, 3 positions; optional.
Lin (Line number)	A system-assigned number that identifies the sequence in which each item was added to the order. The line number increases by 1 for each new item. Numeric, 3 positions; optional.
Sts (Line status code)	A code that identifies the condition of an item. Line status codes are: • Cancelled = The item has been removed from the order. • Closed = The item has been shipped. • Error • Express Bill • Held = The item is retained. • Soldout = The item is out of stock. Optional.
Extension	The total charge for this item, which is calculated by multiplying the unit price of the item by the quantity ordered, minus quantities returned or canceled. Numeric, 11 positions with a 2-place decimal; display-only.
Quantity Ordered	The quantity of this item ordered. Numeric, 5 positions; optional.
Quantity Shipped	The quantity of this item sent to the customer. Numeric, 5 positions; optional.
Quantity Returned	The quantity of this item returned by the customer. Numeric, 5 positions; optional.
Quantity Credited	The quantity of this item for which the customer has been is issued a credit. Numeric, 5 positions; optional.

Display Customer Bill To Payments Screen

Purpose: Use this screen to review each payment on a customer account.

How to display this screen: Select Payments at the Work with Open Items Screen.

Field	Description
Cust bill to (Customer bill-to number)	A system-assigned number that identifies a bill-to customer. See Creating and Updating Bill-to Customers (WCBT). Numeric, 8 positions, display-only.
Bill to name (Unlabeled field next to the Cust bill to field)	The name on a bill-to customer account. Alphanumeric, 42 positions; display-only.
Open item #	A system-assigned number that identifies an invoice or credit open item. Numeric, 7 positions; optional.
Pay date	The date when cash was received or a payment applied against an invoice, or applied from a credit. Numeric, 6 positions (MMDDYY format); optional.
Type	A code that identifies an A/R record type. This field is not currently implemented. Alphanumeric, 2 positions; optional.
Check #	The number on the customer's check used to make a payment. Numeric, 7 positions; optional.
Payment	The amount of the transaction. Numeric, 10 positions with a 2-place decimal; optional.
Discount	The amount deducted from the open invoice at the time of this payment. Numeric, 10 positions with a 2-place decimal; optional.
Wrt-off/adj (Write off/adjustment)	The dollar amount written off or adjusted on the open invoice at the time of this payment. Numeric, 10 positions with a 2-place decimal; optional.
G/L numbers	The account against which the transaction is posted. The general ledger account number appears below the corresponding transaction. General ledger numbers are defined in and validated against the General Ledger Accounts table. See Working with G/L Accounts (WGLA). Numeric, 8 positions, display-only.

Screen Option	Procedure
Display order details	Select Display order for an invoice to advance to the Display Order Detail Screen (A/R Inquiry).
Display invoice details	Select Display invoice for an invoice to advance to the Display Customer Bill To Payments Screen.
Advance to order inquiry	Select Order inquiry. See Using the Order Inquiry Scan Screens (OIOM).

Customer A/R Sales History Screen

Purpose: Use this screen to display the details of a customer's A/R sales, balance, and delinquent payment history for current and previous years.

This screen also displays the percentage of the customer's A/R sales from the previous year in comparison to the customer's A/R sales for the current year.

How to display this screen: Select Customer History at the Second Work with Open Item Screen (Changing A/R Open Items).

Field	Description
Customer	A system-assigned number that identifies a bill-to customer. See Creating and Updating Bill-to Customers (WCBT). Numeric, 8 positions; display-only.
Bill to name (Unlabeled field next to the Cust bill to field)	The name on a bill-to customer account. Alphanumeric, 42 positions; display-only.
Cash - YTD (Cash year-to-date)	The total dollar amount paid on the customer's A/R account during the current year. Numeric, 13 positions with a 2-place decimal; display-only.
LYTD (Last year-to-date)	The total dollar amount paid on the customer's A/R account during the previous year. Numeric, 13 positions with a 2-place decimal; display-only.
LTD (Lifetime-to-date)	The total dollar amount paid on the customer's A/R account since the account was established. Numeric, 13 positions with a 2-place decimal; display-only.
Sales - YTD (Sales - year-to-date)	The total amount of A/R purchases made to the customer's A/R account during the current year. Numeric, 13 positions with a 2-place decimal; display-only.
LYTD (Last year-to-date)	The total amount of A/R purchases made to the customer's A/R account during the previous year. Numeric, 13 positions with a 2-place decimal; display-only.
LTD (Lifetime-to-date)	The total amount of A/R purchases made on the customer's A/R account since the account was established. Numeric, 13 positions with a 2-place decimal; display-only.
% YTD/LYTD (Percentage year to date/last year to date)	The percentage of year-to-date sales in comparison to last year-to-date sales. Numeric, 5 positions with a 2-place decimal; display-only.
# invoices (Number of invoices)	The total number of A/R invoices generated. Numeric, 5 positions; display-only.
# credits (Number of credits)	The total number of A/R credits generated during the lifetime of this customer's A/R account. Numeric, 5 positions; display-only.
Last pay amt (Last pay amount)	The dollar amount of the most recent payment made to the customer's A/R account. Numeric, 13 positions with a 2-place decimal; display-only.
Last pay date	The date when the most recent payment was posted to the customer's A/R account. Numeric, 6 positions (MMDDYY format); display-only.
Avg days to pay (Average days to pay)	The average number of days between the date an invoice is generated and the date payment for that invoice is posted to the customer's A/R account. Numeric, 5 positions; display-only.
Accounting period description (Unlabeled field to the left of the Curr year field)	The description associated with the current accounting period, as defined in the Accounting Period table. Alphanumeric, 3 positions; display-only.
Sales Curr year (Current year)	The totals sales for the customer at the end of the specified accounting period for this year. Numeric, 9 positions with a 2-place decimal; display-only.
Sales Last year (Last year)	The totals sales for the customer at the end of the specified accounting period for last year. Numeric, 9 positions with a 2-place decimal; display-only.
Sales % (Percentage year/last year)	The percentage of this year's sales in comparison to last year's sales at the end of the specified accounting period. Numeric, 5 positions with a 2-place decimal; display-only.
A/R balance Curr year (Current year)	The total open A/R balance for this year at the end of the specified accounting period. Numeric, 9 positions with a 2-place decimal; display-only.
A/R balance Last year	The total open A/R balance for last year at the end of the specified accounting period. Numeric, 9 positions with a 2-place decimal; display-only.
Delinquent bucket Cur yr (Current year)	The aging bucket to which the most delinquent amount from the value in the Curr year field is assigned. Numeric, 1 position; display-only.
Delinquent bucket Lst yr (Last year)	The aging bucket to which the most delinquent amount from the value in the Last year field is assigned. Numeric, 1 position; display-only.

Screen Option	Procedure
Review A/R aging	Select Aging to advance to the Display Aging Pop-Up Window (A/R Inquiry).
Enter notes about the customer account	Select Notes to advance to the Work with Bill To Notes Screen (Entering Notes About an A/R Account).

Display Aging Pop-Up Window (A/R Inquiry)

Purpose: This pop-up window shows the current and past due open balances of a bill-to account and the aging buckets to which they belong.

Aging buckets are defined in the System Control table; see Setting Up Accounts Receivable Values. Open amounts are assigned to aging buckets according to the length of time the balance remains open.

How to display this screen: Select Aging at the Customer A/R Sales History Screen.

Field	Description
Total open	The total unpaid dollar amount on the customer's A/R account. Numeric, 13 positions with a 2-place decimal; display-only.
Cash flow	The portion of the account's open amount that falls into the corresponding aging bucket. Assigned to an aging bucket according to the number of days between the current date and the expected receipt date. The expected receipt date defaults to the due date unless changed manually. See Working with Invoice Open Items for more information about changing the expected receipt date. This field is updated by the A/R aging program and cash receipts. Numeric, 13 positions with a 2-place decimal; display-only.
Aging (Unlabeled fields below the Total open field)	The portion of the account's open amount that falls into the corresponding aging bucket. The value in the Aging field is assigned to an aging bucket according to the number of days between the due date and the current date or the invoice date and the current date. The starting point for account aging is defined in the System Control table; see Setting Up Accounts Receivable Values. Numeric, 13 positions with a 2-place decimal; display-only.

Work with Bill To Notes Screen (Entering Notes About an A/R Account)

Purpose: Use this screen to enter and maintain free-form notes about an A/R account.

How to display this screen: Select Notes at the Customer A/R Sales History Screen.

Field	Description
Cust bill to (Customer bill-to number)	A system-assigned number that identifies a bill-to customer. See Creating and Updating Bill-to Customers (WCBT). Numeric, 8 positions; display-only.
Bill to name (Unlabeled field next to the Cust bill to field)	The name on a bill-to customer account. Alphanumeric, 42 positions; display-only.
Notes	Fields used to enter, update, or delete free-form notes about the customer A/R account. Alphanumeric, 60 positions per line; optional.
Date	The date when the notes were entered or updated for the customer A/R account. The value in the date field appears next to the related line. Numeric, 6 positions (MMDDYY format); display-only.