My Oracle Support Banner

E1: 49: G/L Amount Generated By Freight Update (R4981) Different Than Freight Accrued Amount (Doc ID 2451829.1)

Last updated on APRIL 26, 2023

Applies to:

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


F0911 G/L amount generated by Freight Update R4981 is different than Freight accrued amount.

When running the freight update for a carrier with Tax setup with two rates (5+9.975) for Canada (C tax explanation code on Carrier in P04012), the amount booked in G/L is different than the accrued amount in the Freight Audit History Table (F4981). For example amount accrued is 7254 CAD while in G/L 7977.59 CAD is booked. The variance between the two amounts matches exactly the percentage of the second rate (9.975 %).

Issue does NOT occur with V tax explanation code.

 Steps to replicate:

  1. Setup a tax rate in P4108 defined with 2 different rates (5% + 9.975%), attach this to a freight carrier with tax explanation code C.
  2. Raise a transportation order where  the route will use this carrier.
  3. Approve/confirm shipment and then run the order through Freight Update R4981.
  4. Notice that the GL amount and freight amount accrued are different - for example 7977.59 and 7254. It has been observed that when the variance is calculated (in this case 7977.59 - 7254 = 723.59).....then the amount of the variance exactly matches the freight amount multiplied by the second percentage. For example 0.09975 * 7254 = 723.5865, rounded to 723.592.

    R4981 should match F0911 record with F4981 record.

    Alternative solution:
    Set carrier with V tax explanation code instead of C or correct the G batch manually.




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.