Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023161Openbravo ERP05. Production managementpublic2013-02-26 12:082013-03-02 05:48
ReporterVictorVillar 
Assigned Topramakrishnan 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP21Fixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023161: Not possible to create standards for product not stockables
DescriptionNot possible to create standards for product not stockables.
The process is looking for a m_locator_id in the product header but it should be looking for it in the Manufacturing tab.

The database process ma_productionrun_standard is taking into account the m_locator_id of the Product header instead of the m_locator_id of the manufacturing Plan tab. Please see ma_productionrun_standard 269 line:

SELECT wrpp.*, p.IsStocked, pp.AD_Client_ID AS Client_ID, pp.AD_Org_ID AS Org_ID,
          p.M_LOCATOR_ID, pp.M_PRODUCTION_ID, p.Name as pname
        FROM MA_WRPhaseProduct wrpp, M_Product p, M_ProductionPlan pp
        WHERE pp.M_PRODUCTIONPLAN_ID=v_Record_ID
          AND pp.MA_WRPHASE_ID=wrpp.MA_WRPHASE_ID
          AND p.M_PRODUCT_ID=wrpp.M_PRODUCT_ID
          AND wrpp.PRODUCTIONTYPE='-'
Steps To ReproduceAs group admin role,
Go to product window,
  select Cerveza as Production and not stockable.
  select Vino as production.

defined the manufacturing plan for both.

Go to Production Plan
  Create a new one for España Org., sequence valid for today
  Product lines:
      P+ Vino
      P- Cerveza
Go to Work requirement window,
 select the Production Plan created before.
 Process the WR
 Create the work effort

Go to Work Effort window
  and select the work effort created before.
  Create standards.

Realise that you can not do it because the following error:
"It is needed to define a locator for: Cerveza"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0023610 closed dmiguelez Create standards process does not explode all, under some circunstancies 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-26 12:08VictorVillarNew Issue
2013-02-26 12:08VictorVillarAssigned To => dmiguelez
2013-02-26 12:08VictorVillarModules => Core
2013-02-26 12:08VictorVillarResolution time => 1362956400
2013-02-26 12:08VictorVillarTriggers an Emergency Pack => No
2013-02-27 18:34VictorVillarIssue Monitored: networkb
2013-02-28 10:18pramakrishnanAssigned Todmiguelez => pramakrishnan
2013-02-28 10:19pramakrishnanStatusnew => scheduled
2013-02-28 10:19pramakrishnanfix_in_branch => pi
2013-02-28 14:09pramakrishnanNote Added: 0056838
2013-02-28 14:10pramakrishnanNote Edited: 0056838bug_revision_view_page.php?bugnote_id=0056838#r4460
2013-03-01 11:01hgbotCheckin
2013-03-01 11:01hgbotNote Added: 0056881
2013-03-01 11:01hgbotStatusscheduled => resolved
2013-03-01 11:01hgbotResolutionopen => fixed
2013-03-01 11:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3214d21d05a942217a74f157b68812d90f277e68 [^]
2013-03-01 11:03SandrahuguetReview Assigned To => Sandrahuguet
2013-03-01 11:03SandrahuguetNote Added: 0056882
2013-03-01 11:03SandrahuguetStatusresolved => closed
2013-03-02 05:48hudsonbotCheckin
2013-03-02 05:48hudsonbotNote Added: 0056940
2013-04-22 18:43VictorVillarRelationship addedblocks 0023610

Notes
(0056838)
pramakrishnan   
2013-02-28 14:09   
(edited on: 2013-02-28 14:10)
Test Plan:
Login as Openbravo/openbravo
 Go to product window,
   select Cerveza as Production and not stockable.
   select Vino as production.
   Configure the storage bin for the above products in the manufacturing tab
 
Go to Process Plan
   Create a new record for the organization F&B España
   Version:
     Starting Date: 28.02.2013
     Ending Date: 28.02.2013

   I/O Products:
     Product:Cerveza Ale 0,5L
     Production Type:Product use (P-)

     Product:Vino Tinto 0,75L
     Production Type:Product Production (P+)

Go to Work requirement window,
  select the Production Plan created before.
  Process the WR
  Create the work effort
 
Go to Work Effort window
   select the work effort created before.
   Go to Production Plan tab and run Create standards Process
 
Notice that the process completes without error
(0056881)
hgbot   
2013-03-01 11:01   
Repository: erp/devel/pi
Changeset: 3214d21d05a942217a74f157b68812d90f277e68
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Thu Feb 28 18:41:20 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/3214d21d05a942217a74f157b68812d90f277e68 [^]

Fixes Issue 23161: Not possible to create standards for product not stockables

---
M src-db/database/model/functions/MA_PRODUCTIONRUN_STANDARD.xml
---
(0056882)
Sandrahuguet   
2013-03-01 11:03   
Code review + testing OK
(0056940)
hudsonbot   
2013-03-02 05:48   
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/f5db629e7058 [^]

Maturity status: Test