Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036642Openbravo ERP04. Warehouse managementpublic2017-08-11 12:552017-10-10 17:24
Reporterngarcia 
Assigned ToTriage Omni WMS 
PriorityurgentSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0036642: [Costing Migration Process] Stock valuation should be updated to 0 when the stock of the product is 0
DescriptionStock valuation should be updated to 0 when the stock of the product is 0
Steps To ReproduceAs 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-08-11 12:55ngarciaNew Issue
2017-08-11 12:55ngarciaAssigned To => Triage Finance
2017-08-11 12:55ngarciaModules => Core
2017-08-11 12:55ngarciaTriggers an Emergency Pack => No
2017-08-11 12:56ngarciaIssue Monitored: networkb
2017-08-11 13:03ngarciaNote Added: 0098490
2017-08-17 13:20ngarciaRelationship addedrelated to 0036659
2017-08-30 15:08PracticsIssue Monitored: Practics
2017-08-31 12:29ngarciaRelationship addedrelated to 0036758
2017-08-31 12:30ngarciaRelationship addeddepends on 0036757
2017-08-31 12:31ngarciaRelationship deleteddepends on 0036757
2017-09-11 18:40ngarciaRelationship addedrelated to 0036831
2017-10-10 17:24dmiguelezRelationship addedrelated to 0037046

Notes
(0098490)
ngarcia   
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