Item Cost is not getting Calculated by Transaction UOM
(Doc ID 2065094.1)
Last updated on AUGUST 11, 2022
Applies to:
Oracle Inventory Management - Version 12.2.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.3 version, Inventory Transactions
ACTUAL BEHAVIOR
---------------
Item cost is not getting by Transaction_uom as expected.
When doing a transaction for an item in PKT where as the primary UOM is EACH ( 1 PKT=1000 EACH) using the Process Transaction Interface to import the transaction with the quantity and unit price inserted in transaction UOM only. The average cost is calculated by the system in the primary UOM instead of the Transaction uom.
For example:
17 PKT 123.75 17000 EACH
100 PKT 123.75 100000 EACH
40 PKT 123.75 40000 EACH
When transacting 17 PKT where the cost of each PKT is 123.75 QAR. The system is taking the valuation of each item as 123.75 QAR. So pricing is showing (17*1000*123.75).
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 |