Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007890Openbravo ERP02. Master data managementpublic2009-03-02 08:072010-03-10 18:28
Reporterrafaroda 
Assigned Topjuvara 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Version2.40 
Target VersionFixed in Version2.50 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007890: Review import products with prices functionality
DescriptionImport of products with prices is not working properly in 2.40 nor in trunk.
Steps To Reproduce1) Go to 'Master Data Management || Import Data || Import Products' and create a new record.
2) Fill the following fields:
* Search Key
* Name
* Business Partner
* List Price
* Purchase Order Price
3) Save and click 'Import Products' button.

Execute the following selects:
* select * from m_product_po order by updated desc;
A new record has been inserted in M_Product_Po table, which is never used in Openbravo ERP.
* select * from m_productprice order by updated desc;
No records inserted in M_ProductPrice table, which is the one used in Openbravo ERP.

Proposed SolutionNow, List Price and Purchase Order Price are inserted inside M_Product_PO table, inherited from Compiere and never used in Openbravo ERP.

The proposed solution is to be able to import the following product prices, both for purchase and sales:
* List Price
* Standard Price
* Price Limit
These values should be inserted in M_ProductPrice table, with their corresponding Product Price Version.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0007885 closed Dowid Cannot Import products, gives a m_product_po_id NOT NULL Contraint Error 
blocks feature request 0004117 closed pjuvara Data import improvements 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-03-02 08:07rafarodaNew Issue
2009-03-02 08:07rafarodaAssigned To => pjuvara
2009-03-02 08:07rafarodaOBNetwork customer => No
2009-03-02 08:07rafarodaRegression testing => No
2009-03-02 08:09rafarodaNote Added: 0014194
2009-03-02 08:09rafarodaStatusnew => acknowledged
2009-03-02 10:03rafarodaRelationship addedrelated to 0007885
2009-03-02 16:28pjuvaraRelationship addedblocks 0004117
2010-03-08 15:51pjuvaraStatusacknowledged => scheduled
2010-03-08 15:51pjuvarafix_in_branch => pi
2010-03-08 15:52pjuvaraNote Added: 0025134
2010-03-08 15:52pjuvaraStatusscheduled => resolved
2010-03-08 15:52pjuvaraFixed in SCM revision => NA
2010-03-08 15:52pjuvaraResolutionopen => fixed
2010-03-08 15:52pjuvaraStatusresolved => closed
2010-03-08 15:52pjuvaraFixed in Version => 2.50
2010-03-10 17:19anonymoussf_bug_id0 =>
2010-03-10 18:28anonymoussf_bug_id => 2967921

Notes
(0014194)
rafaroda   
2009-03-02 08:09   
Related links:
* http://wiki.openbravo.com/wiki/Technical_FAQ_about_Openbravo_ERP#What_are_features_of_Openbravo_ERP_that_are_not_fully_implemented.3F [^]
* https://sourceforge.net/forum/forum.php?thread_id=3017035&forum_id=650010 [^]
* https://sourceforge.net/forum/forum.php?thread_id=3049859&forum_id=808030 [^]
* https://issues.openbravo.com/view.php?id=7885 [^]
(0025134)
pjuvara   
2010-03-08 15:52   
Released as part of Initial Data Load