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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0045186
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 04. Warehouse managementmajoralways2020-10-05 10:332020-10-09 10:47
ReportergorkaionView Statuspublic 
Assigned Toinigo_lerga 
PriorityhighResolutionopenFixed in Version
StatusscheduledFix 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

0045186: Wrong cum stock and cum valuation on backdated transaction costs

DescriptionWhen a backdated transaction is adjusted but it does not modify its average cost the cumulated values are not reset.

This causes wrong average cost calculations on following transactions as they use wrong cumulated values.
Steps To ReproduceGo to Costing Rules and enabled backdated transactions since 01-01-2020
Go to Product and create a new product TEST in F&B España.
On the price tab add a new price on Tarifa Bebidas Alegres of 1EUR.

All documents on F&B España - Region Norte:
1 Create a Physical Inventory with Movement Date 18-09-2020. Qty 100 Storage Bin RN-2-0-0
2 Create a Physical Inventory with Movement Date 18-09-2020. Qty 150 Storage Bin RN-2-0-0
3 Create a Goods Movement with Movement Date 19-09-2020. Qty 20 Storage Bin RN-2-0-0 to RN-1-0-0
4 Create a Goods Movement with Movement Date 19-09-2020. Qty 30 Storage Bin RN-2-0-0 to RN-1-0-0
5 Create a Physical Inventory with Movement Date 18-09-2020. Qty 80 Storage Bin RN-1-0-0
6 Create a Goods Movement with Movement Date 19-09-2020. Qty 60 Storage Bin RN-1-0-0 to RN-2-0-0
7 Create a Physical Inventory with Movement Date 18-09-2020. Qty 200 Storage Bin RN-2-0-0
8 Create a Physical Inventory with Movement Date 18-09-2020. Qty 230 Storage Bin RN-2-0-0
9 Create a Physical Inventory with Movement Date TODAY+1. Qty 70. Storage Bin RN-1-0-0

Schedule to run immediately the Costing Background process to ensure that all transactions are calculated.

Go to the Costing Tab of the Product and refresh it in case there are not costs yet.
Note that the last Average Cost has wrong Total Movement Quantity and Total Stock Valuation fields. It is showing 400 when the expected value is 300.
Proposed SolutionIt needs to be reviewed if following methods are returning good values:

1. AverageAlgorithm.getLastCumulatedCosting() is returning the correct average cost.
In the proposed steps to reproduce example it should return the inventory of step 8.

2. CostingUtils.getCurrentStock() and CostingUtils.getCurrentValuedStock() are returning the correct values.
If inventory of step 8 is returned it should only sum the goods movements transactions of 19-09-2020 and return a value of 250 in both cases. It seems that these methods are returning 350.
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
2020-10-05 10:33 gorkaion New Issue
2020-10-05 10:33 gorkaion Assigned To => Triage Finance
2020-10-05 10:33 gorkaion Modules => Core
2020-10-05 10:33 gorkaion Triggers an Emergency Pack => No
2020-10-05 12:28 inigo_lerga Status new => scheduled
2020-10-09 10:47 dmiguelez Assigned To Triage Finance => inigo_lerga


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker