Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012087ModulesInitial data loadpublic2010-01-28 14:532024-12-05 10:02
Reporterrafaroda 
Assigned Tojonalegriaesarte 
PriorityurgentSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customerNo
Regression introduced in release
Summary0012087: IDL to support import of product vendors
DescriptionIDL 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 ReproduceSteps 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 SolutionWhat 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).
Additional Information
TagsNo tags attached.
Relationships
related to defect 00119882.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 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-01-28 14:53rafarodaNew Issue
2010-01-28 14:53rafarodaAssigned To => rafaroda
2010-01-28 14:53rafarodaOBNetwork customer => No
2010-01-28 14:53rafarodaIssue generated from0011988
2010-01-28 14:53rafarodaRelationship addedrelated to 0011988
2010-01-28 14:54rafarodaProjectOpenbravo ERP => Modules
2010-01-28 14:55rafarodaAssigned Torafaroda => mirurita
2010-01-28 14:55rafarodaCategoryZ. Others => Initial data load
2010-01-28 14:55rafarodaProposed Solution updated
2010-01-28 14:58rafarodaProposed Solution updated
2010-01-28 14:58rafarodaSteps to Reproduce Updated
2010-03-10 12:20rafarodaRelationship addedrelated to 0012347
2010-03-10 12:21rafarodaIssue Monitored: rafaroda
2011-06-03 11:11dalsasuaAssigned Tomirurita => dalsasua
2011-07-20 18:09dalsasuaAssigned Todalsasua => jonalegriaesarte
2024-12-05 10:02tomjonesNote Added: 0173010

Notes
(0173010)
tomjones   
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.