Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 04. Warehouse managementmajoralways2017-08-31 12:252018-02-22 21:57
ReporterngarciaView Statuspublic 
Assigned ToTriage Omni WMS 
PriorityurgentResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0036758: After validating a costing rule with warehouse dimension, remaining stock valuation could exist on each warehouse but not global

DescriptionAfter validating a costing rule with warehouse dimension, remaining stock valuation could exist on each warehouse but not global

Currently, if you validate a costing rule with warehouse dimension having a warehouse rule already validated without warehouse dimension, the negative stock correction is made only over the transaction related with last closing inventory line (in order to leave stock 0 valuation 0), but the valuation on each warehouse could not be 0 in that moment, causing average cost to be modified when calculating the cost of transactions related with opening inventories
Steps To ReproduceAs group admin role:
   Having a product with stock in different warehouses and a current average cost different from the current cost of costing tab (in order to have a remaining value after closing inventories)
   Having a costing rule already validated with Warehouse Dimension = 'N'

   Go to Costing Rule window and validate a new rule for the same organization but with Warehouse Dimension = 'Y'

   Check one Negative Stock Correction is done for that product but check after closing inventory lines the stock valuation could be different from 0 on each warehouse
Proposed SolutionNegative Stock Correction adjustments created to adjust closing inventories with a remainder value should be always launched with warehouse dimension enabled, although costing rule doesn't have it enabled.

Closing inventories are only created from Costing Rule validation process and Inventory Amount Update process.

Attached a possible fix that should be properly reviewed and tested.
TagsNo tags attached.
Attached Filesdiff file icon 36758.diff [^] (2,300 bytes) 2017-09-11 12:00 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0035330 closedcollazoandy4 [Negative Stock Correction]: Warehouse is not taken into account to check if stock was negative previous to an stock increase 
related to design defect 0037046 newTriage Omni OMS Known Issues related to Costing Functionality 
depends on defect 0036757 closedAtulOpenbravo Negative Stock Correction for remaining stock valuation not done in closing inventory lines (when validating a costing rule) 
related to design defect 0036642 newTriage Omni WMS [Costing Migration Process] Stock valuation should be updated to 0 when the stock of the product is 0 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2017-08-31 12:25 ngarcia New Issue
2017-08-31 12:25 ngarcia Assigned To => Triage Finance
2017-08-31 12:25 ngarcia Modules => Core
2017-08-31 12:25 ngarcia Triggers an Emergency Pack => No
2017-08-31 12:29 ngarcia Relationship added related to 0036642
2017-08-31 12:31 ngarcia Relationship added depends on 0036757
2017-08-31 13:27 ngarcia Steps to Reproduce Updated View Revisions
2017-09-06 14:08 aferraz Proposed Solution updated
2017-09-08 14:48 aferraz Relationship added related to 0035330
2017-09-11 12:00 aferraz File Added: 36758.diff
2017-09-11 12:04 aferraz Proposed Solution updated
2017-10-10 17:24 dmiguelez Relationship added related to 0037046
2018-02-22 21:57 Practics Issue Monitored: Practics

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker