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:

Symptoms

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.

Changes

Cause

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