E1: 49: G/L Amount Generated By Freight Update Different Than Freight Accrued Amount
(Doc ID 2451829.1)
Last updated on MARCH 01, 2022
Applies to:
JD Edwards EnterpriseOne Transportation Management - Version 9.0 and laterInformation in this document applies to any platform.
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
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 |