Chapter 4: Working with Invoice Open Items
Purpose: In addition to posting cash to deferred liability, you can use the cash receipts menu option to:
• Post cash and checks to unpaid invoices within individual customer accounts, or to deferred liability
• Apply full or partial payments to open items
• Create and apply credits to open items
• Enter sundry transactions
• Place cash receipt balances on account
• Enter adjustments
• Change, display, or review open items
Each of these options is available on the Pay Open Items Screen or a subsequent screen.
Alternate currency pricing: If you use alternate currency pricing (the Use Alternate Currency Pricing (H89) system control value is set to Y), and the bank you define on the Cash Receipts Screen (Cash Batch Settings) is associated with an alternate (foreign) currency, the system advances you to the Pay Alternate Currency Open Items Screen instead of the Pay Open Items Screen. At the Pay Alternate Currency Open Items screen you can post cash and checks to unpaid invoices in the alternate currency. See Customer Service Chapter 12: Using Alternate Currency Pricing for an overview and required set up.
In this chapter:
• Applying Payments or Adjustments
• Pay Alternate Currency Open Items Screen
• Applying Payments or Adjustments
• Display A/R Open Item Screen
• Work with Payment Details Screen
• Automatic A/R Open Item Write-off Process
• Setup Required for the Automatic A/R Open Item Write-off Process
• Automatic A/R Open Item Write-off Processing
• Automatic A/R Open Item Write-off Examples
• Work with Alternate Currency Payment Details Screen
• Apply Credit to Debit Pop-Up Window
• Applying All Available Credits
• Confirm On-Account Payment Window (Posting On-Account Payments)
• Work with Sundry Transactions Screen
• Display Batch Deposit Totals Screen (Completing a Deposit)
For more information: See Chapter 3: Working with Cash Receipts (WCRT) for information on entering batch settings, selecting bill-to customers, or posting to deferred liability.
Note: You can use High Speed A/R Payment Entry and Batch Processing (WABP) instead of the Cash Receipts function when you have a large amount of unpaid invoices to enter into the system for more than one customer account.
Purpose: Use this screen to post cash receipts, enter adjustments, apply credits, and create on-account payments. This screen lists all open items, held items, and any paid (closed) items that have not been purged.
Alternate currency pricing: If the bank you define on the Cash Receipts Screen (Cash Batch Settings) is associated with a foreign currency, the system does not advance you to the Pay Open Items screen when you select a bill-to account on the Scan Cust Bill To screen; instead, the system advances you to the Pay Alternate Currency Open Items Screen where you can post cash and checks in the foreign currency.
Applying Payments or Adjustments
Defining the transaction: To enter a posting amount to apply as partial or full payment to one or more invoices:
1. Enter a valid payment type code in the Code field.
2. Optionally, enter the check number in the Check # field if payment is by check.
3. Enter the total dollar amount to be posted in the Amount field.
4. Press Enter. The system updates the value in the Amount remaining field to the amount you entered in the Amount field.
When applying a customer payment or credit adjustment, you can:
• select individual invoices, entering the amount to apply to each or paying them in full.
• create an "on-account" open item that will be available in the future to apply against invoices.
• apply the total payment amount to open invoices based on date, the oldest first.
Applying cash to invoice records: The different methods available to apply payment to invoice open items are:
Partial payment: You can use this method to apply payment to any open (O) or disputed (D) invoice open item.
Enter a dollar amount in the Pay amt field next to the invoice to which you want to apply payment. The system updates the value in the Balance field and the values in the Amount applied and Amount remaining fields appropriately. If the payment amount you entered will pay the invoice in full, the invoice status changes to P.
Note: The dollar amount you enter in the Pay amt field must be less than or equal to the value in the Amount remaining field.
Full payment: You can use this method to apply payment to any open (O) or disputed (D) invoice open item.
Enter 6 next to the invoice you want to pay in full. The system:
• Applies the appropriate dollar amount to the invoice open item you selected
• Changes the value in the Balance field to .00
• Updates the value in the Paid amt field
• Updates the Amount applied and Amount remaining fields
• Changes the invoice open item status to P
Making a system-assigned payment: Press F19 to let the system decide how to apply the value in the Amount remaining field to multiple open invoice records. The system:
• applies payment to unpaid invoice open items, beginning with the oldest, until the entire value in the Amount remaining field is applied
• selects only invoice open items in an open (O) status, skipping any invoice in a disputed (D) status
• changes the value in the Balance field for each invoice
• changes the value in the Paid amt field of each invoice
• updates the Amount applied and Amount remaining fields appropriately
• changes the status of each invoice that is paid in full to P
If the date is the same for more than one open item, the system applies payment to the open item with the lowest invoice number first.
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 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: At a Scan Cust Bill To screen, enter 1 next toa bill-to account , or enter a valid bill-to, sold-to, open item, or order number at the Select Customer Bill To screen. See Working with Scan Customer Bill-to Screens.
ACR0049 DISPLAY Pay Open Items 9/03/02 8:07:28 KAB Co.
Customer: 49 MIRANDA, BERNADETTE T Code K Check Check # : Amount: Amount applied : 100.00 Sundry Total . : .00 Amount remaining: .00 ? S Invoice Tp Date Order# Total amt Paid amt Balance Pay amt
Type options, press Enter. 2=Change 5=Display 6=Pay in full 7=Detail entry 8=Apply credit to debit O 0 CR 3/18/02 100.00 14.99 85.01 O 1482 IN 3/18/02 5561 14.99 9.99 5.00 O 0 CR 3/18/02 102.41 18.99 83.42 P 1506 IN 3/27/02 5626 100.00 100.00 .00 O 1510 IN 4/09/02 5680 193.53 .00 193.53 O 1522 IN 4/15/02 5742 18.99 .00 18.99 O 1548 IN 4/25/02 5781 18.50 .00 18.50 D 1586 IN 5/30/02 5873 6.00 .00 6.00 O 0 CM 5/30/02 10.00 6.00 4.00 +
F2=Opt on/off F6=Create F9=Accept F10=Ticklers F11=Reject F17=On-account F18=Sundry entry F19=Apply cash F20=Apply credits F22=User defined option |
Field |
Description |
Customer |
A system-assigned number that identifies a bill-to customer account. See Customer Service Chapter 30: Creating and Updating Bill-to Customers (WCBT). Numeric, 8 positions, display-only. |
Bill-to name (Unlabeled field next to the Customer field) |
The name associated with a bill-to customer account. Alphanumeric, 42 positions; display-only. |
Identifies a payment type. These codes are: A = Adjustment. An adjustment to update the customer's account. C = Cash. Customer payment by cash. K = Check. Customer payment by check If you enter payment code K (check), a value is required in the Check # field. Alphanumeric, 1 position; required. |
|
The number on the customer's check. Numeric, 7 positions; required if you enter K in the Code field. |
|
The dollar amount received from the customer. The system requires that you post the entire value in the Amount field during cash receipts posting; otherwise, press F11 to cancel. Numeric, 10 positions with a 2-place decimal; display-only. |
|
The total dollars applied to the customer's open items during the current posting session. The system updates this field as you apply the cash received to open items. Numeric, 10 positions with a 2-place decimal; required. |
|
Sundry total |
The total amount of sundry postings, or discount and writeoff amounts entered through the detail entry option. The sundry account is used to make direct postings to the general ledger. Numeric, 10 positions with a 2-place decimal; display-only. |
The unposted payment amount. Numeric, 10 positions with a 2-place decimal; display-only. |
|
S (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 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 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 Change A/R Open Item Screen. 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 written off, or a credit open item has been fully refunded or written off, used as payment on an order, or applied toward an invoice open item during the current session. D = Disputed. An unpaid or unrefunded balance is in dispute. Alphanumeric, 1 position; optional. |
Invoice |
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. |
Tp (Type) |
A user-defined code that identifies an A/R open item type. A/R type categories may include credits, debits, credit memos, invoices, credit card credits or refund check credits, and on-account categories. 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. See Chapter 1: Establishing Accounts Receivable Types (WART) for more information on the default A/R types you can create. Refund check or credit card credit: You can flag a credit open item to produce a refund check or a credit card credit, which you can then process through 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. |
Date |
The date the open item was created. Numeric, 6 positions (MMDDYY format); optional. |
Order # |
A system-assigned number that identifies the order that produced the credit or invoice open item. Numeric, 7 positions; optional. |
Total amt |
The total, original amount of the invoice or credit before applying any credits, payments, or discounts. Both credit and invoice amounts are presented as positive numbers. Numeric, 9 positions with a 2-place decimal; display-only. |
For an invoice open item, this represents the total amount of credits or payments applied; for a credit open item, this represents the total amount that has been applied as a credit toward an invoice open item, or used as payment against an order (if the Allow A/R Credits as Payments (E81) system control value is set to Y). Numeric, 9 positions with a 2-place decimal; display-only. |
|
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; display-only. |
|
The dollar amount that you are applying to an open item as payment. This field is enterable only for invoice open items in an open status. Numeric, 9 positions with a 2-place decimal; optional. |
Screen Option |
Procedure |
Change an open item |
Enter 2 next to an item to advance to the Change A/R Open Item Screen. |
Display open item details |
Enter 5 next to an item to advance to the Display A/R Open Item Screen. |
Pay the open item balance in full |
Enter 6 next to an item. See Applying Payments or Adjustments. |
Apply payment, discount, and writeoff separately |
Enter 7 next to an item. See Applying Payments or Adjustments and Work with Payment Details Screen. |
Apply a credit to a debit |
Enter 8 next to an item. See Applying Credits to Debits. |
Turn option fields on or off |
Press F2. |
Create an open item |
Press F6 to advance to the Create A/R Open Item Screen. |
Accept the transactions |
Press F9. |
Work with ticklers associated with the bill-to customer |
Press F10 to advance to the Work with Ticklers Screen (bill-to customer view). |
Reject the transactions and exit the screen |
Press F11. |
Create an on-account payment |
Press F17. See Confirm On-Account Payment Window (Posting On-Account Payments). |
Work with sundry transactions |
Press F18 to advance to the Work with Sundry Transactions Screen. |
Apply the total cash amount as payment to open invoices |
Press F19. See Applying Payments or Adjustments. |
Apply credits to open items |
Press F20. See Applying Credits to Debits. |
Pay Alternate Currency Open Items Screen
Purpose: Use this screen to post cash and checks for invoices in an alternate (foreign) currency. Invoices are associated with an alternate currency if a currency code and conversion rate are defined in the Order Header Extended file. The alternate currency is the currency defined for the bank you selected on the Cash Receipts Screen (Cash Batch Settings).
What is the currency of the bank? The currency associated with the bank you define for posting cash receipts determines if you advance to the Pay Alternate Currency Open Items screen or the Pay Open Items screen.
• if the bank is associated with the local currency (the currency code defined in the Local Currency Code (A55) system control value), the system advances you to the Pay Open Items Screen. This screen displays all invoices, regardless of currency. Any cash you post against an open item is in the local currency.
• if the bank is associated with a foreign currency, the system advances you to the Pay Alternate Currency for Open Items screen. This screen displays only invoices associated with the currency defined for the bank. Any cash you post against an open item is in the foreign currency. The total open item amount, paid amount, and balance displays in the alternate currency. You can review the local amounts on the Display A/R Open Item Screen.
Applying Payments or Adjustments
Defining the transaction: To enter a posting amount to apply as partial for full payment to one or more invoices:
1. Enter a valid payment type code in the Code (Payment type code) field.
2. Optionally, enter the check number in the Check # field if payment is by check.
3. Enter the total amount to be posted in the Amount (Payment amount) field.
4. Press Enter. The system updates the value in the Amount remaining field to the amount you entered in the Payment amount field.
The different methods available to apply payment to invoice open items are:
Partial payment: Advance to the Work with Alternate Currency Payment Details Screen to apply a partial payment to any open (O) or disputed (D) invoice open item.
Full payment: You can use this method to apply payment to any open (O) or disputed (D) invoice open item.
Enter 6 next to the invoice you want to pay in full. The system:
• Applies the appropriate dollar amount to the invoice open item you selected.
• Changes the value in the Balance field to .00.
• Updates the value in the Paid amt field.
• Updates the Amount applied and Amount remaining fields.
• Changes the invoice open item status to P.
Making a system-assigned payment: Press F19 to let the system decide how to apply the value in the Amount remaining field to multiple open invoice records. The system:
• applies payment to unpaid invoice open items, beginning with the oldest, until the entire value in the Amount remaining field is applied.
• selects only invoice open items in an open (O) status, skipping any invoice in a disputed (D) status.
• changes the value in the Balance field for each invoice.
• changes the value in the Paid amt field of each invoice.
• updates the Amount applied and Amount remaining fields appropriately.
• changes the status of each invoice that has paid in full to P.
If the date is the same for more than one open item, the system applies payment to the open item with the lowest invoice number first.
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 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: At a Scan Customer Bill To screen, enter 1 next to a bill-to account, or enter a valid bill-to, sold-to, open item, or order number at the Select Customer Bill-To Screen. This screen displays only if:
• the bank you selected on the Cash Receipts Screen (Cash Batch Settings) is associated with a foreign currency (the currency defined for the bank is not the local currency defined in the Local Currency Code (A55) system control value).
• The Use Alternate Currency Pricing (H89) system control value is set to Y.
ACR0509 DISPLAY Pay Alternate Currency Open Items 9/03/02 8:15:56 KAB Co. Currency code : JPY
Customer: 51 LETENDRE, ROBERT R Code K Check Check # : Amount: Amount Applied : .00 Sundry Total . : .00 Amount Remaining: .00 ? S Invoice Tp Date Order# Total amt Paid amt Balance
Type options, press Enter. 5=Display 6=Pay in full 7=Detail entry O 1524 CR 4/16/02 5745 10690.00 10000.00 690.00 O 1530 IN 4/17/02 5759 12295.00 7505.00 4790.00 O 1529 IN 4/17/02 5758 14642.00 .00 14642.00 O 1528 CR 4/17/02 5747 12421.00 1000.00- 13420.00 O 1531 CR 4/17/02 5758 12771.00 .00 12771.00 O 1532 CR 4/17/02 5759 10691.00 .00 10691.00 O 1540 IN 4/18/02 5766 14642.00 .00 10000.00 O 1541 IN 4/19/02 5770 14642.00 .00 14642.00 O 1543 IN 4/22/02 5774 14703.00 .00 14703.00 +
F9=Accept F10=Ticklers F11=Reject F19=Apply cash F22=User defined option |
Field |
Description |
Currency code |
The code for the currency associated with the bank you selected to post cash receipts. Only invoices and invoice credits associated with this currency display on this screen. Invoices and invoice credits are associated with the currency code defined in the Order Header Extended file. Alphanumeric, 3 positions; display-only. |
Customer |
The bill-to customer account number you selected to post cash receipts. Numeric, 8 positions; display-only. |
Bill-to name (unlabeled field) |
The name associated with the bill-to customer account. Alphanumeric, 42 positions; display-only. |
Identifies a payment type. Valid values: A = Adjustment. An adjustment to update the customer’s account. C = Cash. Customer payment by cash. K = Check. Customer payment by check. If you enter payment code K (check), a value is required in the Check number field and Amount field. Alphanumeric, 1 position; required. |
|
The number on the customer’s check. Numeric, 7 positions; required if you enter K in the Code field. |
|
The dollar amount received from the customer. The system requires that you post the entire value in the Amount field during cash receipts posting; otherwise, press F11 to cancel. Numeric, 10 positions with a 2-place decimal; required if you enter K in the Code field. |
|
The total dollars applied to the customer’s open items during the current posting session. The system updates this field as you apply the cash received to open items. Numeric, 10 positions with a 2-place decimal; display-only. |
|
Sundry total |
The total amount of sundry postings, or discount and write-off amounts entered through the detail entry option. The sundry account is used to make direct postings to the general ledger. Numeric, 10 positions with a 2-place decimal; display-only. |
The unposted payment amount. Numeric, 10 positions with a 2-place decimal; display-only. |
|
S (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 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 Y. You cannot apply allocated open items against invoice open items until the order is billed or cancelled, or the open item is unallocated. 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 written off, or a credit open item has been fully refunded or written off, used as payment on an order, or applied toward an invoice open item during the current session. D = Disputed. An unpaid or unrefunded balance is in dispute. Alphanumeric, 1 position; optional. |
Invoice |
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. |
Tp (Type) |
A user-defined code that identifies an A/R open item type. A/R type categories may include credits, debits, credit memos, invoices, credit card credits or refund check credits, and on-account categories. A/R type codes are defined in an validated against the A/R Type file. See Chapter 1: Establishing Accounts Receivable Types (WART) for more information on the default A/R types you can create. Refund check or credit card credit: You can flag a credit open item to produce a refund check or a credit card credit, which you can then process through 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) system control values. You cannot apply these credits as payment toward invoice open items. Numeric, 2 positions; optional. |
Date |
The date the open item was created. Numeric, 6 positions (MMDDYY format); optional. |
Order # |
The order that produced the credit or invoice open item. Numeric, 7 positions; optional. |
Total amt |
The total, original amount of the invoice or credit before applying any credits, payments, or discounts in the alternate currency. Both credit and invoice amounts are presented as positive numbers. Numeric, 9 positions with a 2-place decimal; display-only. |
For an invoice open item, this represents the total amount of credits or payments applied in the alternate currency; for a credit open item, this represents the total amount that has been applied as a credit toward an invoice open item in the alternate currency, or used as payment against an order (if the Allow A/R Credits as Payments (E81) system control value is set to Y). Numeric, 9 positions with a 2-place decimal; display-only. |
|
The dollar amount that the customer still owes on an invoice, or that is still available on a credit in the alternate currency. Numeric, 9 positions with a 2-place decimal; display-only. |
Screen Option |
Procedure |
Display open item details |
Enter 5 next to an open item to advance to the Display A/R Open Item Screen. You can toggle the amounts on this screen to display in the local currency or alternate currency. |
Pay the open item balance in full |
Enter 6 next to an open item. See Applying Payments or Adjustments. |
Apply payment, discount, and write-off separately |
Enter 7 next to an open item. See Work with Alternate Currency Payment Details Screen. |
Accept the transactions |
Press F9. |
Work with ticklers associated with the bill-to customer |
Press F10 to advance to the Work with Ticklers Screen (bill-to customer view). |
Reject the transactions and exit the screen |
Press F11. |
Apply the total cash amount as payment to open invoices |
Press F19. See Applying Payments or Adjustments. |
Purpose: Use this screen to change an open item, 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)
• entering a short note
How to display this screen: Enter 2 next to an open item at the Pay Open Items Screen.
ACR0079 CHANGE Change A/R Open Item 9/09/97 16:55:30 EZK Mail Order
Open item # . : 1168 Type . . . . . : CR CREDIT Pay category . : 3 A/R Status . . . . : A Allocated to order nbr: 3885 Open item date : 8/11/97 Discount due date . . . Due date . . . . 8/11/97 Expected receipt date . 8/11/97 Total A/R . . : 1.50 Discount . . . . . . : .00 Balance . . . : 1.50 Disputed . . . . . . . Paid . . . . . : .00 Paid date . . . . . . : Debit G/L # . : 0 Credit G/L # . . . . : 0 Order # . . . : 3867 Invoice # . . . . . . : 2655 Currency . . . : Cust sold to . : 294 BROWN, HANNAH E Cust bill to . : 162 BROWN, HANNAH E Salesman . . . : 0 Terms . . . . . 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 Chapter 1: Establishing Accounts Receivable Types (WART). 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. The open item is allocated as payment toward an 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 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. 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 written off, or the debit open item has been paid or written off, during this session. 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 Applying Payments or Adjustments or Applying Credits to Debits. Alphanumeric, 1 position; optional. |
The order number on which the credit open item is allocated to be applied as payment. The open item is allocated as payment toward an 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 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. |
|
Open item date |
The date the invoice 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): optional. |
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 Applying Payments or Adjustments and Applying Credits to Debits for more information on the transactions you can perform against disputed open items. Numeric, 9 positions with a 2-place decimal; display-only. |
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 # |
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 Chapter 2: Working with G/L Accounts (WGLA). Numeric, 8 positions; display-only. |
Credit G/L # |
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 Chapter 2: 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. |
Currency |
The currency used on the order. This field is not currently implemented. Alphanumeric, 3 positions; display-only. |
Cust sold to |
The customer who places an order. See Customer Service Chapter 28: Creating and Updating Sold-to Customers (WCST). Number: numeric, 8 position; display-only. Name: alphanumeric, 41 positions; display-only. |
Cust bill to |
The customer responsible for paying for an order. See Customer Service Chapter 30: Creating and Updating Bill-to Customers (WCBT). Number: numeric, 8 position; display-only. Name: alphanumeric, 41 positions; display-only. |
Salesman |
A code that identifies the sales representative credited for the order. See Accounts Payable Chapter 11: Working with Sales Representatives (WSLS). Alphanumeric, 7 positions; 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 Chapter 9: Working with Terms (WAPT). Numeric, 2 positions; optional. |
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 Chapter 2: Establishing Dispute Reason Codes (WDSR). You can put both credit and invoice open items in dispute. See Applying Payments or Adjustments and Applying Credits to Debits 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; optional. |
Enter 5 next to an item at the Pay Open Items Screen to advance to the Display A/R Open Item screen. You cannot change any information at this screen. See Change A/R Open Item Screen for descriptions of the fields on this screen.
Work with Payment Details Screen
Purpose: Use this screen for:
• Redirecting open item payments by posting an amount to specific general ledger accounts
• Posting a discount toward an open invoice balance
• Posting a write-off or adjustment of all or part of an open invoice balance
You can post to multiple general ledger accounts if you want to track money received at a more detailed level.
Posting an Amount to a Specific General Ledger Account
When you post cash to a specific general ledger account, the system:
• Increases the value in the Amount applied field
• Decreases the value in the Amount remaining field
• Decreases the value in the Balance field
To apply a payment to a specific general ledger account, complete the Amount and G/L number fields. See Posting A/R for more information on the general ledger postings.
Posting a Discount Amount to a Specific General Ledger Account
When you post an discount amount in the field to a specific general ledger account, the system:
• Posts the amount to a sundry cash receipts general ledger account
• Increases the value in the Sundry total field on the Pay Open Items Screen
• Decreases the value in the Balance field
To apply a discount to a specific general ledger account, complete the Discount field and the G/L number field. See Posting A/R for more information on the general ledger postings.
Posting a Write-off or Adjustment to a Specific General Ledger Account
When you post a write-off or adjustment to a specific general ledger account, the system:
• Posts the amount to a sundry cash receipts general ledger number
• Increases the value in the Sundry total field on the Pay Open Items Screen
• Decreases the value in the Balance field
To apply a write-off or adjustment to a specific general ledger account, complete the Write off/adjustment field and the G/L number field. See Posting A/R for more information on the general ledger postings.
Automatic A/R open item write-off process: You can also submit the Automatic A/R Open Item Write-off periodic process to automatically write-off A/R open items that meet the automatic write-off requirements. See Automatic A/R Open Item Write-off Process for an overview, required setup, and examples.
How to display this screen: Enter 7 next to an invoice open item in an open (O) or disputed (D) status at the Pay Open Items Screen.
ACR0051 ENTER Work with Payment Details 5/11/99 10:45:52 KAL Co.
Customer : 7 BAXTER, CLARA W Check # : 50 Check amount: 50.00 Amount applied : .00 Amount remaining: 50.00
Open item # . . . : 1260 Type : IN Date . . . . . . . : 5/11/99 Balance . . . . . : 66.00 Amount . . . . . . . G/L Number . Discount . . . . . . G/L Number . Write off/Adjustment G/L Number .
F3=Exit F12=Cancel |
Field |
Description |
Customer number |
A system-assigned number that identifies the bill-to account number. See Customer Service Chapter 30: Creating and Updating Bill-to Customers (WCBT). Numeric, 8 positions, display-only. |
Bill-to name |
The name on the bill-to customer account. Alphanumeric, 42 positions; display-only. |
Check # |
The number on the customer's check that you entered at the Pay Open Items Screen. Numeric, 7 positions; display-only. |
Amount applied |
The total dollars currently applied to the customer's open items during the current posting session. The system updates this field as you apply payment to open items. Numeric, 10 positions with a 2-place decimal; display-only. |
Amount remaining |
The unused portion of a payment to be applied during a posting session. Numeric, 10 positions with a 2-place decimal; display-only. |
Open item # |
A system-assigned number that identifies an invoice. Numeric, 7 positions; display-only. |
Type |
A code that identifies an A/R record 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 Chapter 1: Establishing Accounts Receivable Types (WART). Numeric, 2 positions; required |
Date |
The date the invoice was created through the Billing function. Numeric, 6 positions (MMDDYY format); display-only. |
Balance |
The amount the customer owes on an invoice. Numeric, 9 positions with a 2-place decimal; display-only. |
Amount |
The amount that you want to post to a specific general ledger account number for the open item selected. Numeric, 10 positions with a 2-place decimal; optional. |
Discount |
A dollar amount that will apply to the open item as a discount. Your entry here will update the Sundry total field on the Pay Open Items Screen. Numeric, 10 positions with a 2-place decimal; optional. |
Write off/adjustment |
The portion of an invoice balance that you are writing off. Your entry here will update the Sundry total field on the Pay Open Items Screen. Numeric, 10 positions; optional. |
Although values in the Amount, Discount, and Write off fields are optional, you must complete one of them to complete a payment detail transaction. |
|
G/L number |
The number that identifies an account used for posting a specific type of financial activity. General ledger account numbers are defined in and validated against the General Ledger Account file. Numeric, 8 positions; optional. |
Automatic A/R Open Item Write-off Process
Purpose: The automatic A/R open item write-off process allows you to write-off A/R open items:
• that are equal to or less than a specified dollar amount, and/or
• whose Due date is older than the Open item invoice date by a specified number of days.
Setup Required for the Automatic A/R Open Item Write-off Process
Before you can use the automatic A/R open item write-off process, you must complete the required setup. Required setup includes:
• Automatic A/R Open Item Write-off Periodic Function
• Automatic A/R Open Item Write-off Periodic Process
System Control Value |
Description |
Use this umbrella system control value to set up the system control values used during the automatic A/R open item write-off process. |
|
Enter the dollar amount that the Balance for an A/R open item must be equal to or less than in order to qualify for the automatic A/R open item write-off process. In order to use the automatic A/R open item write-off process, you must define a Dollar Limit for Automatic A/R Write-offs (K59), Number of Days Past Invoice Date for A/R Write-offs (K60), or both. |
|
Enter the number of days that the Due date for the A/R open item in the A/R Open Item file must be older than the Invoice date (the Open item date in the A/R Open Item file) in order to qualify for the automatic A/R open item process. In order to use the automatic A/R open item write-off process, you must define a Dollar Limit for Automatic A/R Write-offs (K59), Number of Days Past Invoice Date for A/R Write-offs (K60), or both. |
|
Enter the general ledger account number the system uses to post the debit expense that will offset the A/R open items that are automatically posted as write-offs during the automatic A/R open item process. |
|
Enter the division code the system uses when automatically posting A/R open item write-offs. |
|
Enter the bank code the system uses when automatically posting A/R open item write-offs. |
Automatic A/R Open Item Write-off Periodic Function
Use the Working with Periodic Functions (WPER) menu option to create the automatic A/R open item write-off periodic function.
Note: You need to create a separate periodic function for each of your companies.
Function |
Enter the name of the automatic A/R open item write-off periodic function. Example: For company 1, enter ARWO001 and for company 2, enter ARWO002. |
Description |
Enter a description of the automatic A/R open item write-off periodic function. Example: For company 1, enter A/R OPEN ITEM WRITEOFF CO 001 and for company 2, enter A/R OPEN ITEM WRITEOFF CO 002. |
Company Parameter |
Enter N in this field. |
Appl Area |
Enter A/R in this field. |
Program Name |
Leave this field blank. |
Command |
Enter the following command, changing 999 to your company code. call acr0533 parm('' '' x'999F') |
Automatic A/R Open Item Write-off Periodic Process
Once you have created a A/R open item write-off periodic function for each of your companies, use the Working with Periodic Processes (WPPR) menu option to create the automatic A/R open item write-off periodic process.
Process |
Enter ARWRITEOFF in this field. |
Description |
Enter AUTO A/R OPEN ITEM WRITE-OFFS in this field. |
Type |
Enter how often you wish to run this periodic process. |
Appl Area |
Enter A/R in this field. |
At the Work with Process Assignments Screen (Assigning Functions to a Periodic Process), assign the Automatic A/R Open Item Write-off periodic functions that you have created to this periodic process.
See Executing Periodic Processes (EPRO) for more information on how to submit the periodic process and for more information on how to create a schedule to run the periodic process at scheduled intervals.
Automatic A/R Open Item Write-off Processing
When you submit the Automatic A/R Open Item Write-off Periodic Process, the system performs the following steps.
1. Verifies that automatic A/R open item write-off processing is enabled.
In order to use the automatic A/R open item write-off process, a value must be entered in one or both of these system control values:
• Dollar Limit for Automatic A/R Write-offs (K59)
• Number of Days Past Invoice Date for A/R Write-offs (K60)
2. Determines which A/R open items qualify for the automatic A/R open item write-off process.
In order for an A/R item to qualify, the open item must meet all of the criteria defined below:
• The A/R open item must be a debit open item.
• The A/R open item type must match the type in the Default Debit Open Item Type (B91) system control value.
• If a dollar amount is defined in the Dollar Limit for Automatic A/R Write-offs (K59) system control value, the Balance for the A/R open item must be equal to or less than the dollar amount defined in the Dollar Limit for Automatic A/R Write-offs (K59) system control value. Example: If this system control value is set to 10.00, A/R open items qualify for the automatic A/R open item write-off process if the balance for the open item is 10.00 or less.
• If a number of days is defined in the Number of Days Past Invoice Date for A/R Write-offs (K60) system control value, the Due date for the A/R open item in the A/R Open Item file must be older than the Invoice date (the Open item date in the A/R Open Item file) by the number of days defined in the Number of Days Past Invoice Date for A/R Write-offs (K60) system control value. Example: If this system control value is set to 30, A/R open items qualify for the automatic A/R open item process if the Due date is 30 days or older than the Invoice date (Open item date). For example, if the invoice date is 9/21/09, A/R open items whose due date is 8/22/09 or older qualify for the automatic A/R open item write-off process (9/21/09 - 30 days = 8/22/09).
3. Performs the same updates the system performs when you manually create a write-off at the Work with Payment Details Screen. For each A/R open item that qualifies, the system:
• Decreases the value in the Balance field for the A/R open item.
• Posts the A/R credit and A/R debit to the general ledger.
General ledger posting: The system posts the A/R open item write-off to the general ledger.
Automatic A/R open item write-off |
||
|
Debit |
Credit |
G/L Account: |
Sundry Cash Receipts G/L # |
A/R G/L |
File: |
Defined in the G/L Account to Offset Automatic A/R Write-offs (K61) system control value |
Division defined in the Default Division (K62) system control value |
Automatic A/R Open Item Write-off Examples
• Example 1: Dollar Limit for Automatic A/R Write-offs
• Example 2: Number of Days Past Invoice Date for A/R Write-offs
Example 1: Dollar Limit for Automatic A/R Write-offs
In this example:
• the Dollar Limit for Automatic A/R Write-offs (K59) = $10.00
• the Number of Days Past Invoice Date for A/R Write-offs (K60) = blank
• the G/L Account to Offset Automatic A/R Write-offs (K61) = 55455
• the Default Division (K62) = 54
• the Default Bank (K63) = USA
The following debit A/R open items exist whose type matches the Default Debit Open Item Type (B91):
Invoice |
Type |
Date |
Order# |
Total amt |
Paid amt |
Balance |
366 |
IN (invoice) |
9/21/09 |
1078 |
25.50 |
20.00 |
.50 |
367 |
IN (invoice) |
9/21/09 |
1079 |
100.00 |
60.00 |
40.00 |
When you run the Automatic A/R open item write-off process, the system includes the balance amount .50 for invoice 366 in the write-off. The system does not include the balance for invoice 367 in the write-off because 40.00 is greater than the dollar amount defined in the Dollar Limit for Automatic A/R Write-offs (K59) system control value.
The system updates the A/R Open Item file:
Invoice |
Type |
Date |
Order# |
Total amt |
Paid amt |
Balance |
366 |
IN (invoice) |
9/21/09 |
1078 |
20.50 |
20.00 |
.00 |
367 |
IN (invoice) |
9/21/09 |
1079 |
100.00 |
60.00 |
40.00 |
The system posts the following to the general ledger:
Entity |
Division |
G/L# |
Date |
Amount |
Journal Source |
554 |
54 |
5546 A/R G/L # in Division file for the Default Division (K62) |
09/21/09 |
.50 CR |
A/R |
554 |
54 |
55455 |
09/21/09 |
.50 |
Sund/C/R Sundry Debit |
Example 2: Number of Days Past Invoice Date for A/R Write-offs
In this example:
• the Dollar Limit for Automatic A/R Write-offs (K59) = blank
• the Number of Days Past Invoice Date for A/R Write-offs (K60) = 30
• the G/L Account to Offset Automatic A/R Write-offs (K61) = 55455
• the Default Division (K62) = 54
• the Default Bank (K63) = USA
The following debit A/R open items exist whose type matches the Default Debit Open Item Type (B91):
Invoice |
Type |
Inv Date |
Due Date |
Order# |
Total amt |
Paid amt |
Balance |
372 |
IN (invoice) |
9/21/09 |
8/22/09 |
1084 |
25.50 |
20.00 |
.50 |
373 |
IN (invoice) |
9/21/09 |
8/23/09 |
1085 |
61.50 |
61.00 |
.50 |
When you run the Automatic A/R open item write-off process on 09/21/09, the system includes the balance amount .50 for invoice 372 in the write-off. The system does not include the balance for invoice 373 in the write-off because the due date is not past due by the Number of Days Past Invoice Date for A/R Write-offs (K60) system control value (due date 8/23/09 - 30 days in SCV K60 = 29 days).
The system updates the A/R Open Item file:
Invoice |
Type |
Inv Date |
Due Date |
Order# |
Total amt |
Paid amt |
Balance |
372 |
IN (invoice) |
9/21/09 |
8/22/09 |
1084 |
20.50 |
20.00 |
.00 |
373 |
IN (invoice) |
9/21/09 |
08/23/09 |
1085 |
61.50 |
60.00 |
.50 |
The system posts the following to the general ledger:
Entity |
Division |
G/L# |
Date |
Amount |
Journal Source |
554 |
54 |
5546 A/R G/L # in Division file for the Default Division (K62) |
09/21/09 |
.50 CR |
A/R |
554 |
54 |
55455 |
09/21/09 |
.50 |
Sund/C/R Sundry Debit |
Work with Alternate Currency Payment Details Screen
Purpose: Use this screen for:
• Redirecting open item payments by posting an amount to specific general ledger accounts.
• Posting a discount toward an open invoice balance in the alternate currency.
• Posting a write-off or adjustment of all or part of an open invoice balance in the alternate currency.
You can post to multiple general ledger accounts if you want to track money received at a more detailed level.
Posting an Amount to a Specific General Ledger Account
When you post cash to a specific general ledger account, the system:
• Increases the value in the Amount applied field.
• Decreases the value in the Amount remaining field .
• Decreases the value in the Balance field .
To apply a payment to a specific general ledger account, complete the Amount and G/L number fields.
Posting a Discount to a Specific General Ledger Account
When you post an discount amount in the field to a specific general ledger account, the system:
• Posts that amount to a sundry account.
• Increases the value in the Sundry total field on the Pay Alternate Currency Open Items Screen.
• Decreases the value in the Balance field.
To apply a discount to a specific general ledger account, complete the Discount field and the G/L number field.
Posting a Write-off or Adjustment to a Specific General Ledger Account
When you post a write-off or adjustment to a specific general ledger account, the system:
• Posts that amount to a sundry account.
• Increases the value in the Sundry total field on the Pay Alternate Currency Open Items Screen.
• Decreases the value in the Balance field.
To apply a write-off or adjustment to a specific general ledger account, complete the Write off/adjustment field and the G/L number field.
How to display this screen: Enter 7 next to an invoice open item in an open (O) or disputed (D) status at the Pay Alternate Currency Open Items Screen.
ACR0510 ENTER Work with Alt. Currency Payment Details 4/16/02 10:36:15 KAB Co. Currency code: JPY
Customer : 51 LETENDRE, ROBERT R Check # : 39393 Check Amount: 2000.00 Amount Applied : .00 Amount Remaining: 2000.00
Open item # . . . : 2859 Type : IN Date . . . . . . . : 4/15/02 Balance . . . . . : 11002.00 Amount . . . . . . . G/L Number . Discount . . . . . . G/L Number . Write off/Adjustment G/L Number .
F3=Exit F12=Cancel |
Field |
Description |
Currency code |
The code for the currency associated with the bank you selected to post cash receipts. Alphanumeric, 3 positions; display-only. |
Customer number |
The bill-to account number. See Customer Service Chapter 30: Creating and Updating Bill-to Customers (WCBT). Numeric, 8 positions, display-only. |
Bill-to name |
The name on the bill-to customer account. Alphanumeric, 42 positions; display-only. |
Check # |
The number on the customer's check that you entered at the Pay Alternate Currency Open Items Screen. Numeric, 7 positions; display-only. |
Check amount |
The amount of the customer’s check in the alternate currency that you entered at the Pay Alternate Currency Open Items Screen. Numeric, 10 positions with a 2-place decimal; display-only. |
Amount applied |
The total dollars in the alternate currency currently applied to the customer's open items during the current posting session. The system updates this field as you apply payment to open items. Numeric, 10 positions with a 2-place decimal; display-only. |
Amount remaining |
The unused portion of a payment in the alternate currency to be applied during a posting session. Numeric, 10 positions with a 2-place decimal; display-only. |
Open item # |
A system-assigned number that identifies an invoice. Numeric, 7 positions; display-only. |
Type |
A code that identifies an A/R record 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 Chapter 1: Establishing Accounts Receivable Types (WART). Numeric, 2 positions; required. |
Date |
The date the invoice was created through the Billing function. Numeric, 6 positions (MMDDYY format); display-only. |
Balance |
The amount the customer owes on an invoice in the alternate currency. Numeric, 9 positions with a 2-place decimal; display-only. |
Amount |
The amount in the alternate currency that you want to post to a specific general ledger account number for the open item selected. Numeric, 10 positions with a 2-place decimal; optional. |
Discount |
A amount in the alternate currency that will apply to the open item as a discount. Your entry here will update the Sundry total field on the Pay Alternate Currency Open Items Screen. Numeric, 10 positions with a 2-place decimal; optional. |
Write off/adjustment |
The portion of an invoice balance in the alternate currency that you are writing off. Your entry here will update the Sundry total field on the Pay Alternate Currency Open Items Screen. Numeric, 10 positions; optional. |
Although values in the Amount, Discount, and Write off fields are optional, you must complete one of them to complete a payment detail transaction. |
|
G/L number |
The number that identifies an account used for posting a specific type of financial activity. General ledger account numbers are defined in and validated against the General Ledger Account file. Numeric, 8 positions; optional. |
Purpose: You can use the Pay Open Items Screen to apply existing credit open items on the customer's account to invoice open items. You can:
• Apply Credit to Debit Pop-Up Window individually, or
• Applying All Available Credits at once
Sample screen: The options available for applying credits to debits are highlighted in the sample screen below.
ACR0049 DISPLAY Pay Open Items 5/11/99 8:55:41 KAL Co.
Customer: 7 BAXTER, CLARA W Code K Check Check # : Amount: Amount applied : .00 Sundry Total . : 7.90 Amount remaining: .00 ? S Invoice Tp Date Order# Total amt Paid amt Balance Pay amt
Type options, press Enter. 2=Change 5=Display 6=Pay in full 7=Detail entry 8=Apply credit to debit P 0 IN 5/05/99 15.00 7.10 .00 O 322 IN 5/05/99 2656 72.00 .00 72.00 O 323 IN 5/05/99 2657 57.90 .00 57.90 O 324 IN 5/05/99 2658 72.00 25.00 47.00 O 325 IN 5/05/99 2659 72.00 .00 72.00 O 0 CM 5/06/99 50.00 .00 50.00 O 0 IN 5/06/99 30.00 .00 30.00 O 0 OA 5/06/99 75.00 .00 75.00 O 351 IN 5/11/99 2661 66.00 .00 66.00 +
F2=Opt on/off F6=Create F9=Accept F11=Reject F17=On-account F18=Sundry entry F19=Apply cash F20=Apply credits F22=User defined option |
Apply Credit to Debit Pop-Up Window
Enter 8 next to a credit or on-account open item to apply it to an invoice open item. The credit open item must be in an open (O) status. Also, the open item must not be the credit open item type defined in the Default Check Credit Open Item Type (E82) or Default Credit Card Credit Open Item Type (E83) fields in the System Control file, as these credits are flagged to create refund checks or credit card credits. If the credit open item is eligible for application, a pop-up window displays:
Apply Credit to Debit
Credit open item : 1143 Invoice . . . . : 0 Balance . . . . : 2.52
Apply to Invoice .
Or to open item .
F12=Cancel |
Each of the fields in this pop-up window are described under Pay Open Items Screen. Enter the number of the invoice or of the open item you want to credit.
Note: The invoice or open item you enter must be in an open status.
The system applies the credit to the open item you selected, reducing the invoice and credit balances as appropriate. If applying the credit exhausts the balance of either the invoice or the credit, the status of the appropriate open item changes to P (processed). Also, the Paid date is updated with the current date.
Applying All Available Credits
Press F20 to apply all available credit open items to all unpaid invoices. The system:
• selects all eligible credit open items; i.e., those that are in an open (O) status, and are not flagged for credit card credits or refund checks (see above). Disputed or allocated credits are not selected;
• selects all eligible invoice open items; i.e., those that are currently open (O);
• applies the total credit amount against the invoices until all invoices are paid or the total credit amount is exhausted;
• updates each open item record as described in the preceding paragraph.
Purpose: Use this screen to create new debit or credit open item for a customer account.
How to display this screen: Press F6 at the Pay Open Items Screen.
ACR0053 ENTER Create A/R Open Item 2/14/97 13:21:20 Mail Order Company
Customer : 21 EAST COAST DEVELOPMENT ATTN: JACKSON, JOE Check # : 310 Check amount: 100.00 Amount applied : 100.00 Amount remaining: .00
Type . . . . . . . Amount . . . . . . Debit G/L # . . . . Credit G/L # . . . Due date . . . . . Discount due date . Terms . . . . . . . Note . . . . . . .
F3=Exit F12=Cancel |
Field |
Description |
Type |
The open item type that you are creating. A/R type codes are defined in and validated against the A/R Type file; see Chapter 1: Establishing Accounts Receivable Types (WART). Numeric, 2 positions; required |
Amount |
The dollar amount you are posting to the new record. Numeric, 10 positions with a 2-place decimal; required. |
Debit G/L # |
A number that identifies the account used for posting the debit transaction. General ledger numbers are defined in and validated against the General Ledger Accounts file. See Accounts Payable Chapter 2: Working with G/L Accounts (WGLA). Numeric, 8 positions; required. |
Credit G/L # |
A number that identifies the account used for posting the credit transaction. General ledger numbers are defined in and validated against the General Ledger Accounts file. See Accounts Payable Chapter 2: Working with G/L Accounts (WGLA). Numeric, 8 positions; required. |
Due date |
The date when the customer is required to make payment on an open invoice. If you do not enter a value, the system automatically assigns the current date as the due date. Numeric, 6 positions (MMDDYY format); optional. |
Discount due date |
The date when the customer must pay the invoice to receive a discount. Discount percentages are defined in the Terms file; see Chapter 9: Working with Terms (WAPT) of the Accounts Payable manual for more information. Numeric, 6 position (MMDDYY format); optional. |
Terms |
A code that identifies the conditions under which payment is due. For example, you might have a term that requires payment within 30 days of the invoice date, while another provides a discount if payment is received by the end of the month. You can set up terms codes to apply to accounts payable, accounts receivable, or both. See Accounts Payable Chapter 9: Working with Terms (WAPT). Numeric, 2 positions; optional. |
Note |
A short note about the invoice. You can display the note through the Change A/R Open Item Screen and Display A/R Open Item Screen. Alphanumeric, 25 positions; optional. |
Confirm On-Account Payment Window (Posting On-Account Payments)
You post cash on-account when a customer overpays an invoice or pays for an order before placing it. Posting cash on-account creates an on-account open item. This open item will be available to apply to invoices in the future, or you can flag the open item to produce a refund check. Also, you can allocate this open item toward payment of a new order if the Allow A/R Credits as Payments (E81) system control value is set to Y.
How to create an on-account open item: Press F17 at the Pay Open Items Screen. The system displays the Confirm On-Account Payment pop-up window:
Confirm On-Account Paymnt
Customer : 185
The remainder of check 2 will be applied on-account.
Check amount . : 100.00 Amount applied : 54.50 On-account . . : 45.50
Press ENTER to confirm or F12 to cancel.
F12=Cancel |
Field |
Description |
Customer |
A system-assigned number to identify a bill-to customer account. See Customer Service Chapter 30: Creating and Updating Bill-to Customers (WCBT). Numeric, 8 positions. |
Check amount |
The total dollar amount to be posted to the account. This is the value you entered in the Amount field on the Pay Open Items screen. Numeric, 10 positions with a 2-place decimal. |
Amount applied |
The total dollar amount currently posted to the account. Numeric, 10 positions with a 2-place decimal. |
The dollar amount posted on-account during this transaction. Numeric, 10 positions with a 2-place decimal. |
Applying the balance: Press Enter to post the value in the On-account field: The system:
• Creates a new on-account open item
• Applies the value in the On-account field to the new on-account open item
• Increases the value in the Amount applied field
• Changes the value in the Amount remaining field to .00
Reject on-account posting: Press F12 to cancel the on-account payment function.
The on-account open item type: The system determines the A/R open item type to use by checking the A/R Type file. It selects the first A/R type it finds with a classification of O (on account). See Chapter 1: Establishing Accounts Receivable Types (WART).
See also: See Work with Payment Details Screen for another method of applying payment to an invoice open item.
Work with Sundry Transactions Screen
Purpose: Use this screen to create and delete sundry entries.
Sundry transactions allow you to make direct postings to the general ledger to record miscellaneous cash. For example, when you give a customer a discount because of a late delivery, you might post the discount to the general ledger sundry account to attribute that cash to the correct account.
How to display this screen: Press F18 at the Pay Open Items Screen.
ACR0275 DISPLAY Work with Sundry Transactions 6/13/97 14:28:23 Mail Order Company
Amount Available: .00 Remaining . . . : 79.00
Opt Amount Debit G/L Credit G/L .00
Type options, press Enter. 4=Delete
189.00 100500 0 268.00 0 100100 245.00 10010101 10070000
F9=Accept F11=Reject |
Field |
Description |
Amount available |
The total amount that can be posted during a sundry transaction. This field has the same value as the Amount remaining field on the Pay Open Items screen. Numeric, 10 positions with a 2-place decimal; display-only. |
Remaining |
The dollar amount left to be posted . Numeric, 10 positions with a 2-place decimal; display-only. |
Amount |
The dollar amount applied during a sundry transaction. Numeric, 15 positions with a 2-place decimal; required. |
Debit G/L (Debit general ledger account number) |
The general ledger number to use for posting the debit transaction. General ledger numbers are defined in and validated against the General Ledger Accounts file. You must enter either a debit g/l number, a credit g/l number, or both. Numeric, 8 positions; required if you don't enter a credit g/l number. |
Credit G/L (Credit general ledger account number) |
The general ledger number to use for posting the credit transaction. General ledger numbers are defined in and validated against the General Ledger Accounts file. Numeric, 8 positions; required if you don't enter a debit g/l number. |
To post a sundry transaction: Complete the Amount field and either the Debit G/L or the Credit G/L field, or both. Only one G/L number is required, either debit or credit.
Out of balance warning: If the entire value in the Remaining field is not posted, the Out of Balance Warning pop-up window appears:
Out of Balance Warning
79.00- has not been applied. Press F9 to accept and F12 to cancel.
F9=Accept F12=Cancel
|
The effect your entries at the Work with Sundry Transaction screen have on the Remaining field are:
Entry amount is... |
General ledger number entered is... |
Effect on the Remaining field is... |
Positive (Field Exit) |
Debit |
Increases |
Negative (Field Minus) |
Debit |
Decreases |
Positive |
Credit |
Decreases |
Negative |
Credit |
Increases |
Positive or negative |
Both debit and credit |
No effect |
Screen Option |
Procedure |
Accept the sundry transactions and return to the Pay Open Items Screen |
Press F9. |
Reject sundry transactions |
Press F11. |
Display Batch Deposit Totals Screen (Completing a Deposit)
Purpose: Once you complete your entries in cash receipts, use this screen to verify and accept your postings. Accepting the batch deposit will compare the total dollar amount you posted against the amount you entered at the Cash Receipts Screen (Cash Batch Settings).
How to display this screen: Press F9 at the Select Customer Bill-To Screen to accept all of your current transactions in cash receipts, including posting cash to deferred liability (described in Chapter 3: Working with Cash Receipts (WCRT)) and posting transactions against individual customer accounts using the Pay Open Items Screen.
ACR0274 ENTER Display Batch Deposit Totals 2/15/97 10:40:34 Jeannes Company
Batch #: 569
Total Deposit . : .00
Deferred Liability: .00 A/R Deposits . . : .00 Sundry Deposits . : .00
F3=Exit F12=Cancel |
Field |
Description |
Batch # |
A system-assigned number that identifies the batch of cash receipts you posted. Numeric, 7 positions; display-only. |
Total deposit |
The total dollar amount that you posted. Numeric, 11 positions with a 2-place decimal; display-only |
Deferred liability |
The total amount that you posted to deferred liability. Numeric, 11 positions with a 2-place decimal; display-only. |
A/R deposits |
The total amount that you posted to open items. Numeric, 11 positions with a 2-place decimal; display-only. |
Sundry deposits |
The total amount that you posted to the sundry account. Numeric, 11 positions with a 2-place decimal; display-only. |
Accepting the batch deposit: Press Enter to accept the batch deposit and advance to the next screen.
• If the value in the Total deposit field equals the deposit amount you entered at the Cash Receipts Screen (Cash Batch Settings), you return to the main menu.
• If the value in the Total deposit field does not equal the amount you entered at the Cash Receipts Screen (Cash Batch Settings), you return to the Cash Receipts screen where the Deposit total field is highlighted. Adjust the deposit amount and press Enter to accept the batch deposit.
See Chapter 3: Working with Cash Receipts (WCRT).
| Chapter 3: Working with Cash Receipts (WCRT) | Contents | SCVs | Search | Glossary | Reports | XML | Index | Chapter 5: High Speed A/R Payment Entry and Batch Processing (WABP) |
AR02_02 CWDirect 18.0 August 2015 OTN