Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0024405Openbravo ERP04. Warehouse managementpublic2013-07-23 19:002014-03-05 16:09
ReporterVictorVillar 
Assigned Todmiguelez 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToVictorVillar
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0024405: It is not possible to calculate warehouse transactions under some circunstancies
DescriptionIt is not possible to calculate warehouse transactions under some circunstancies, using FIFO and if you have the early 1022 as outgoing transactions
Steps To ReproduceIf you have the early 1022 as outgoing transactions and after them 2 incoming transactions (allowing negative stock) and if you are using FIFO algorithm, there is a problem with the cost calculation.
The incoming transactions will be never in the input stack table.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on design defect 0023701 new dmiguelez 'Allow negative stock' is not fully supported in Openbravo 
related to defect 0025888 closed dmiguelez UpdateMTransactionCostingStatus script fails 
related to defect 0026030 closed alostale OOM Error in Oracle due to prepared statements 
causes defect 0031979 closed aferraz Costing Migration Process: processed column of m_transaction table is not set as Y for records with its cost calculated 
Not all the children of this issue are yet resolved or closed.
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-07-23 19:00VictorVillarNew Issue
2013-07-23 19:00VictorVillarAssigned To => dmiguelez
2013-07-23 19:00VictorVillarModules => Core
2013-07-23 19:00VictorVillarTriggers an Emergency Pack => No
2013-07-23 19:00VictorVillarIssue Monitored: networkb
2013-07-24 09:41VictorVillarRelationship addeddepends on 0023701
2013-07-24 10:43VictorVillarTypedefect => design defect
2013-07-24 10:43VictorVillarProposed Solution updated
2013-08-26 11:46jonalegriaesarteTarget Version3.0MP27 =>
2014-03-03 11:08hgbotCheckin
2014-03-03 11:08hgbotNote Added: 0064716
2014-03-03 11:08hgbotStatusnew => resolved
2014-03-03 11:08hgbotResolutionopen => fixed
2014-03-03 11:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/8845de885b879c0f2b58210ed144196a315969ac [^]
2014-03-03 12:44VictorVillarReview Assigned To => VictorVillar
2014-03-03 12:44VictorVillarNote Added: 0064727
2014-03-03 12:44VictorVillarStatusresolved => closed
2014-03-03 18:55hgbotCheckin
2014-03-03 18:55hgbotNote Added: 0064770
2014-03-04 08:08alostaleRelationship addedrelated to 0025888
2014-03-04 09:27hgbotCheckin
2014-03-04 09:27hgbotNote Added: 0064780
2014-03-05 16:09hudsonbotCheckin
2014-03-05 16:09hudsonbotNote Added: 0064834
2014-03-05 16:09hudsonbotCheckin
2014-03-05 16:09hudsonbotNote Added: 0064839
2014-03-05 16:09hudsonbotCheckin
2014-03-05 16:09hudsonbotNote Added: 0064843
2014-03-18 15:48alostaleRelationship addedrelated to 0026030
2016-01-25 13:21aferrazRelationship addedcauses 0031979

Notes
(0064716)
hgbot   
2014-03-03 11:08   
Repository: erp/devel/pi
Changeset: 8845de885b879c0f2b58210ed144196a315969ac
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Mar 03 11:06:05 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/8845de885b879c0f2b58210ed144196a315969ac [^]

Fixes Issue 24405. Fixes problem with more than 1000 Pending Trx.

---
M src-db/database/model/tables/M_TRANSACTION.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_ELEMENT.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateMTransactionCostingStatus.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateMTransactionCostingStatus.java
M src/org/openbravo/costing/CostingBackground.java
---
(0064727)
VictorVillar   
2014-03-03 12:44   
Verified
(0064770)
hgbot   
2014-03-03 18:55   
Repository: erp/devel/pi
Changeset: a7f8d171c57396ed3f35429956a6d5d0f0f9cdcf
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Mar 03 18:55:21 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a7f8d171c57396ed3f35429956a6d5d0f0f9cdcf [^]

Related to Issue 24405. Checks if needed to update in Modulescript.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateMTransactionCostingStatus.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateMTransactionCostingStatus.java
M src/org/openbravo/costing/CostingBackground.java
A src-util/modulescript/src/org/openbravo/modulescript/UpdateMTransactionCostingStatus_data.xsql
---
(0064780)
hgbot   
2014-03-04 09:27   
Repository: erp/devel/pi
Changeset: ca2e7eff07ba324c9f0a8b028845a5fa7faa596f
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Mar 04 09:26:45 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/ca2e7eff07ba324c9f0a8b028845a5fa7faa596f [^]

Related to Issue 24405. Pushes Modulescript .class updated file.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdateMTransactionCostingStatus.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdateMTransactionCostingStatus.java
---
(0064834)
hudsonbot   
2014-03-05 16:09   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d34c34b81a92 [^]
Maturity status: Test
(0064839)
hudsonbot   
2014-03-05 16:09   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d34c34b81a92 [^]
Maturity status: Test
(0064843)
hudsonbot   
2014-03-05 16:09   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/d34c34b81a92 [^]
Maturity status: Test