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

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2023-05-24 15:222023-05-29 14:28
ReportergorkaionView Statuspublic 
Assigned ToTriage Omni OMS 
PriorityhighResolutionopenFixed 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

0052553: Missing negative correction adjustment when adjusting a previous transaction

DescriptionHaving a receipt that requires a negative stock adjustment. And that original processing already adjusted it.
When manually adjusting a previous transaction's cost the receipt cost is not updated with a newer adjustment amount so the total cost amount after that transaction is zero.
Steps To Reproduce1. Enable negative correction preference.
2. Create a new product to have a clean transaction list.
3. Set a purchase price of 1EUR and sales price of 2EUR to the new product.
4. Set a cost of 10EUR/unit to the product
5. Create a Sales Order and SHIPMENT of 100 units and process it.
6. If the selected locator does not allow overissue change its status to a one allowing it and process the shipment generating a negative stock.
7. Check it uses the manual cost (10EUR/unit) since it is an outgoing transaction
8. Create a Purchase Order and Receipt of 100 units from the same locator.
9. Note the cost generated by the receipt was 10EUR/unit as the total stock is zero so previous average cost is initially kept.
10. A negative stock adjustmetn is triggered that changes the average cost generated by the receipt to 1EUR/Unit as expected by the purchase price.
11. At this point
- the shipment is valued as 1000EUR
- the receipt is valued as 100 (original cost) + 900EUR (negative stock adjustment)
- total accumulated cost of the product is zero.
- total stock is zero.


12. Create a Manual Cost Adjustmetn on the Shipment so the cost is 100EUR (1EUR/unit).
13. Shipment new cost is 100EUR = 1000EUR (original cost) - 900 (manual adjustmetn)
14. Receipt is not adjusted.
15. Total accumulated cost is 900EUR (1000EUR receipt - 100EUR shipment)
16. Total stock is zero.

THIS IS WRONG. The receipt should have a negative stock adjusment done after the manual cost adjustment so the total accumulated cost is ZERO again.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2023-05-24 15:22 gorkaion New Issue
2023-05-24 15:22 gorkaion Assigned To => Triage Omni WMS
2023-05-24 15:22 gorkaion Modules => Core
2023-05-24 15:22 gorkaion Triggers an Emergency Pack => No
2023-05-29 14:28 vmromanos Assigned To Triage Omni WMS => Triage Omni OMS

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker