Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0052553 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 04. Warehouse management | major | always | 2023-05-24 15:22 | 2023-06-12 12:51 | |||
Reporter | gorkaion | View Status | public | |||||
Assigned To | radhakrishnan | |||||||
Priority | high | Resolution | fixed | Fixed in Version | PR23Q3 | |||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0052553: Missing negative correction adjustment when adjusting a previous transaction | |||||||
Description | Having 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 Reproduce | 1. 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | 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 |