Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000546Openbravo ERPJ. Demo datapublic2008-06-04 13:082009-04-24 00:00
gorkaion 
AinhoaPagola 
normalminorN/A
closedfixed 
5
2.40 
2.40 
Core
No
0000546: Produced products in demo data are checked as purchased
In the demo data are products that are produced checked as purchased. See Wine Albany as example.

This can cause problems in the MRP module as the Manufacturing Plan will suggest material requisitions instead of work requirements.
All the products of Finished Products Wine category should not be checked as Purchased.
commsup_sprint6, main
Issue History
2008-06-04 13:08gorkaionNew Issue
2008-06-04 13:08gorkaionAssigned To => cromero
2008-06-09 11:52psarobeStatusnew => scheduled
2008-06-09 11:52psarobeAssigned Tocromero => rafaroda
2008-06-13 19:59cromeroTarget Version => 2.40
2008-10-17 11:24rafarodaNote Added: 0009621
2008-11-13 21:49rafarodaAssigned Torafaroda => gorkaion
2008-12-09 12:39gorkaionNote Added: 0011061
2008-12-09 12:42gorkaionAssigned Togorkaion => AinhoaPagola
2009-01-19 10:24rafarodaversion => 2.40
2009-02-13 12:05AinhoaPagolaTag Attached: demo-data
2009-02-13 12:15AinhoaPagolaTag Detached: demo-data
2009-02-19 13:12AinhoaPagolaStatusscheduled => resolved
2009-02-19 13:12AinhoaPagolasvn_revision => 2
2009-02-19 13:12AinhoaPagolaResolutionopen => fixed
2009-02-19 13:12AinhoaPagolaNote Added: 0013736
2009-02-20 09:34PavelPonomarevTag Attached: commsup_sprint6
2009-03-05 12:40rafarodaNote Deleted: 0009621
2009-04-22 11:24psarobeTag Attached: main
2009-04-23 19:37psarobeRegression testing => No
2009-04-23 19:37psarobeStatusresolved => closed
2009-04-24 00:00anonymoussf_bug_id0 => 2779915

Notes
(0011061)
gorkaion   
2008-12-09 12:39   
This query should be executed on that branch:

UPDATE M_PRODUCT
SET isPurchased = 'N'
WHERE M_Product_Category_ID = 'xxxx' --> use the ID of 'Finished Products Wine' category
(0013736)
AinhoaPagola   
2009-02-19 13:12   
The demo-data is actually in https://dev.openbravo.com/websvn/sampledata-erp. [^]

It has been updated with the query provided by Gorkaion.