Understanding Lockbox Transactions

You can use EDI to receive Accounts Receivable cash receipts. To receive cash receipts, you run a program that converts and transfers the EDI information from the format that was sent by the trading partner in the EDI tables into the format used by the F03B13Z1 table. To process cash receipts received through EDI, you must understand the mapping requirements for the receipt at the time the transactions are received.

When you run EDI - Update Electronic Receipts (R47111), the program edits the data that it receives from the trading partner and uses the data from the EDI interface tables to update the F03B13Z1 table.

This table describes the steps you complete after you have used the third-party translator software to access the EDI data from the trading partner:

Step

Description

Review status information

Use the EDI Inbound Payment Inquiry option on the Lock Box (823) menu to review information about the inbound lockbox transactions.

Revise lockbox information

If you know that the inbound documents have errors, use the EDI Inbound Payment Inquiry option on the Lock Box (823) menu to revise lockbox header, deposit, payment, and remittance information.

Receive the lockbox transactions

Use Update to Electronic Receipts on the Lock Box (823) menu to convert the flat files to the JD Edwards EnterpriseOne application programs

Review electronic receipts

Use the Review Electronic Receipts option on the Automated Receipts Processing menu (G03B13) to revise transactions that the system transfers to the F0312 table.

Apply receipts to invoices

Use the Apply Receipts to Invoices option on the Automated Receipts Processing menu to apply deposits against open accounts receivable.

Print the bank deposit journal

Use the Print Bank Deposit Journal option on the Lock Box (823) menu (G47264) to print a report that lists all workfile batch cash applications.