Iain,
I'd suggest considering the Agreement/AgreementTerm entities: you create
an agreement between your company and the supplier, then add a new term
to specify the assigned id; when you start a purchase order and select
this agreement, the agreement term will be automatically added to the
cart/order/documents.
Jacopo
PS: IMO in general, for the future, we should consider to move
information to the Agreement data model: for example, with a concept of
a default agreement for sales orders, some of the fields in the product
store could be moved in the agreement etc...
Iain Fogg wrote:
I have a large number of suppliers that all assign me a different
customer number. Does anyone know how/where I can record this
information? I need to include the number on things like my purchase
orders.
The obvious place for such an attribute is with the "party_relationship"
(although since this could conceivably be multi-valued, a new table ala
"employment" would be better).
A short-term hack would be to simply store the information as a
"party_attr". For example, if my customer number with supplier XYZ is
1234, store (XYZ, 123) as a name-value pair in party_attr.
Have I missed something more obvious, like the correct place to record
assigned customer numbers?
Cheers, Iain
