kurthatlevik: Generic prices in Dynamics AX 2013 R3

[Blog bot]

Источник: http://kurthatlevik.wordpress.com/20...cs-ax-2013-r3/
==============

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




Источник: http://kurthatlevik.wordpress.com/20...cs-ax-2013-r3/