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.

All responses (14)

Answers (4)

MaharajaP 95 on at

Like (0)

Report

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

Hello Jonnix,

Appreciate your effort to confirm this.

Regards,

Maharaja
MaharajaP 95 on at

Like (0)

Report

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

Hi Guy Terry,

Looks like i could only use the suggestion when i have 10.0.10 since without un-checking this parameter it wont work and i don't have a visibility now in 10.0.9.

Let me recheck if i have 10.0.10 environment and confirm if this works.

Thanks again.

Regards,

Maharaja.
Verified answer

Guy Terry 28,604 Super User 2024 Season 2 on at

Like (0)

Report

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

Hi Jonnix,

Thanks for confirming that!

@Maharaja, if you were able to turn off this validation, you should note that with this setup:

1 to 10

11 to 20

when the order quantity is exactly 10, F&O would not find a price.

You might want to consider not using the To quantity at all. If you configured:

From 1 = 1€

From 11 = 0.5€

AND IF YOU ENSURE THAT FIND NEXT IS TICKED ON EACH LINE, then F&O will always find the line with the lowest price (which applies for the quantity that you are ordering). Again, you need to be able to turn off the validation to be able to do this.
Jonnix 165 on at

Like (1)

Report

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

Hello Maharaja,

I confirm that it cannot be find on a 10.0.9 environment but that it's present on a 10.0.10 environment.

Have a nice day,

Jonnix
MaharajaP 95 on at

Like (0)

Report

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

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.
Verified answer

Guy Terry 28,604 Super User 2024 Season 2 on at

Like (3)

Report

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

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):
MaharajaP 95 on at

Like (0)

Report

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

Hi Qian,

Sure would do it shortly.

Thanks.

Maharaja.
MaharajaP 95 on at

Like (0)

Report

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

Sure, i shall revert shortly.

Thanks.
Rahul Mohta 21,014 on at

Like (0)

Report

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

pls suggest if our responses helped in answering your query
qianwang 7,151 on at

Like (0)

Report

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

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