In Dynamics AX 2012 R3 you can specify a sales price on a released item. You cannot specify a price on a set of products using the trade agreements. In earlier releases (like AX 2009) it was possible to have a sales price group to control prices across many items, but this has been discontinued.
I wanted to change this, so that AX 2012 R3 do have the possibility to have a price that is used by many released products. Here is what I did:
First I created a new field on the item master sales (InventTableModule):
Then I made it possible to create sales price groups, and to specify prices per currency for this price group:
Then when creating sales order it selects the generic price.
With this little change I can now control prices on thousands of released products, and rather to put individual prices on each item, I just classify each item to a price group. Let’s say I have 10.000 released products and prices in 6 currencies this would minimum have resulted in 60.000 records in the price agreement table. If I in addition have 10 companies where I also want to use the prices, this results in 600.000 records on prices.
If I have standardized my pricing levels to consumer oriented prices, and using the sales price group, I would only need to maintain 60 * number of price groups. Just a fraction J
To make this happen, the following objects needs to be modified:
If you come across a similar requirement or you need this, feel free to contact me on the blog J
Happy DAX’ing
