Re: SupplierProduct and agreements

Posted by Jacopo Cappellato on Jul 06, 2007; 10:50am
URL: http://ofbiz.116.s1.nabble.com/SupplierProduct-and-agreements-tp182449p182451.html

David,

ideally, I'd like to define the two fields as primary key fields (I know
that this entity has already a very complex primary key...) for the
SupplierProduct entity; of course they could be set to "_NA_" if no
agreement information is available.

Then, if an agreement is associated to a purchase order at the beginning
of the order entry, it will be used not only to set a currency and the
terms for the order (as is now) but also to select the SupplierProduct
belonging to that agreement; if they are not found then the _NA_ ones
could be used.

Jacopo



David E Jones wrote:

>
> This is an interesting idea to perhaps reconcile the different worlds of
> ProductSupplier versus Agreement to figure out purchase prices. How do
> you see these working together once this link is estabished?
>
> -David
>
>
> Jacopo Cappellato wrote:
>> Hi all,
>>
>> I'd like to add two new optional fields to the SupplierProduct entity:
>> agreementId and angreementItemSeqId
>>
>> In this way it will be possible to associate the supplier product
>> entries to an existing agreement with a supplier. Then I will create a
>> new subscreen under the Agreement screen to list and manage all the
>> SupplierProduct entries associated to the agreement (and supplier).
>>
>> Is it ok?
>>
>> Jacopo
>>