Product - Supplier relationship

[Ritesh Trivedi]

Hi,

Can someone please point me to the table which links products with its supplier?

Also, seems like when you create the product, one cannot specify either the supplier directly or add the party with the supplier role. Isnt that absolutely required? At least in my application, a product needs to have a supplier and a manufacturer.

[Rashko Rejmer]

The entity you are looking for should be SupplierProduct entity.

https://demo.hotwaxmedia.com/webtools/control/FindGeneric?entityName=SupplierProduct&find=true&VIEW_SIZE=50&VIEW_INDEX=0
https://demo.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000

Regards,
Rashko Rejmer


On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote:
> Hi,
>
> Can someone please point me to the table which links products with its
> supplier?
>
> Also, seems like when you create the product, one cannot specify either the
> supplier directly or add the party with the supplier role. Isnt that
> absolutely required? At least in my application, a product needs to have a
> supplier and a manufacturer.

[Rashko Rejmer]

In r607072 the label from ProductTabBar was changed from "Supplier" to
"Vendor Product". Is this made intentionally or by mistake?

Regards,
Rashko Rejmer


On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote:
> Hi,
>
> Can someone please point me to the table which links products with its
> supplier?
>
> Also, seems like when you create the product, one cannot specify either the
> supplier directly or add the party with the supplier role. Isnt that
> absolutely required? At least in my application, a product needs to have a
> supplier and a manufacturer.

[Jacques Le Roux]

Hi Marco, Rashko,

Marco, as described below by Rashko, you introduced the "Vendor Product" concept in r607072. I wonder why and why it replaced
ProductSuppliers ?

Thanks

Jacques

From: "Rashko Rejmer" <[hidden email]>

> In r607072 the label from ProductTabBar was changed from "Supplier" to
> "Vendor Product". Is this made intentionally or by mistake?
>
> Regards,
> Rashko Rejmer
>
>
> On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote:
>> Hi,
>>
>> Can someone please point me to the table which links products with its
>> supplier?
>>
>> Also, seems like when you create the product, one cannot specify either the
>> supplier directly or add the party with the supplier role. Isnt that
>> absolutely required? At least in my application, a product needs to have a
>> supplier and a manufacturer.
>

[David E Jones]

Those are very different entities for very different purposes.

A Vendor is a Party in the system that sells something.

A Supplier is a Party in the system that you buy things from.

-David


On Feb 9, 2008, at 7:19 AM, Jacques Le Roux wrote:

> Hi Marco, Rashko,
>
> Marco, as described below by Rashko, you introduced the "Vendor  
> Product" concept in r607072. I wonder why and why it replaced  
> ProductSuppliers ?
>
> Thanks
>
> Jacques
>
> From: "Rashko Rejmer" <[hidden email]>
>> In r607072 the label from ProductTabBar was changed from "Supplier"  
>> to
>> "Vendor Product". Is this made intentionally or by mistake?
>>
>> Regards,
>> Rashko Rejmer
>>
>>
>> On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote:
>>> Hi,
>>>
>>> Can someone please point me to the table which links products with  
>>> its
>>> supplier?
>>>
>>> Also, seems like when you create the product, one cannot specify  
>>> either the
>>> supplier directly or add the party with the supplier role. Isnt that
>>> absolutely required? At least in my application, a product needs  
>>> to have a
>>> supplier and a manufacturer.
>

[Jacques Le Roux]

Yes but then why has "Vendor ¨Product" replaced "Supplier" in this screen ?
https://demo.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000

In french it was before "Fournisseurs" as you can check here
https://demo40.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000

Jacques

From: "David E Jones" <[hidden email]>

>
> Those are very different entities for very different purposes.
>
> A Vendor is a Party in the system that sells something.
>
> A Supplier is a Party in the system that you buy things from.
>
> -David
>
>
> On Feb 9, 2008, at 7:19 AM, Jacques Le Roux wrote:
>
>> Hi Marco, Rashko,
>>
>> Marco, as described below by Rashko, you introduced the "Vendor  Product" concept in r607072. I wonder why and why it replaced
>> ProductSuppliers ?
>>
>> Thanks
>>
>> Jacques
>>
>> From: "Rashko Rejmer" <[hidden email]>
>>> In r607072 the label from ProductTabBar was changed from "Supplier"  to
>>> "Vendor Product". Is this made intentionally or by mistake?
>>>
>>> Regards,
>>> Rashko Rejmer
>>>
>>>
>>> On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote:
>>>> Hi,
>>>>
>>>> Can someone please point me to the table which links products with  its
>>>> supplier?
>>>>
>>>> Also, seems like when you create the product, one cannot specify  either the
>>>> supplier directly or add the party with the supplier role. Isnt that
>>>> absolutely required? At least in my application, a product needs  to have a
>>>> supplier and a manufacturer.
>>
>
>

Fixed in rev. 620189, I have not seen your previously emails.

Thanks Jacques and Rashko to report it,
Marco

----
Yes but then why has "Vendor ¨Product" replaced "Supplier" in this screen ?
https://demo.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000

In french it was before "Fournisseurs" as you can check here
https://demo40.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000

Jacques

From: "David E Jones" <[hidden email]>

Those are very different entities for very different purposes.

A Vendor is a Party in the system that sells something.

A Supplier is a Party in the system that you buy things from.

-David


On Feb 9, 2008, at 7:19 AM, Jacques Le Roux wrote:

Hi Marco, Rashko,

Marco, as described below by Rashko, you introduced the "Vendor  Product" concept in r607072. I wonder why and why it replaced ProductSuppliers ?

Thanks

Jacques

From: "Rashko Rejmer" <[hidden email]>
In r607072 the label from ProductTabBar was changed from "Supplier"  to
"Vendor Product". Is this made intentionally or by mistake?

Regards,
Rashko Rejmer


On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote:
Hi,

Can someone please point me to the table which links products with  its
supplier?

Also, seems like when you create the product, one cannot specify  either the
supplier directly or add the party with the supplier role. Isnt that
absolutely required? At least in my application, a product needs  to have a
supplier and a manufacturer.

[David E Jones]

Yes, that is incorrect. There is a "Vendor" tab, and this one should  
be labelled "Supplier", so the change to that was erroneous, or  
something along those lines.

-David


On Feb 9, 2008, at 12:33 PM, Jacques Le Roux wrote:

> Yes but then why has "Vendor ¨Product" replaced "Supplier" in this  
> screen ?
> https://demo.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000
>
> In french it was before "Fournisseurs" as you can check here
> https://demo40.hotwaxmedia.com/catalog/control/EditProductSuppliers?productId=GZ-1000
>
> Jacques
>
> From: "David E Jones" <[hidden email]>
>>
>> Those are very different entities for very different purposes.
>>
>> A Vendor is a Party in the system that sells something.
>>
>> A Supplier is a Party in the system that you buy things from.
>>
>> -David
>>
>>
>> On Feb 9, 2008, at 7:19 AM, Jacques Le Roux wrote:
>>
>>> Hi Marco, Rashko,
>>>
>>> Marco, as described below by Rashko, you introduced the "Vendor  
>>> Product" concept in r607072. I wonder why and why it replaced  
>>> ProductSuppliers ?
>>>
>>> Thanks
>>>
>>> Jacques
>>>
>>> From: "Rashko Rejmer" <[hidden email]>
>>>> In r607072 the label from ProductTabBar was changed from  
>>>> "Supplier"  to
>>>> "Vendor Product". Is this made intentionally or by mistake?
>>>>
>>>> Regards,
>>>> Rashko Rejmer
>>>>
>>>>
>>>> On Wed, 2008-01-16 at 12:38 -0800, Ritz123 wrote:
>>>>> Hi,
>>>>>
>>>>> Can someone please point me to the table which links products  
>>>>> with  its
>>>>> supplier?
>>>>>
>>>>> Also, seems like when you create the product, one cannot  
>>>>> specify  either the
>>>>> supplier directly or add the party with the supplier role. Isnt  
>>>>> that
>>>>> absolutely required? At least in my application, a product  
>>>>> needs  to have a
>>>>> supplier and a manufacturer.
>>>
>>
>

[SkipDever]

There is an entity SupplierProduct.  There is a field
SupplierProduct.supplierPrefOrderId which in the demo data contains
10_MAIN_SUPPL.

This is used in only one place that I can find BOMNode.isManufactured()

It is not clear to me from the context what the purpose of this field is and
what is the meaning of 10_MAIN_SUPPL.

Can anyone fill me in?

Skip
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.21/1266 - Release Date: 2/8/2008
10:06 AM

[Jacopo Cappellato]

Hi Skip,

if you have several suppliers for the same product you can use the
supplierPrefOrderId field to set the preferred ones.
10_MAIN_SUPPL has the meaning of "main supplier" for the product.

Jacopo

skip@thedevers wrote:

> There is an entity SupplierProduct.  There is a field
> SupplierProduct.supplierPrefOrderId which in the demo data contains
> 10_MAIN_SUPPL.
>
> This is used in only one place that I can find BOMNode.isManufactured()
>
> It is not clear to me from the context what the purpose of this field is and
> what is the meaning of 10_MAIN_SUPPL.
>
> Can anyone fill me in?
>
> Skip
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.21/1266 - Release Date: 2/8/2008
> 10:06 AM

[SkipDever]

Thanks Jacopo, shoulda seen that.

Skip

-----Original Message-----
From: Jacopo Cappellato [mailto:[hidden email]]
Sent: Saturday, February 09, 2008 10:24 PM
To: [hidden email]
Subject: Re: Product - Supplier relationship


Hi Skip,

if you have several suppliers for the same product you can use the
supplierPrefOrderId field to set the preferred ones.
10_MAIN_SUPPL has the meaning of "main supplier" for the product.

Jacopo

skip@thedevers wrote:
> There is an entity SupplierProduct.  There is a field
> SupplierProduct.supplierPrefOrderId which in the demo data contains
> 10_MAIN_SUPPL.
>
> This is used in only one place that I can find BOMNode.isManufactured()
>
> It is not clear to me from the context what the purpose of this field is
and
> what is the meaning of 10_MAIN_SUPPL.
>
> Can anyone fill me in?
>
> Skip
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.21/1266 - Release Date: 2/8/2008
> 10:06 AM


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.0/1268 - Release Date: 2/9/2008
11:54 AM

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.0/1268 - Release Date: 2/9/2008
11:54 AM