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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0058052
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2025-02-21 14:482025-03-20 14:44
ReportermalsasuaView Statuspublic 
Assigned ToSandrahuguet 
PriorityhighResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomtaal
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0058052: Wrong cost amount with backdated transactions

DescriptionWith"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 [^]
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0058297 newTriage Omni WMS Modules MovementDate should be truncate 

-  Notes
(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


- Issue History
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
Powered by Mantis Bugtracker