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

Last updated on MARCH 16, 2020

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 REPRODUCE
==================
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.

DESIRED OUTCOME
===============
R4981 should match F0911 record with F4981 record.

POTENTIAL WORKAROUNDS
=====================
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.