Customer ID per each supplier

[biletnikov]

Hello,
we use OFBiz in B2B with lots of drop shipment orders, i.e. we have customers and many suppliers.
Each our supplier has own customer id and it is very necessary for us to include this id in the order for each supplier.
Example,
the customer party in our OFBiz system has party id : 10001 (but it is useful only for us)
supplier A: 12345
supplier B: C345
supplier C: 1100
............
supplier X: 0055

how it is possible to store this info in OFBiz?
We considered party identification numbers, yes, it is possible to create identification type for each supplier, but it is not flexible solution, because we do not have the link to supplier party here.

We considered Party relationships,
in fact, it is possible to add relationships between customer and supplier and use "Comments" field to store the id, but it looks more like a hack.

What could you suggest us? Maybe we missed something in the OFBiz data model.
Thanks a lot.

[Malin Nicolas]

Use PartyRelationship beetwen customer and supplier

Nicolas

Le 01/03/2012 11:11, biletnikov a écrit :

> Hello,
> we use OFBiz in B2B with lots of drop shipment orders, i.e. we have
> customers and many suppliers.
> Each our supplier has own customer id and it is very necessary for us to
> include this id in the order for each supplier.
> Example,
> the customer party in our OFBiz system has party id : 10001 (but it is
> useful only for us)
> supplier A: 12345
> supplier B: C345
> supplier C: 1100
> ............
> supplier X: 0055
>
> how it is possible to store this info in OFBiz?
> We considered party identification numbers, yes, it is possible to create
> identification type for each supplier, but it is not flexible solution,
> because we do not have the link to supplier party here.
>
> We considered Party relationships,
> in fact, it is possible to add relationships between customer and supplier
> and use "Comments" field to store the id, but it looks more like a hack.
>
> What could you suggest us? Maybe we missed something in the OFBiz data
> model.
> Thanks a lot.
>
> -----
> Kind regards,
> Sergei
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Customer-ID-per-each-supplier-tp4434577p4434577.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

--
Nicolas MALIN
Consultant
Tél : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/

[biletnikov]

Should we use the "comments" field to store the id in PartyRelationship ?

[Malin Nicolas]

Le 01/03/2012 12:03, biletnikov a écrit :
> Should we use "Comments" field to store the id?
or positionTitle, if you don't change entity, else add an extend-entity
with externalId field

Nicolas


> -----
> Kind regards,
> Sergei
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Customer-ID-per-each-supplier-tp4434577p4434667.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.


--
Nicolas MALIN
Consultant
Tél : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/

[Adrian Crum-3]

No. Connect the parties properly using PartyRelationship and
OFBiz-generated party IDs. Use the PartyIdentification entity for
external IDs.

-Adrian

On 3/1/2012 11:03 AM, biletnikov wrote:
> Should we use "Comments" field to store the id?
>
> -----
> Kind regards,
> Sergei
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Customer-ID-per-each-supplier-tp4434577p4434667.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[biletnikov]

Of course, PartyRelationship relates parties between each other, but how to link party and external ids from PartyIdentification, it is not possible now.
Each customer can have many external ids for each supplier...

[Adrian Crum-3]

Create an ID type for each supplier.

-Adrian

On 3/1/2012 11:44 AM, biletnikov wrote:

> Of course, PartyRelationship relates parties between each other, but how to
> link party and external ids from PartyIdentification, it is not possible
> now.
> Each customer can have many external ids for each supplier...
>
>
> -----
> Kind regards,
> Sergei
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Customer-ID-per-each-supplier-tp4434577p4434734.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.