Incorrect Accounting Lines Amounts for Putaways when Changing the Item Standard Cost Prior Running the 'Cost Accounting Creation' Process (CM_CSTACCTG)
Last updated on AUGUST 04, 2016
Applies to:PeopleSoft Enterprise SCM Inventory - Version 8.8 SP1 and later
PeopleSoft Enterprise SCM Manufacturing - Version 8.8 SP1 and later
PeopleSoft Enterprise SCM Cost Management - Version 8.4 SP2 and later
Information in this document applies to any platform.
This Knowledge Document applies to Cost Management releases >= 8.8 SP1
When recording a putaway transaction for a Standard Costed Item, changing the Item Standard Cost, and then running the 'Cost Accounting Creation' process (CM_CSTACCTG) (navigation: Cost Accounting, Inventory and Mfg Accounting, Create Accounting Entries, Cost Accounting Creation), the quantity of the putaway transaction is accounted with the new Standard Cost and also taken into account by the 'Revalue Inventory and WIP' Cobol process (SFPREVAL). Why is that?
As a matter of fact, either the quantity of the putaway transaction should be accounted with the FORMER Standard Cost (and in this case this is correct that the quantity is taken into account by the SFPREVAL process) OR the quantity of the putaway transaction should be accounted with the the NEW Standard Cost (and in this case the quantity should NOT be taken into account by the SFPREVAL process).
Steps to reproduce the issue:
- Create a Purchased Standard Costed Item (Current Purchase Cost = 4)).
- Calculate the Item Standard Cost = 4.
- Create an Express Putaway for a quantity of 2.
- Run the Costing process > accounting lines are generated for the putaway (Transaction Group 020) with an amount of 8.
- Create a new Express Putaway for a quantity of 3.
- Change the Item Current Purchase Cost to 5.
- Calculate the new Item Standard Cost = 5.
- Run the Costing process:
> Accounting Lines are generated for the putaway (Transaction Group 020) with an amount of 15 = quantity of 3 * new Standard Cost of 5
> Accounting Lines are generated for the Inventory Revalue (Transaction Group 200) with an amount of 5 = (quantity of 3 + quantity of 2) * (new Standard Cost of 5 - old Standard Cost of 4)
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