My Oracle Support Banner

E1: 49: Freight Audit History (P4981) Uses Exchange Rate from Actual Ship Date Instead to Use G/L Date From Header for getting the Exchange Rate (Doc ID 2594277.1)

Last updated on OCTOBER 31, 2019

Applies to:

JD Edwards EnterpriseOne Transportation Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

When it uses P4981 to entry the freight adjustment entries in foreign currency, the application ignores the G/L date from header for getting the exchange rate and uses the exchange rate from Actual Shipment Date.

Steps to replicate :

         1. Enter a transportation Sales order for a client with foreign currency(AED). Set Order date (05/20/2019) before Requested date. The Exchange Rate (5 ) is retrieved from the Requested date = G/L Date.
         2. Open P4915 and found the shipment number of the order.
         3. Route the Shipment .
         4. Approve the Shipment .
         5. Confirm the Shipment and change the Actual Ship date.
         6. Run R4981 (Freight Update and Report) in final mode for the shipment number above.
         7. Open P4981 Freight Audit History and found the foreign currency shipment. Select the record from the grid and click on Adjustment menu under the row exit.
         8. The base amount for freight was calculated in base currency using foreign exchange from the G/L Date (5).
         9. Add a new freight line . Enter Foreign Amount and Net Foreign Amount . The domestic amount will be calculated automatically but the exchange rate used for this is based on Actual Ship date and not based on G/L Date .

When it uses P4981 to entry the freight adjustment entries in foreign currency, the application has to use the G/L date from header for getting the exchange rate .

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


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