E1: 42: Print Pick Slips (R42520) Updates an Incorrect Extended Cost (ECST) On Split Line with Different Item Potency
(Doc ID 2748418.1)
Last updated on MAY 04, 2021
Applies to:JD Edwards EnterpriseOne Sales Order Management - Version 9.2 and later
Information in this document applies to any platform.
When processing the Pick Slips (R42520) report, the system is not correctly seeking the potency value in F4108 table, to use it for the calculation of the total cost of the split line (F4211.ESCT).
The issue can be reproduced at will with the following steps:
- Create an item and activate potency control for it. Standard Potency is set as 45% and the potency range 40 to 50.
- Adjust Quantity for Potency Item in 2 different lots with different potency (20 LP for LOTA 42% and 10 LP for LOTB 47%).
- Create a sales order for a qty of 25 LP. The extended cost (F4211.ECST) is calculated as per Standard Potency as 45%, which is correct as no lot was populated on the line at this point.
- Run Print Pick Slips R42520 to hard commit the inventory. The SO line will split for the 2 lots: LOTA and LOTB.
For LOTA (potency 42%):
ECST=Cost (10)*Qty 21.4286/Potency Percentage(0.42)=214.286/0.42 =510.20 which was correctly calculated.
For LOTB (potency 47%):
ECST=Cost(10)*Qty 3.5715/Potency Percentage (0.47) =35.715/0.47 =75.99
The 75.99 value was expected on the LOTB line. But the system calculated the total cost based on the standard potency rather than the lot potency, as the incorrect calculation below:
ECST=Cost(10)*Qty 3.5715/Std Potency Percentage(0.45)=35.715/0.45=79.37
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