Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0052553
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2023-05-24 15:222023-06-12 12:51
ReportergorkaionView Statuspublic 
Assigned Toradhakrishnan 
PriorityhighResolutionfixedFixed in VersionPR23Q3
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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.

UP TO THIS POINT EVERYTHING IS CORRECT.

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 Filesdiff file icon cost-patch.diff [^] (2,781 bytes) 2023-06-09 12:54 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0151000)
hgbot (developer)
2023-06-12 07:22

Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/909 [^]
(0151055)
hgbot (developer)
2023-06-12 12:51

Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: e2ce6f53314474b0342dce32ab51b61e1e86da69
Author: Radhakrishnan Seeman <radhakrishnan@qualiantech.com>
Date: 12-06-2023 10:24:41
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/e2ce6f53314474b0342dce32ab51b61e1e86da69 [^]

Fixes ISSUE-52553: Missing negative correction adjustment when adjusting a previous transaction

---
M src/org/openbravo/costing/AverageCostAdjustment.java
---
(0151056)
hgbot (developer)
2023-06-12 12:51

Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/909 [^]

- 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
2023-06-09 12:53 aferraz Assigned To Triage Omni OMS => radhakrishnan
2023-06-09 12:54 aferraz File Added: cost-patch.diff
2023-06-12 07:22 hgbot Note Added: 0151000
2023-06-12 12:51 hgbot Resolution open => fixed
2023-06-12 12:51 hgbot Status new => closed
2023-06-12 12:51 hgbot Fixed in Version => PR23Q3
2023-06-12 12:51 hgbot Note Added: 0151055
2023-06-12 12:51 hgbot Note Added: 0151056


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker