0007890: Review import products with prices functionality

Description

Import of products with prices is not working properly in 2.40 nor in trunk.

Steps To Reproduce

1) 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 Solution

Now, 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.

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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

Notes
(0014194) rafaroda (developer) 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 (reporter) 2010-03-08 15:52	Released as part of Initial Data Load

Issue History
Date Modified	Username	Field	Change
2009-03-02 08:07	rafaroda	New Issue
2009-03-02 08:07	rafaroda	Assigned To	=> pjuvara
2009-03-02 08:07	rafaroda	Regression testing	=> No
2009-03-02 08:09	rafaroda	Note Added: 0014194
2009-03-02 08:09	rafaroda	Status	new => acknowledged
2009-03-02 10:03	rafaroda	Relationship added	related to 0007885
2009-03-02 16:28	pjuvara	Relationship added	blocks 0004117
2010-03-08 15:51	pjuvara	Status	acknowledged => scheduled
2010-03-08 15:51	pjuvara	fix_in_branch	=> pi
2010-03-08 15:52	pjuvara	Note Added: 0025134
2010-03-08 15:52	pjuvara	Status	scheduled => resolved
2010-03-08 15:52	pjuvara	Fixed in SCM revision	=> NA
2010-03-08 15:52	pjuvara	Resolution	open => fixed
2010-03-08 15:52	pjuvara	Status	resolved => closed
2010-03-08 15:52	pjuvara	Fixed in Version	=> 2.50
2010-03-10 17:19	anonymous	sf_bug_id	0 =>
2010-03-10 18:28	anonymous	sf_bug_id	=> 2967921