The Perpetual Weighted Average Costs Can Get Negative when Processing a Cost Adjustment as a result of a Price Difference between the Purchase Order and the Voucher on more Item Units than Are Currently in On-Hand Stock (Doc ID 1997198.1)

Last updated on SEPTEMBER 07, 2021

Applies to:

Symptoms

The Perpetual Weighted Average Cost of an Item can get negative. This happens when 1) a cost adjustment is recorded as a result of a price difference between the Purchase Order and the Voucher on more item units than are currently in on-hand stock, and 2) the 'Cost Accounting Creation' process (CM_CSTACCTG) (navigation: Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation) is run with the 'Apply Perpetual Average Adjs' option.


Steps to replicate the issue:

1. Create a Perpetual Weighted Average Cost Item.
2. Initialize the cost by recording an Express Putaway for a quantity of 80,000 and a Cost of 0.0132 per unit.
3. Create and fully receive a Purchase Order for a quantity of 100,000 and a price of 0.132 per unit.
4. Run the 'Cost Accounting Creation' process (CM_CSTACCTG) > the Item Cost changes to 0.0792 = (0.0132*80,000 + 0.132*100,000) / (80,000+100,000)
5. Create an Express Issue to bring back the on-hand stock to 90,0000.
6. Create a Voucher for the Received quantity of 100,000 and change the Price to 0.0132 per unit.
7. Match override the Voucher, post it, run the Landed Cost Extraction process and the CM_CSTACCTG process > the Item Cost is changed to -0.0396 = (0,0792 - (0.132 - 0.0132)).

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.