Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0058052 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Openbravo ERP] 04. Warehouse management | major | always | 2025-02-21 14:48 | 2025-03-20 14:44 | |||||||
Reporter | malsasua | View Status | public | |||||||||
Assigned To | Sandrahuguet | |||||||||||
Priority | high | Resolution | open | Fixed in Version | ||||||||
Status | new | 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 | mtaal | |||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0058052: Wrong cost amount with backdated transactions | |||||||||||
Description | With"backdated transactions" feature enabled, the query that calculates the accumulated stock does not take this feature into account and does not sort by "transaction date" first. This results in incorrect accumulated stock on days when backdated transactions are processed. | |||||||||||
Steps To Reproduce | . backdated transactions enabled . trx1 - trxProcessDate 20/05/2024 07:00:00 - movementdate 19/05/2024 - qty +3 . trx3 - trxProcessDate 20/05/2024 07:30:00 - movementdate 19/05/2024 - qty +4 . trx2 - trxProcessDate 20/05/2024 07:15:00 - movementdate 20/05/2024 - qty -3 the trx2 is processed after trx1 - reducing the stock the trx3 is processed after trx2, but with date 19/05/2025 , butg in this moment, the acumulated stock should not take the trx2 More detail in https://docs.google.com/document/d/1j17OLSgMQs3lzpXTvlwoCSrC_zD2joCa8wOmfAkxjZc/edit?usp=sharing [^] | |||||||||||
Tags | No tags attached. | |||||||||||
Attached Files | ||||||||||||
![]() |
|||||||||
|
![]() |
|
(0176203) mtaal (manager) 2025-02-27 10:23 |
We discussed internally and backdated transactions are not supported with the accumulated stock. This was stated from the start of the development. To support backdating the accumulated stock has to be removed and recomputed from the backdated date. |
(0176787) egoitz (developer) 2025-03-13 12:22 |
Ticket reopened after internall discussion |
(0177029) hgbot (developer) 2025-03-20 14:11 |
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1601 [^] |
(0177030) Sandrahuguet (developer) 2025-03-20 14:44 edited on: 2025-03-21 12:31 |
Test Plan: In F&B Client -Go to Costing Rule and activate backdated transactions (Fix backdated transactions button) -Go to product tab and create a new product add a price in be soft drinker price list and in general sales price list. Add a costing date today -Create a physical inventory for this product qty 100 and date today -Create a goods shipment date today and product created in previous step -Create a goods receipt date today and product created in previous step -Create a goods receipt date tomorrow and product created in previous step -Create a goods shipment date tomorrow and product created in previous step (in the database update the movementdate associated to this transaction with any hour,min,sec) -Create a goods receipt date tomorow and product created in previous step -Create a goods receipt date the day after tomorrow and product created in previous step -Launch the costing background Check that the real accumulated stock is correct |
![]() |
|||
Date Modified | Username | Field | Change |
2025-02-21 14:48 | malsasua | New Issue | |
2025-02-21 14:48 | malsasua | Assigned To | => Triage Omni WMS |
2025-02-21 14:48 | malsasua | Modules | => Core |
2025-02-21 14:48 | malsasua | Triggers an Emergency Pack | => No |
2025-02-21 16:44 | Practics | Issue Monitored: Practics | |
2025-02-27 10:23 | mtaal | Review Assigned To | => mtaal |
2025-02-27 10:23 | mtaal | Note Added: 0176203 | |
2025-02-27 10:23 | mtaal | Status | new => closed |
2025-03-13 12:22 | egoitz | Note Added: 0176787 | |
2025-03-13 12:22 | egoitz | Status | closed => new |
2025-03-19 19:20 | aferraz | Assigned To | Triage Omni WMS => Sandrahuguet |
2025-03-20 14:04 | Sandrahuguet | Relationship added | related to 0058297 |
2025-03-20 14:11 | hgbot | Note Added: 0177029 | |
2025-03-20 14:44 | Sandrahuguet | Note Added: 0177030 | |
2025-03-21 12:30 | Sandrahuguet | Note Edited: 0177030 | View Revisions |
2025-03-21 12:31 | Sandrahuguet | Note Edited: 0177030 | View Revisions |
Copyright © 2000 - 2009 MantisBT Group |