Hi,
We use trade agreements to set up price break prices on items that we regularly purchase, and it works well.
However, I want to apply trade agreement pricing to another range of items and I cannot seem to get it to work.
Prices from the supplier are given to us based on length and order qty. For example items that are 501-1000mm long are £10 each for 10+ £9 for 20+ and £8 for 30+. Items that are 1001-1500mm long are £15 each for 10+ £14 for 20+ and £13 for 30+. And so on. We have about 20 different length ranges.
Each item has a unique part ID and would fall into one of the length ranges.
I can set up trade agreements for each item based on quantity, but we have a lot of items and more are added all the time so this isn't really an option.
I would like to create groups for each length range that have the various price breaks set up in a trade agreement. I would then like to assign a group to each item so that the item is linked to the overall trade agreement for that group. When pricing is revised at the end of the year I would then only have to update the trade agreements for the 20 groups rather for each item.
Frustratingly, the price breaks are not based on a fixed discount amount or percentage so I cannot use a line discount trade agreement. I have tried setting up price/discount groups but I end up going round in circles!
We are using AX2012R3.
I do not know if AX can do what I want, or if I am not doing things correctly so any advice would be appreciated!
Thanks in advance
Andy