Accounts Receivable and Accounts Payable Affected by the Conversion

The base currency conversion programs convert Oracle's JD Edwards EnterpriseOne Accounts Receivable and Oracle's JD Edwards EnterpriseOne Accounts Payable amounts in these tables:

  • Customer Ledger (F03B11)

  • Invoice Revisions (F03B112)

  • Receipts Header (F03B13)

  • Receipts Detail (F03B14)

  • Accounts Payable Ledger (F0411)

  • Accounts Payable Matching Document Detail (F0414)

    Note: The accounts payable conversion programs do not convert amounts in the F0414 table; however, the currency mode on domestic payments is updated to foreign.

The conversion programs convert amounts differently, depending on the type of transaction:

  • Domestic-only transaction.

    The original domestic currency amount (the base currency before the conversion) is used to derive the new domestic currency amount (the base currency after the conversion). The original domestic amount becomes the foreign amount.

  • Foreign currency transaction that is not in the new base currency.

    The original domestic amount (the base currency before the conversion) is used to derive the new domestic currency amount (the base currency after the conversion). The original foreign transaction remains the same, but the rate on the transaction is changed to a calculated rate that is derived by dividing the new base currency amount by the foreign currency amount.

  • Foreign currency transaction that is in the new base currency.

    The new domestic amount is updated with the value stored in the original foreign amount The original foreign transaction is deleted (because the new domestic amount is stated in the foreign currency).