E1: 49: R4981 Incorrectly flexing AAI 4920 for Inbound Load with In Route Rate

(Doc ID 2364160.1)

Last updated on FEBRUARY 21, 2018

Applies to:

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

Symptoms

********************
E1 Release: 9.2
Program ID: R4981
Tools Release: 9.2
********************

Customer creates a load for 2 Inbound shipments to 2 different destinations where the rate definition has Shipment Level Payable and Freight allocation activated and the freight charge is stored in the route.
When running R4981 Freight update and flexing AAI 4920 to adjust the business unit based on NMCU in F4215 then the Freight Payable entry is correctly split and allocated at the Item Level, but both J/E entries point to the NMCU value of the first shipment as the Business Unit.
The “IB” expense entries all point to the correct Business Units, but the “FT” Expense side for the second shipment is not.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) G1631-P16902 Enable Flex accounting for R4981
2) P40296 Set up Flex accounting for AAI 4920 to flex the business unit based on NMCU in F4215
3) Make sure AAI 4920 is set up for document FT and 2 different G/L class codes
4) Set up Rate Definition for Rate Type 3 – Stored in Route and with Shipment Level Payable ON and Freight Allocation activated
5) Set up rate schedule and route for the In Route rate and populate Inbound Freight Charge on Route
6) Set up 2 item with different G/L class
7) Enter 2 Purchase orders / Inbound shipment for 2 different Branch/Plants
8) Create standard Load and Approve and Confirm Load
9) Set up Flex accounting behind R4981 and run the UBE
10) Note the Freight Payable entry is correctly split and allocated at the Item Level, but both J/E entries point to the NMCU value of the first shipment as the Business Unit
Note that when looking into the F0911, the “IB” expense side entries all point to the correct Business Unit, but the “FT” Expense side for the second shipment is not

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms