0012087: IDL to support import of product vendors

Description

IDL could support the import of product vendors, that is, allow records to be imported in Purchasing sub-tab (M_Product_PO table) of Product tab (M_Product table).

Steps To Reproduce

Steps that describe the current behaviour without IDL, using the old Openbravo ERP importing capabilities (see Openbravo ERP issue 0011988):
* Create a product to import in Master Data Management || Import Data || Import Products:
** Search Key = npa
** Name = New Product A
** Business Partner = McGiver Supplies (select a vendor/provider)
* Click on Import Products button: product is imported successfully.
* Navigate to Product tab in Master Data Management || Product
* Look for New Product A
* Navigate to Purchasing tab: record has been created for McGiver Supplies (one could also expect that this record appears in Business Partner field of Product tab, not in Purchasing window).
* Taking into account the current behavior, create a second product to import in Master Data Management || Import Data || Import Products:
** Search Key = npb
** Name = New Product B
** Business Partner = McGiver Supplies (select a vendor/provider)
* Create a second record for the same product but select a different business partner:
** Search Key = npb
** Name = New Product B
** Business Partner = Turtle Logistics (select a vendor/provider)
* Click on Import Products button: error message displays: "No products could be imported. Products not imported: 2; Product inserted: 0; Product updated: 0; ProductPO inserted: 0; ProductPO updated: 0" and in Import Error Message ="ERR=Value not unique,"

You were expecting that because you created two records with the same product search key and name but different business partner, a single record would be created in the Product window (New Product B) with two records in the Purchasing tab (McGiver Supplies and Turtle Logistics).

Proposed Solution

What we want to achieve is that when creating two products to import with the same product search key and name but different business partner, a single record would be created in the Product window (New Product) with two records in the Purchasing tab (Vendor 1 and Vendor 2).

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0011988	2.50MP11	closed	adrianromero	Openbravo ERP	If you try to import a product with multiple venders you get an error
related to	defect	0012347		closed	jonalegriaesarte	Openbravo ERP	If you try to import a product with multiple venders you get an error

Notes
(0173010) tomjones (viewer) 2024-12-05 10:02	The current system does not allow the import of product vendors effectively. The goal is to enable the import of vendor https://iogames.onl/ [^] records directly into the Purchasing sub-tab (M_Product_PO table) of the Product tab (M_Product table). Try modify the import logic to allow multiple business partners for a single product record. Then, implement checks that group vendor entries under the same product based on the search key and name, while allowing multiple entries in the Purchasing tab.

Issue History
Date Modified	Username	Field	Change
2010-01-28 14:53	rafaroda	New Issue
2010-01-28 14:53	rafaroda	Assigned To	=> rafaroda
2010-01-28 14:53	rafaroda	OBNetwork customer	=> No
2010-01-28 14:53	rafaroda	Issue generated from	0011988
2010-01-28 14:53	rafaroda	Relationship added	related to 0011988
2010-01-28 14:54	rafaroda	Project	Openbravo ERP => Modules
2010-01-28 14:55	rafaroda	Assigned To	rafaroda => mirurita
2010-01-28 14:55	rafaroda	Category	Z. Others => Initial data load
2010-01-28 14:55	rafaroda	Proposed Solution updated
2010-01-28 14:58	rafaroda	Proposed Solution updated
2010-01-28 14:58	rafaroda	Steps to Reproduce Updated
2010-03-10 12:20	rafaroda	Relationship added	related to 0012347
2010-03-10 12:21	rafaroda	Issue Monitored: rafaroda
2011-06-03 11:11	dalsasua	Assigned To	mirurita => dalsasua
2011-07-20 18:09	dalsasua	Assigned To	dalsasua => jonalegriaesarte
2024-12-05 10:02	tomjones	Note Added: 0173010