Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023069Openbravo ERP05. Production managementpublic2013-02-13 12:532013-03-05 19:09
ReporterVictorVillar 
Assigned Tojonalegriaesarte 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP21Fixed in Version3.0MP21 
Merge Request Status
Review Assigned Tojonalegriaesarte
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket19486
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023069: Not possible to create standards under some circunstancies
DescriptionNot possible to create standards under some circunstancies.

If you have a good shipment in status DRAFT with a product without attributes defined yet, and then create a work effort for the same product, and try to create standards for this product (P+) with the same qty to produce as the qty in the Shipment document, then you can not process create Standards.
Steps To ReproduceIf you have a good shipment in status DRAFT with a product without attributes defined yet, and then create a work effort for the same product, and try to create standards for this product (P+) with the same qty to produce as the qty in the Shipment document, then you can not process create Standards.
Proposed Solutionbecause the m_update_inventory removes the register in the m_storage_detail, created when you have registered the shipment line, then the m_update_stockaux function cannot find it.
The solution proposed:

add the condition in m_update_stockaux:
if (v_count <> 0 ) then

Create a register in the m_storage_detail with all the qty columns set to 0, with the same parameters (product, locator, uom...) as the register removed by the m_update_inventory.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-13 12:53VictorVillarNew Issue
2013-02-13 12:53VictorVillarAssigned To => dmiguelez
2013-02-13 12:53VictorVillarModules => Core
2013-02-13 12:53VictorVillarOBNetwork customer => Yes
2013-02-13 12:53VictorVillarSupport ticket => 19486
2013-02-13 12:53VictorVillarResolution time => 1363129200
2013-02-13 12:53VictorVillarTriggers an Emergency Pack => No
2013-02-13 12:58VictorVillarProposed Solution updated
2013-02-13 12:58VictorVillarIssue Monitored: networkb
2013-02-14 11:50naiaramartinezAssigned Todmiguelez => jonalegriaesarte
2013-02-15 10:05hgbotCheckin
2013-02-15 10:05hgbotNote Added: 0056484
2013-02-15 10:05hgbotStatusnew => resolved
2013-02-15 10:05hgbotResolutionopen => fixed
2013-02-15 10:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0413794948b0373adf3d9dbdbf573fc28e9b9ead [^]
2013-02-20 04:50hudsonbotCheckin
2013-02-20 04:50hudsonbotNote Added: 0056606
2013-03-01 02:10VictorVillarNote Added: 0056871
2013-03-05 19:09jonalegriaesarteReview Assigned To => jonalegriaesarte
2013-03-05 19:09jonalegriaesarteNote Added: 0057068
2013-03-05 19:09jonalegriaesarteStatusresolved => closed
2013-03-05 19:09jonalegriaesarteFixed in Version => 3.0MP21

Notes
(0056484)
hgbot   
2013-02-15 10:05   
Repository: erp/devel/pi
Changeset: 0413794948b0373adf3d9dbdbf573fc28e9b9ead
Author: Victor Villar <victor.villar <at> openbravo.com>
Date: Thu Feb 14 09:42:19 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0413794948b0373adf3d9dbdbf573fc28e9b9ead [^]

Fixes issue 23069: Not possible to create standards under some circunstancies

---
M src-db/database/model/functions/M_UPDATE_STOCKAUX.xml
---
(0056606)
hudsonbot   
2013-02-20 04:50   
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/d828167a9e83 [^]

Maturity status: Test
(0056871)
VictorVillar   
2013-03-01 02:10   
TEST PLAN:
Create a new product:
  Production: YEs

If you have a good shipment in status DRAFT with the product created before without attributes defined yet, and then create a work effort for the same product, and try to create standards for this product (P+) with the same qty to produce as the qty in the Shipment document, then you can not process create Standards.
(0057068)
jonalegriaesarte   
2013-03-05 19:09   
Closed