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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023161
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementmajoralways2013-02-26 12:082013-03-02 05:48
ReporterVictorVillarView Statuspublic 
Assigned Topramakrishnan 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision3214d21d05a9
ProjectionnoneETAnoneTarget Version3.0MP21
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket19400
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023161: 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"
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0023610 closeddmiguelez Create standards process does not explode all, under some circunstancies 

-  Notes
(0056838)
pramakrishnan (viewer)
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 (developer)
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 (viewer)
2013-03-01 11:03

 Code review + testing OK
(0056940)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2013-02-26 12:08 VictorVillar New Issue
2013-02-26 12:08 VictorVillar Assigned To => dmiguelez
2013-02-26 12:08 VictorVillar Modules => Core
2013-02-26 12:08 VictorVillar OBNetwork customer => Yes
2013-02-26 12:08 VictorVillar Support ticket => 19400
2013-02-26 12:08 VictorVillar Resolution time => 1362956400
2013-02-26 12:08 VictorVillar Triggers an Emergency Pack => No
2013-02-27 18:34 VictorVillar Issue Monitored: networkb
2013-02-28 10:18 pramakrishnan Assigned To dmiguelez => pramakrishnan
2013-02-28 10:19 pramakrishnan Status new => scheduled
2013-02-28 10:19 pramakrishnan fix_in_branch => pi
2013-02-28 14:09 pramakrishnan Note Added: 0056838
2013-02-28 14:10 pramakrishnan Note Edited: 0056838 View Revisions
2013-03-01 11:01 hgbot Checkin
2013-03-01 11:01 hgbot Note Added: 0056881
2013-03-01 11:01 hgbot Status scheduled => resolved
2013-03-01 11:01 hgbot Resolution open => fixed
2013-03-01 11:01 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3214d21d05a942217a74f157b68812d90f277e68 [^]
2013-03-01 11:03 Sandrahuguet Review Assigned To => Sandrahuguet
2013-03-01 11:03 Sandrahuguet Note Added: 0056882
2013-03-01 11:03 Sandrahuguet Status resolved => closed
2013-03-02 05:48 hudsonbot Checkin
2013-03-02 05:48 hudsonbot Note Added: 0056940
2013-04-22 18:43 VictorVillar Relationship added blocks 0023610

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker