Item Cost is not getting Calculated by Transaction UOM
Last updated on MARCH 08, 2017
Applies to:Oracle Inventory Management - Version 12.2.3 and later
Information in this document applies to any platform.
On : 12.2.3 version, Inventory Transactions
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.
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).
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