How to find trade agreement with additional field?

(0) Share

Report

Posted on by bernardqin

573

I have added a new field in both tables PriceDiscTable and PriceDiscAdmTrans, and suppose that the value is already posted to PriceDiscTable. Now I want to find trade agreement with this new field.

Can anyone give me some ideas, or snippets?

Thanks

I have the same question (0)

All responses (15)

Answers (1)

André Arnaud de Cal... 301,030 Super User 2025 Season 2 on at

Like (0)

Report

Hi bernardqin,

What exactly do you mean with 'suppose that the value is already posted'? Do you mean to ask for help how to create an extension to copy the value of your new field from one table to the other during posting of the trade agreement journal? Or do you have another question here?

Was this reply helpful? Yes No
bernardqin 573 on at

Like (0)

Report

Hi Andre,

I mean that I want to find price based on original fields (like AccountRelation, ItemRelation, date range), and also my new field.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,030 Super User 2025 Season 2 on at

Like (0)

Report

Hi bernardqin,

Do you want to search in the trade agreements or should there be a change in the logic to retrieve a price on the sales order?

Was this reply helpful? Yes No
bernardqin 573 on at

Like (0)

Report

Yes, I want to change the logic to find price.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

pricing logic is crucial in SCM

if it's minor change then would be better otherwise would have to extend many places

Was this reply helpful? Yes No
Suggested answer

Sergei Minozhenko 23,093 on at

Like (1)

Report

Hi bernardqin,

If you want to change the trade agreements search you need to change PriceDiscPriceAgreementSearch class : COC method for checkAdditionalQualificationForFindingPriceAgreement or doesQuantityQualifyForFindingPriceAgreement and add check if trade agreement record matches by the new field which should be added to PriceDiscPriceAgreementParameters class as well. Then you need to modify the place where the parameter class is initialized (by reference search) and initialize a new field in this class.

Was this reply helpful? Yes No
bernardqin 573 on at

Like (0)

Report

Sorry for delaying reply. Would you please give me some code snippet for reference? Thanks.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

see if this helps and suggest

bredetservices.com/.../

Was this reply helpful? Yes No
bernardqin 573 on at

Like (0)

Report

Thank for your reply. I want to find agreement with additional criteria, however the code you shared is about how to create agreement journal.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

as Sergei suggested, use CoC on pricetradeagreement classes and introduce your new field

need to also give the same in activate trade prices

Was this reply helpful? Yes No