My Oracle Support Banner

E1: 42: 45: Invoice Print (R42565) Does Not Print As-If Currency Correctly on an Invoice with Type 6 Detached Adjustment (Doc ID 2988819.1)

Last updated on DECEMBER 20, 2023

Applies to:

JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.


If a Foreign Currency Sales Order with a Type 6 Detached Adjustment is processed by Invoice Print (R42565) with Print Tab Option #20 (As If Currency Code) set the same as the Base Currency and with an Exchange Rate of 1.000 setup with From Currency and To Currency = Base Currency, the Base Currency is not Printed correctly in the Totals section on the Invoice PDF.

Steps to Duplicate:

  1. Setup a new item in the Mexican Branch (250) with a base price of 2,000 MXN.
  2. Adjust Inventory so there is inventory available to sell.
  3. Create a Price Adjustment Definition (P4071).
    1. Adjustment Control Code = 6 (Print on Invoice Detached).
  4. Attach the Adjustment to a schedule (P4070).
  5. Attach the Schedule to the EUR Currency Customer Billing Instructions (P03013).
  6. Create an Adjustment Detail (P4072) record. For the EUR Customer and MXN Item Branch for 2.0000 with Basis Code 5.
  7. Create a Sales Order for the EUR Customer in the MXN Branch Plant for 10 EA.
    1. Exchange Rate is set to 0.05 EUR to MXN.
    2. Price in EUR = 100.00 after conversion from MXN.
    3. Extended Price = 1,000.00 EUR.
    4. Save the order.
  8. Reinquire on the Sales Order and take the Row Exit to Online Invoice.
  9. The Online Invoice has the Foreign Checkbox checked and Currency set to EUR.
    1. Extended Amount for Item is 1,000.00 EUR.
    2. Detached Adjustment is 20.00 EUR.
    3. Invoice Total is 1,020.00 EUR.
  10. Uncheck the Foreign Checkbox. Currency changes to MXN
    1. Extended Amount for Item is changed to 20,000.00 MXN
    2. Detached Adjustment is 400.00 MXN
    3. Invoice Total is 20,400.00 MXN
  11. Setup the Invoice Print (R42565) processing options as follows:
    1. Print Tab Option #6 (Print Available Discount) - value is blank
    2. Print Tab Option #13 = 1 (Print Foreign Currency - EUR)
    3. Print Tab Option #20 (As-If Currency Code = MXN – Use Base Currency)
  12. The As-If Currency processing option on Print Tab Option #20 (As-If Currency Code) of Invoice Print (R42565) MXN which is also the Base Currency on the order. This means the program will try to convert the As-If Currency MXN to the Base Currency MXN and no conversion has been setup From MXN to MXN.
  13. Add a new Exchange Rate in Revise Currency Exchange Rates (P0015A):
    1. Set From Currency = MXN
    2. Set To Currency = MXN
    3. Set Multiplier Rate = 1.00000
    4. Save the new Exchange Rate
  14. Run the Invoice Print (R42565) Version and view the PDF Totals Section
    1. The Totals Section appears as follows:
      • EUR Amount 1,020.00 - matches On-Line Invoice amount
      • MXN Amount 40,000.00 – Does NOT match On-Line Invoice amount of 20,400.00

 On-Line Invoice Foreign = 1,020.00 EUR

On-Line Invoice Domestic = 20,400.00 MXN

Print Invoice (R42565) Processing Options

From Currency = MXN To Currency = MXN Exchange Rate = 1.000

Invoice Print (R42565) Domestic Currency (40,000 MXN) Does Not Match On-Line Invoice (20,400 MXN)




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.