Thanks Ingo! Another one please, on the same table noticed that the primary key contains ‘minimum_order_quantity’ and ‘currency_uom_id’ along with ‘product_id’, ‘party_id’, ‘available_from_date’. I can understand the addition of ‘currency_uom_id’ as different currencies for the same supplier may be used, but why ‘minimum_order’_quantity’, what would be the business case for having it part of the key?
Regards, Emad > On 9 Apr 2022, at 2:40 PM, Ingo Wolfmayr <ingo.wolfm...@wolfix.at> wrote: > > Hi Emad, > > the suppliers product and & id may differ from the ones you use. If you have > multiple suppliers for the same product they may use different names and Ids. > One production case: in default the purchase order prints those (id&name) on > the pdf and you can send the order to your suplier who may not be able to > work with your id. > > Best regards, > Ingo > > > -----Ursprüngliche Nachricht----- > Von: Emad Radwan <eradwan1...@gmail.com> > Gesendet: Freitag, 8. April 2022 22:44 > An: user@ofbiz.apache.org > Betreff: Issue With Supplier Product > > Hello Community, > > There’s something that’s not clear to me regarding the subject screen which > is the following two fields: > > Supplier Product Name > Supplier Product ID > > and the latter is even mandatory in the form! > > The ‘Add Product Supplier’ form has the ‘supplier’ in the first field is > selected from a dropdown and is being derived from parties - with supplier > role if I understand correctly - so why do I have the above-mentioned fields > in this form? > > Would you please shed some light? > > Regards, > > Emad