The growth of the product and acceptance by the market has been remarkable. It has been an interesting time to watch the product grow into a Tier one solution from the Axapta version. When it has updated, you can look in the Dynamics AX Status tab and see that the records have been updated.īut more importantly you can see that the prices have been updated within your journal.I have overseen 6 implementations of AX in mid-market consumer Products organizations over the past 10 years. When you have updated the price, just click on the Publish menu button within the Update group of the Dynamics AX ribbon bar.

You can use this to calculate the price lists line amount through a formula.Īnd then just paste the prices into the spreadsheet. For example, to apply a date range to all of your price list items, just update the first row, select the remaining rows, and press CTRL+D.Īlso, as a bonus there is a lot more supplementary information in the price list that you don’t normally see. Now you can quickly update your pricing data using all of the Excel functions. This will transfer all of the data from the pricing journal over to Excel for you. Now when you are within a pricing journal, click on the Edit In Excel menu item in the menu bar. Then right-mouse-click on the service group, and click on the Deploy Service Group menu item.Īfter a minute you will receive a notice that the web service has been deployed, and you can exit from AOT. To do this, open up AOT and find the PriceDiscService service within the Service Groups. Excel updates the pricing through the PriceDiscService web service, and you need to make sure that it’s deployed. Now you have an easy way to make sure that The Price Is Right without having to dress up in silly clothes.īefore we start doing this, there is one configuration step that you need to perform. This doesn’t have to be a huge data entry chore though because Dynamics AX allows you to update your pricing journals through Excel.

And just like your own heart, you need to keep it pricing healthy and fit by adjusting it to meet the customer’s wishes and whimsy’s so that you are the most competitive in the marketplace. If Dynamics AX is the body of all your businesses data, then some may consider pricing to be the heart and soul, because making sure that everything is priced correctly is vital. Updating Your Pricing Journals Through Excel

Dynamics ax pricing