You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by biletnikov <bi...@gmail.com> on 2012/03/01 11:11:04 UTC

Customer ID per each supplier

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.

Re: Customer ID per each supplier

Posted by Adrian Crum <ad...@sandglass-software.com>.
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.

Re: Customer ID per each supplier

Posted by biletnikov <bi...@gmail.com>.
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.

Re: Customer ID per each supplier

Posted by Adrian Crum <ad...@sandglass-software.com>.
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.

Re: Customer ID per each supplier

Posted by Nicolas Malin <ma...@librenberry.net>.
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/


Re: Customer ID per each supplier

Posted by biletnikov <bi...@gmail.com>.
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.

Re: Customer ID per each supplier

Posted by Nicolas Malin <ma...@librenberry.net>.
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/