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.
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
7 thoughts on “Generic prices in Dynamics AX 2013 R3”
I think its particularly useful to have the option to define costs and prices for item variants so that those can be defined just at the item level as a default for all variants of that item – it might be a parameter to decide whether those can then be overridden for a specific variant- that might reduce issues if anew variant created and forgetting to update its/cost /price with spurious inventory costs. especially for retail where there may be an assorted box of variants. transferred between sites.
Is the Price Group function in R3 Cu8 same as the one described above?
Nice but I think you are inaccurate when you say that this capability existed in previous versions. The price group never allowed prices to be setup for multiple items. The grouping was only for customers just like it is in AX 2012
Thanks for the clearification 🙂
Thanks you for your prompt reply. I really admire your enthusiasm and the quality of your blog (y). We are currently developing a customization which is similar to your solution.
Dear Kurk, recently i have seen a client having this kind of requirements. Can you share the development effort to achieve this customization?
We only used a few hours to make this. It should not be diffucult for a skilled X++ Developer.