Maintain An Imported AR Remittance Batch

Use the EDI 820 Maintenance (PRCE) program to maintain and delete imported customer payment batches and to transfer batches of payments to Cash Receipts Entry (RCE) for further processing. See Background: AR Payment Import for more information.

Imported remittance batches with errors are listed:

Field Name

Description

Deposit no

The batch number assigned to the imported 820 batch

Deposit date

The date associated with the imported deposit

Deposit total

The total amount of the imported deposit

Cash entered

The sum of the cash from detail records
  1. Select the deposit you want to maintain.

  2. (Optional) Click View errors or refer to the AR Pending Payment Error Report that emailed as part of the import process.

  3. Click Transfer to transfer the selected deposit to Cash Receipts Entry (RCE) for further processing. After errors are resolved, repeat this step.

  4. Click Payments to display payment details.

If the customer number, payment method, payment date, or payment amount is incorrect, it is advisable to delete the batch and request that a corrected file be sent from the EDI partner.

  1. Select the payment record you want to maintain. The following data is displayed:

Field Name

Type/Max Length

Action/Description

Customer number

Display only

The customer number

Check/Ref no

Display only

The check or payment reference number

Payment method

Display only

The payment method

Misc cash receipt?

Display only

The miscellaneous cash receipt flag; always blank or N for 820 transactions

Payment date

Required
10 date

Accept the payment date or select a different date for this transaction

Payment amount

Required
14 numeric in the format 99999999999.99

Accept the payment amount or enter a different amount

Cash org code

 

Leave blank to use the posting criteria set up in the Posting Criteria Maintenance (XPC) program or select the code for cash organization under which the money is to be deposited.

Cash account no

 

Leave blank to use the posting criteria set up in the Posting Criteria Maintenance (XPC) program, enter the cash account number in which the money is to be deposited, or click the Lookup icon and use the standard lookup options to select the account from a list.

Sold-to cust no

 

Enter the sold-to customer if you are receiving a payment from an AR consolidated customer and you want to correct the customer it was actually sold to.

You can click the Lookup icon and use the standard lookup options to select the customer from a list.

Processing fee

 

Leave blank to have the system supply or calculate the fee or enter an amount for this payment.

If you leave blank when you press F10, the system displays the calculated fee: Payment amount x Processing fee % or the amount entered in the Processing fee (amt) field for this payment method in the Payment Methods Maintenance (TPMM) program.

Credit auth code

 

Enter the authorization code for the credit card.

ABA number

 

Enter the American Banking Association Number printed on the customer's check.

  1. Click Applications to review payment application details.

Before going to the Applications screen, the program may display a summary of errors at the payment level.  For example, if this check number has already been processed, you will see this error message on the screen. Click OK or Exit to acknowledge the error(s); the applications screen is then displayed.

  1. To correct an invalid invoice number, highlight the appropriate invoice, click Change invoice and enter correct information.

  2. Highlight an invoice and click OK to adjust payment and discount amounts. The following fields are displayed:

Field Name

Type / Max Length

Action / Description

Deposit number

Display only

The deposit number

Customer number

Display only

The customer number

Check/Ref no

Display only

The check or payment reference number

Payment method

Display only

The payment method

Misc. cash receipt?

Display only

N

Invoice no

Display only

Invoice number

Transaction type

Display only

Transaction type

Payment amount

Required
14 numeric in the format 999999999999.99

Accept the displayed value or enter the correct amount for this transaction, including payment fees, to be applied to the customer's account. The program deducts the fees when it calculates the total bank deposit.

Discount amount

Required
14 numeric in the format 999999999999.99

Accept the displayed value or enter the correct discount amount

Reference

Optional
30 alphanumeric

Accept the displayed Reference or enter the correct information

Adj/distribution code

Optional
10 alphanumeric code

Accept the displayed code or select a different one

GL org code

Display only

The GL organization code

GL account no

Display only

The GL account number

When you exit the invoice transaction maintenance screen, an error check is performed and any errors found at the invoice level are displayed.