A/R Batch Payment List

Purpose: The system produces this report each time you process an A/R batch or group of batches through High Speed A/R Payment Entry and Batch Processing (WABP). This report lists:

• the invoices that have been processed by batch number

• a total for each batch

• the status of each invoice

• the payment amount for each invoice

• any errors that occurred during processing

CWDirect Rel 7.5 A/R Batch Payment List EKAPLAN ACR0348 10/02/03 13:23:41 Page 1 EZK Mail Order Batch # 1445 Payment date 10/01/03 Division 01 Bank # 001 Invoice# Bill To# Sts Check# Opn Item# Amount Error Code Sold To# Pick Ctl# 0 0 E 123 0 20.00 Pick Ctl # does not exist 524 10843 435 1 E 0 1911 10.00 Invalid Invoice Type 0 0 2892 292 E 0 1390 10.00 Invoice Status Closed 0 0 0 0 P 222 2874 19.80 Processed 294 10967 0 0 P 333 2874 19.80 Processed 294 10966 6810 446 P 444 2875 50.00 Processed 0 0 Total amount deposited: 89.60 Total amount in error: 40.00 Total amount processed: 129.60

Contents:

Header information:

• batch number

• payment date

• division

• bank number

For each payment:

• invoice number

• bill to number

• status (the status of a payment within the batch. Valid values are:

• E = an error occurred during processing

• P = the payment has been processed)

• check number

• open item number

• amount

• error code (a code that identifies the status or error that occurred for this invoice during processing). Error codes that can occur during A/R batch payment processing are:

• Overpayment = The payment amount entered for this invoice exceeds the invoice amount.

• Underpayment = The payment amount entered for this invoice is less than the invoice amount; this error occurs only if the Allow Underpayment in A/R Batch Processing (I44) system control value is set to N.

• Invoice Status Closed = The invoice is not currently open. This error occurs if the invoice is paid, allocated to an order or in dispute. See the open item S (Status) field for a discussion of possible statuses.

• Invoice Does Not Exist = The specified invoice number does not exist, or the specified bill-to customer does not exist. If you received the payment through the Uploading A/R Batch Payments, this error could indicate that the Inbound A/R Payment XML Message (ARPayment) did not include valid or complete information. For example, this error occurs if the message included just a sold-to customer but not a pick control number; or just a bill-to customer but not an invoice number; or just the open item number.

• Invoice/Bill To Mismatch = The specified invoice number and bill-to customer number exist, but are not associated with each other

• Invoice Invalid Type = The open item type does not match the Default Debit Open Item Type (B91) system control value

• Pick Ctl # does not exist = The specified pick control number does not exist, or is not associated with an open item

• Missing A/R G/L Account # = The A/R general ledger account number for the division is blank. See the Change Division G/L Screen for more information. If you received the payment through the Uploading A/R Batch Payments, this error could indicate that the division number was blank or invalid in the Inbound A/R Payment XML Message (ARPayment).

• Bill To/Sold To Mismatch = The specified pick control number is not associated with the specified sold-to customer. If you received the payment through the Uploading A/R Batch Payments, this error could indicate that the Inbound A/R Payment XML Message (ARPayment) included a valid pick control number but did not specify a sold-to customer.

• Miscellaneous/Other Error = this message defaults when an error not generated by one of the other problems, for example, when a system error occurs.

• Missing Cash G/L Account # = If you received the payment through the Uploading A/R Batch Payments, this error could indicate that the division number was blank or invalid in the Inbound A/R Payment XML Message (ARPayment).

• sold-to number

• pick control number

• total amount deposited

• total amount in error

• total amount processed

Any invoices that are in error did not process. If the Retain A/R Batch Errors After Processing (I33) system control value is set to Y, and if the error has to do with the payment amount, sold to number, or pick control number, you can correct the error and resubmit the batch.

See Enter Batch Payments Screen for a complete description of each field.