Using the Inquiry Functions | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Displaying Delinquent Bill To Customers (DDCU) |
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 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 Invoice 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. Press F10 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).
ACR0188 ENTER Select Customer Bill To 9/03/02 8:35:59 KAB Co.
Customer bill-to .
Customer sold-to .
Invoice # . . . .
Order # . . . . .
Postal code . . . Last name . . Company . . .
Telephone # . . . (Day, Eve, Fax)
Alt cust # . . . .
F3=Exit F7=Cash Receipts F12=Cancel F22=User defined option F24=Select company |
For more information: See Working with Cash Receipts (WCRT) for field descriptions and scanning options.
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
• perform an order inquiry
How to display this screen: At a Scan Cust Bill To screen, enter 1 next to 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.
ACR0040 DISPLAY Work with Open Items 9/03/02 8:39:17 KAB Co.
Cust: 49 A/R on order : 80.95 MIRANDA, BERNADETTE T Total A/R : 151.09 Addr: 109 TURNER LN Credit limit : 0 Last statemnt : 4/22/02 TEMPLETON MA 01468 USA Terms . . . : Op S Inv # TC Order # Inv Date Due date Amount Discount Balance
Type options, press Enter. 5=Display 6=Display payment details 8=Work with open items O 1549 CR 5781 5/30/02 5/30/02 18.50 .00 18.50 O 0 CM 5/30/02 5/30/02 10.00 .00 4.00 D 1586 IN 5873 5/30/02 5/30/02 6.00 .00 6.00 P 1585 IN 5872 5/30/02 5/30/02 6.00 .00 .00 O 1548 IN 5781 4/25/02 4/25/02 18.50 .00 18.50 O 1522 IN 5742 4/15/02 4/15/02 18.99 .00 18.99 O 1510 IN 5680 4/09/02 4/09/02 193.53 .00 193.53 O 1506 IN 5626 3/27/02 3/27/02 100.00 .00 100.0 +
F3=Exit F8=Pay date F10=Ticklers F12=Cancel F16=Payments F17=Aging F18=Cust history F20=Print statement F21=Print list F23=Notes |
Field |
Description |
Cust (Bill-to customer number) |
A system-assigned number that identifies a customer billing account. See Customer Service 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 Purging (MOIP) and Resetting (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. |
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 set to Y. 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 set to Y. 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 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 (option 8 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 file. The system retrieves the appropriate A/R type for a transaction by checking the values defined in the System Control file (or, for on-account and sundry transactions, the system retrieves the first appropriate type it finds in the A/R Type file). 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 Customer Service Processing A/R Refunds (MARC)). These credit open items are indicated by their A/R types, as defined in the Default Check Credit Open Item Type (E82) and Default Credit Card Credit Open Item Type (E83) fields in the System Control file. 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. |
The date when payment is required for the open item. Numeric, 6 positions (MMDDYY format); optional. |
|
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. |
|
Press F8 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 |
Enter 5 next to an open item to advance to the Display A/R Open Item Screen. |
Display payment details |
Enter 6 next to an open item to advance to the Display Payment Detail Screen. |
Change an open item |
Enter 8 next to an open item to advance to the Work with Open Item Screen (Changing A/R Open Items). |
Switch between Pay date and Due date display |
Press F8. See the Paid date and Due date field descriptions. |
Work with ticklers associated with the bill-to customer |
Press F10 to advance to the Work with Ticklers Screen (bill-to customer view). |
Review payments |
Press F16 to advance to the Display Customer Bill To Payments Screen. |
Review account aging |
Press F17 to advance to the Display Aging Pop-Up Window (A/R Inquiry). |
Review sales history |
Press F18 to advance to the Customer A/R Sales History Screen. |
Print statements |
Press F20. See A/R Printing Functions. |
Enter notes about a bill-to account |
Press F23 to advance to the Work with Bill To Notes Screen (Entering Notes About an A/R Account). |
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: Enter 8 next to an open item at the Work with Open Items Screen.
ARR0006 CHANGE Work With Open Item 9/10/97 14:58:17 EZK Mail Order
Open item # . : 1145 Type . . . . . : CR CREDIT Pay category . : 3 A/R Status . . . . : A Allocated to order nbr: 3965 Currency . . . : Open item date : 8/11/97 Discount due date . . : Due date . . . . 9/10/97 Expected receipt date : 9/10/97 Total A/R . . : 12.45 Discount . . . . . . : .00 Balance . . . : 7.77 Disputed . . . . . . . Paid . . . . . : 4.68 Paid date . . . . . . : 8/27/97 Debit G/L # . : 0 Credit G/L # . . . . : 0 Order # . . . : 3862 Invoice # . . . . . . : 2615 Cust sold to . : 524 DODGESON, GEORGE Cust bill to . : 185 DODGESON, GEORGE Salesman . . . : 0 Terms . . . . . 1 NET 30 DAYS Dispute reason . Short note . . .
F3=Exit F12=Cancel |
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 file; 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: 1 = Cash/check 2 = C.O.D. (Cash on delivery) 3 = Accounts receivable 4 = Credit card 5 = Coupon/gift certificate Alphanumeric, 1 position; 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 set to Y. 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 set to 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. |
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 set to Y. 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 set to Y. 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 in this field 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 file. See Accounts Payable 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 file. See Accounts Payable 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 Customer Service 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 file; see Accounts Payable 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 file; see Accounts Payable 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 file. 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 press Enter.
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 entering 2 next to an open item at the Pay Open Items Screen and advancing to the Change 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: Enter 5 next to an invoice at the Work with Open Items Screen.
ACR0042 DISPLAY Display A/R Open Item 4/16/02 14:09:22 KAB Co.
Open item # . : 2867 Type . . . . . : IN INVOICE: CASH OWED BY A CUST Pay category . : 3 A/R Status . . . . : O Open Open item date : 4/16/02 Discount due date . . : Due date . . . : 4/16/02 Expected receipt date : 4/16/02 Total A/R . . : 100.55 Discount . . . . . . : .00 Balance . . . : 100.55 Disputed . . . . . . : .00 Paid . . . . . : .00 Paid date . . . . . . : Debit G/L # . : 0 Credit G/L # . . . . : 0 Order # . . . : 5747 Invoice # . . . . . . : 1527 Currency . . . : Cust sold to . : 44 LETENDRE, ROBERT R Cust bill to . : 51 LETENDRE, ROBERT R Salesman . . . : 18812 NICKOLAUS MACHOVICH Terms . . . . : 0 Dispute reason : Short note . . :
F2=Toggle Alternate Currency F3=Exit F12=Cancel |
Field descriptions: Each field on this screen is described under 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 |
Press F2. 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 key displays only if the Use Alternate Currency Pricing (H89) system control value is set to Y. If you press F2 and the open item is not associated with an alternate currency, an error message displays: No conversion rate for offer. |
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 file when this screen is displayed. See Logging Credit Card Data Access for more information.
How to display this screen: Enter 6 next to an invoice at the Work with Open Items Screen.
ACR0044 DISPLAY Display Payment Detail 10/01/03 11:23:14 EZK Mail Order
Open item # : 2820 Type . . . . : IN Status . : D Cust bill to : 292 DACHSHUND, GEORGE Order # . . : 9043 Invoice # . . : 6785 Due date . . : 10/09/03 Disc due date : 10/09/03 Open Item Amt: 118.65 Balance . . . : 18.65 Crdt G/L : 0
Type Pay date Paid amount Disc amount Wrt-off/adj amt Balance remaining
10/01/03 90.00 10.00 .00 18.65 G/L Numbers: 80001 30020 0 Routing #: 0 Account #:
F2=Toggle Alternate Currency F3=Exit F7=Display Order F8=Display Invoice F9=Order Inquiry F12=Cancel |
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 press F2. If you are viewing the amounts in the alternate currency, this field displays; if you are viewing the amounts in the local currency, this field does not display. This field displays only if the Use Alternate Currency Pricing (H89) system control value is set to Y 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 file; 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: A = Allocated. This is a credit open item that is allocated toward payment of an open order. O = Open. An unpaid or unapplied balance exists. P = Paid. The item is paid in full or the item’s entire open balance is written off. D = 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. See Customer Service. 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 file. 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 pressing F2 if the Use Alternate Currency Pricing (H89) system control value is set to Y 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 pressing F2 if the Use Alternate Currency Pricing (H89) system control value is set to Y 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 file. See Accounts Payable 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 pressing F2 if the Use Alternate Currency Pricing (H89) system control value is set to Y 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 pressing F2 if the Use Alternate Currency Pricing (H89) system control value is set to Y 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 pressing F2 if the Use Alternate Currency Pricing (H89) system control value is set to Y 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 pressing F2 if the Use Alternate Currency Pricing (H89) system control value is set to Y 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 file. 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 |
Press F2. 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 key displays only if the Use Alternate Currency Pricing (H89) system control value is set to Y. If you press F2 and the order is not associated with an alternate currency, an error message displays: No conversion rate for offer. |
Display order details |
Press F7. See Display Order Detail Screen (A/R Inquiry). |
Display invoice details |
Press F8. See Display Invoice Detail Screen (A/R Inquiry). |
Advance to order inquiry |
Press F9. See Customer Service 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: Press F7 at the Display Payment Detail Screen.
ACR0045 DISPLAY Display Order Detail 2/22/97 9:42:16 Mail Order Company Order # : 42 ------------- Quantity ------------- Shp Lin Sts Extension Ordered Shipped Returned Credited
1 1 X 93.35 2 1 0 1 1 2 X 154.20 4 4 0 0 2 3 X 72.45 1 1 1 0
F3=Exit F12=Cancel |
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: C = Canceled. The item has been removed from the order. X = Closed. The item has been shipped. E = Error. B = Express bill. H = Held. The item is retained. S = Sold out. The item is out of stock. Alphanumeric, 1 position; 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. |
Ordered |
The quantity of this item ordered. Numeric, 5 positions; optional. |
Shipped |
The quantity of this item sent to the customer. Numeric, 5 positions; optional. |
Returned |
The quantity of this item returned by the customer. Numeric, 5 positions; optional. |
Credited |
The quantity of this item for which the customer has been is issued a credit. Numeric, 5 positions; optional. |
Display Invoice Detail Screen (A/R Inquiry)
Purpose: Use this screen to review information for all of the items on an invoice. Use the fields at the top of the screen to scan for the details of a specific item.
How to display this screen: Press F8 at the Display Payment Detail Screen.
ACR0144 DISPLAY Display Invoice Detail 9/11/97 8:45:37 EZK Mail Order
Order # : 3927 Invoice # : 2740 ---------- Ship --------- ---- Return --- Opt Ln# Item# SKU Qty Price Date Qty Date
Type options, press Enter. 5=Display 6=Display pay methods 7=Detail Charges
1 BU001 WHIT L‘
F3=Exit F12=Cancel |
For more information: See Customer Service Reviewing Order Details for a complete description of the fields and options on this screen.
Display Customer Bill To Payments Screen
Purpose: Use this screen to review each payment on a customer account.
How to display this screen: Press F16 at the Work with Open Items Screen.
ACR0080 DISPLAY Display Customer Bill To Payments 3/16/97 11:58:41 Mail Order Company Customer bill to : 21 EAST COAST DEVELOPMENT ATTN: JACKSON, JOE
Opt Open item # Pay date Type Check # Payment Discount Wrt-off/adj
Type options, press Enter. 7=Display order 8=Display invoice 52 2/21/95 184 84.00 .00 .00 G/L Numbers: 0 0 0 52 2/21/95 172 56.00 .00 .00 G/L Numbers: 0 0 0 52 2/21/95 200 8.50 .00 .00 G/L Numbers: 0 0 0 49 2/10/95 1 100.00 .00 .00 G/L Numbers: 0 0 0 49 2/10/95 2 300.00 .00 .00 G/L Numbers: 0 0 +
F3=Exit F9=Order inquiry F12=Cancel |
Field |
Description |
Cust bill to (Customer bill-to number) |
A system-assigned number that identifies a bill-to customer. See Customer Service 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 file. See Accounts Payable Working with G/L Accounts (WGLA). Numeric, 8 positions, display-only. |
Screen Option |
Procedure |
Display order details |
Enter 7 next to an invoice to advance to the Display Order Detail Screen (A/R Inquiry). |
Display invoice details |
Enter 8 next to an invoice to advance to the Display Invoice Detail Screen (A/R Inquiry). |
Advance to order inquiry |
Press F9. See Customer Service 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.
In order to update these totals correctly, run the Move and Clear YTD Buckets periodic function only at year end and make sure the Accounting Values (B71, B72, B73) are correct.
How to display this screen: Press F18 at the Work with Open Item Screen (Changing A/R Open Items).
ACR0046 DISPLAY Customer A/R Sales History 3/20/97 10:44:16 Mail Order Company Customer . : 21 EAST COAST DEVELOPMENT ATTN: JACKSON, JOE Cash - YTD : 1028.50 LYTD : 2974.00 LTD : 4002.50 Sales - YTD : 1260.00 LYTD : 2974.00 LTD : 4234.00 % YTD/LYTD : 42.36 # Invoices . : 6 # Credits . . : 0 Last pay amt: 8.50 Last pay date: 2/21/95 Avg days to pay: 12
----------- Sales ----------- ---- A/R Balance ---- Delinquent bckt Curr year Last year % Curr year Last year Cur yr Lst yr JUN 420.00 530.00 79.24 763.50 0 0
F3=Exit F12=Cancel F17=Aging F23=Notes |
Field |
Description |
Cust bill to |
A system-assigned number that identifies a bill-to customer. See Customer Service 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 file. Alphanumeric, 3 positions; display-only. |
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. |
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. |
% (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. |
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. |
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. |
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. |
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 |
Press F17 to advance to the Display Aging Pop-Up Window (A/R Inquiry). |
Enter notes about the customer account |
Press F23 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 file; 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: Press F17 at the Customer A/R Sales History Screen.
Display Aging
Total open : 120.00 Cash Flow CURRENT : 55.00 .00 1-30 : .00 55.00 31-60 : 45.00 .00 61-90 : 20.00 45.00 91-120 : .00 20.00 FUTURE : .00 .00
Press ENTER to continue. |
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. This value is 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 file; 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: Press F23 at the Customer A/R Sales History Screen.
ACR0043 OPEN Work with Bill To Notes 3/20/97 15:16:05 Mail Order Company
Customer bill to : 21 EAST COAST DEVELOPMENT ATTN: JACKSON, JOE
Notes Date Joe called at - will send a payment of 120.00 tomorrow. 3/17/95 3:45 p.m. - Joan Anderson 3/17/95 Payment received. 3/20/95 10:00 a.m. - Stephen Lawrence 3/20/95
F3=Exit F8=Add/Change F12=Cancel |
Field |
Description |
Cust bill to (Customer bill-to number) |
A system-assigned number that identifies a bill-to customer. See Customer Service 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. |
Entering notes:
1. Type a note in the note field.
2. Press Enter when you are finished typing your note. The date appears in the Date field to the right of each line.
3. Press F8 to add your notes to the A/R account.
Maintaining or deleting notes:
1. Press F8 to make changes to existing notes.
2. Change or delete notes as necessary.
3. Press Enter. The value in the Date field is updated to the current date.
4. Press F8 to update your notes for the customer A/R account.
Using the Inquiry Functions | Contents | SCVs | Search | Glossary | Reports | Solutions | XML | Index | Displaying Delinquent Bill To Customers (DDCU) |
AR03_01 CWDirect 18.0.x 2018 OTN