0036642: [Costing Migration Process] Stock valuation should be updated to 0 when the stock of the product is 0

Description

Stock valuation should be updated to 0 when the stock of the product is 0

Steps To Reproduce

As group admin role:
   Having an environment that is not migrated to the new costing engine and a product without stock but with a valuation different from 0 (transactions cost should be calculated with the old engine). For example:
      Stock: 0
      Valuation: 844

   Validate a new costing rule without starting date
   Check the product is not included in the closing and opening inventories as it does not have stock
   Create a purchase order for that product with a price of 44
   Create a goods receipt from it
   Launch the costing background process
   Check the new average cost is calculated as 44
   Create a goods shipment with that product to leave the stock to 0
   Check the transaction cost is calculated as -44
   Create a purchase order for that product with a price of 44
   Create a goods receipt from it
   Launch the costing background process
   Check the new average cost is calculated as 888
   Create a goods shipment with that product to leave the stock to 0
   Check the transaction cost is calculated as -888

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	design defect	0036758	new	Triage Omni WMS	After validating a costing rule with warehouse dimension, remaining stock valuation could exist on each warehouse but not global
related to	design defect	0037046	new	Triage Omni OMS	Known Issues related to Costing Functionality
related to	defect	0036659	closed	markmm82	[Costing Migration Process]: Closing inventories are not leaving stock valuation to 0
related to	defect	0036831	closed	AtulOpenbravo	Wrong average cost after negative stock correction: Total Stock Valuation of Costing tab is not updated

Notes
(0098490) ngarcia (viewer) 2017-08-11 13:03	In order to adjust the current average cost we could do the following: - Launch a Manual Cost Adjustment to the first entry after the costing rule was validated. Thus, the first transaction that increases the stock (Product - Transactions tab) - The Adjustment should be: * Total Cost Amount: difference between the required transaction cost (that's is, the stock valuation we should have after the stock increase) and the current valuation * Accounting Date: select one, it could be the movement date of the first stock increase after the validation * Incremental: Y * Unit Cost: N

Issue History
Date Modified	Username	Field	Change
2017-08-11 12:55	ngarcia	New Issue
2017-08-11 12:55	ngarcia	Assigned To	=> Triage Finance
2017-08-11 12:55	ngarcia	OBNetwork customer	=> Yes
2017-08-11 12:55	ngarcia	Modules	=> Core
2017-08-11 12:55	ngarcia	Support ticket	=> 47445
2017-08-11 12:55	ngarcia	Triggers an Emergency Pack	=> No
2017-08-11 12:56	ngarcia	Issue Monitored: networkb
2017-08-11 13:03	ngarcia	Note Added: 0098490
2017-08-17 13:20	ngarcia	Relationship added	related to 0036659
2017-08-30 15:08	Practics	Issue Monitored: Practics
2017-08-31 12:29	ngarcia	Relationship added	related to 0036758
2017-08-31 12:30	ngarcia	Relationship added	depends on 0036757
2017-08-31 12:31	ngarcia	Relationship deleted	depends on 0036757
2017-09-11 18:40	ngarcia	Relationship added	related to 0036831
2017-10-10 17:24	dmiguelez	Relationship added	related to 0037046