Gap between quantity ranges or amount ranges for multiple trade agreement journal

(0) Share

Report

Posted on by MaharajaP

Hi All,

Ive been creating Vendor trade agreement journals and came across this scenario.

When i assign a quantity range to the journal lines in the trade agreement i have this error.

So when the qty range is 1-10 and the next range should be 11-20 the journal throws this error on posting.

But when i make the range as 1-10 and 10-20 it posts the journal but this would mean 10 and 11 have the same price when i make a purchase order.

Also noted when a qty of 20 is entered the unit price doesn't auto-populate.

Please share your comments/inputs on this scenario.

Thanks

Maharaja.

I have the same question (0)

All responses (14)

Answers (4)

Sort by

Verified answer

Rahul Mohta 21,046 on at

Like (1)

Report
Copy link

Link copied!

should enable find next and for qty 10 it would take the best price

trade agreements does not like qty gaps as it does not help in finding right price and creates a void

the to qty is always the upper range and should be no issue in getting price from trade agreement, ensure the activation allows for the combination being used

Was this reply helpful? Yes No
Verified answer

qianwang 7,168 on at

Like (2)

Report
Copy link

Link copied!

Hi MaharajaP,

The quantity From value is inclusive, and the quantity To value is exclusive in trade agreement.

The To field was introduced in AX 2012. Previous versions of AX only had a quantity field, which is now renamed quantity from. An upgrade to AX retains the quantity from field and introduces an empty quantity to field.

Maybe you can set the price for quantity 1 to 11 to be 1 EUR and the price for quantity 11 to 21 to 0.5 EUR.

Regards,

QianQW

Was this reply helpful? Yes No
MaharajaP 95 on at

Like (0)

Report
Copy link

Link copied!

Thanks Qian.

Was this reply helpful? Yes No
MaharajaP 95 on at

Like (0)

Report
Copy link

Link copied!

Thanks Rahul.

Was this reply helpful? Yes No
qianwang 7,168 on at

Like (0)

Report
Copy link

Link copied!

Hi MaharajaP,

Thank you for your update.

If your issue is resolved, please click the "Yes" button at the top of helpful answer to close this thread.

Regards,

QianQW

Was this reply helpful? Yes No
Rahul Mohta 21,046 on at

Like (0)

Report
Copy link

Link copied!

pls suggest if our responses helped in answering your query

Was this reply helpful? Yes No
MaharajaP 95 on at

Like (0)

Report
Copy link

Link copied!

Sure, i shall revert shortly.

Thanks.

Was this reply helpful? Yes No
MaharajaP 95 on at

Like (0)

Report
Copy link

Link copied!

Hi Qian,

Sure would do it shortly.

Thanks.

Maharaja.

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,972 Moderator on at

Like (3)

Report
Copy link

Link copied!

Hi MaharajaP

If you don't want to set your quantity breaks at 1 - 11 and 11 - 21, you could just turn off this validation. Although you'll find the parameter in the Accounts receivable module, it controls this behaviour on both sales and purchase trade agreements.

Head to Accounts receivable parameters > Pricing > Trade agreement validation, and set the Check For Overlaps And Gaps toggle to off.

(I have to admit, this is the first time I have seen this parameter. I am a bit nervous that the environment I am looking in has a customisation or add-on installed! This is the parameter on a 10.0.10 environment):

Was this reply helpful? Yes No
MaharajaP 95 on at

Like (0)

Report
Copy link

Link copied!

Hi Guy Terry,

The environment im working on is 10.0.9 Update 33, and i dont find this parameter, might be it was customized or ill have to check an environment with 10.0.10.

Thanks for your reply. Appreciate it.

Regards,

Maharaja.

Was this reply helpful? Yes No