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 laterInformation in this document applies to any platform.
Symptoms
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:
- Setup a new item in the Mexican Branch (250) with a base price of 2,000 MXN.
- Adjust Inventory so there is inventory available to sell.
- Create a Price Adjustment Definition (P4071).
- Adjustment Control Code = 6 (Print on Invoice Detached).
- Attach the Adjustment to a schedule (P4070).
- Attach the Schedule to the EUR Currency Customer Billing Instructions (P03013).
- Create an Adjustment Detail (P4072) record. For the EUR Customer and MXN Item Branch for 2.0000 with Basis Code 5.
- Create a Sales Order for the EUR Customer in the MXN Branch Plant for 10 EA.
- Exchange Rate is set to 0.05 EUR to MXN.
- Price in EUR = 100.00 after conversion from MXN.
- Extended Price = 1,000.00 EUR.
- Save the order.
- Reinquire on the Sales Order and take the Row Exit to Online Invoice.
- The Online Invoice has the Foreign Checkbox checked and Currency set to EUR.
- Extended Amount for Item is 1,000.00 EUR.
- Detached Adjustment is 20.00 EUR.
- Invoice Total is 1,020.00 EUR.
- Uncheck the Foreign Checkbox. Currency changes to MXN
- Extended Amount for Item is changed to 20,000.00 MXN
- Detached Adjustment is 400.00 MXN
- Invoice Total is 20,400.00 MXN
- Setup the Invoice Print (R42565) processing options as follows:
- Print Tab Option #6 (Print Available Discount) - value is blank
- Print Tab Option #13 = 1 (Print Foreign Currency - EUR)
- Print Tab Option #20 (As-If Currency Code = MXN – Use Base Currency)
- 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.
- Add a new Exchange Rate in Revise Currency Exchange Rates (P0015A):
- Set From Currency = MXN
- Set To Currency = MXN
- Set Multiplier Rate = 1.00000
- Save the new Exchange Rate
- Run the Invoice Print (R42565) Version and view the PDF Totals Section
- 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
- The Totals Section appears as follows:
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)
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |