Understanding How to Process Automatic Receipts in a Foreign Currency

You can process automatic receipts in either the domestic or the foreign currency of an invoice. To process automatic receipts in multiple currencies, you must enter the currency code, exchange rate, and currency mode in the Electronic Receipts Input table (F03B13Z1). The currency code of the receipt must reflect either the domestic or foreign currency of the invoices being paid. You cannot process automatic receipts in an alternate currency. Instead, you must enter them manually through the Standard Receipt Entry program (P03B102).

Automatic receipts processing uses these tables:

  • Electronic Receipts Input (F03B13Z1).

    This table contains information that was loaded from a bank tape, and therefore contains information that was entered at the bank.

  • Receipts Header (F03B13).

    The system creates records in this table when you run the Update Receipts Header program (R03B551).

  • Receipts Detail (F03B14).

    The system creates unapplied cash (RU) records in this table when you run the Update Receipts Header program.

To successfully upload automatic receipt entries from an external source and process them in the JD Edwards EnterpriseOne system, you must first create a custom program that provides proper data to fields in the F03B13Z1 table.

To successfully match and apply foreign currency receipts to invoices, define processing options for the algorithms that you use and understand what information is required by the F03B13Z1 table. You can define algorithms for Invoice Selection Match (R03B50A), Balance Forward Match (R03B50B), Known Invoice Match With Amount (R03B50D), Known Invoice Match Without Amount (R03B50E), and Combination Invoice Match (R03B50F).