Customer ID per each supplier

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

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.
Kind regards,
Sergei
Reply | Threaded
Open this post in threaded view
|

Re: Customer ID per each supplier

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 : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/

Reply | Threaded
Open this post in threaded view
|

Re: Customer ID per each supplier

biletnikov
This post was updated on .
Should we use the "comments" field to store the id in PartyRelationship ?
Kind regards,
Sergei
Reply | Threaded
Open this post in threaded view
|

Re: Customer ID per each supplier

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 : 06.17.66.40.06
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : 02.48.02.56.12
Site : http://www.librenberry.net/

Reply | Threaded
Open this post in threaded view
|

Re: Customer ID per each supplier

Adrian Crum-3
In reply to this post by biletnikov
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.
Reply | Threaded
Open this post in threaded view
|

Re: Customer ID per each supplier

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...
Kind regards,
Sergei
Reply | Threaded
Open this post in threaded view
|

Re: Customer ID per 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.