Creating an Excel template for Updating Product Costs and Prices

Everyone uses Excel to prepare information for updates within Dynamics AX because it gives you a little bit more freedom as you are massaging the data. If you have the Dynamics AX Add-In for Excel installed on your computer then you don’t even have to key in the data once you have created it because you can create an Excel template that securely updates Dynamics AX from Excel.

In this example we will show how you can use the Dynamics AX Add-In for Excel to create a template for updating product costs and prices, which you can use for mass updates, or quick changes to the pricing without even having to touch the Dynamics AX client.

Here are all of the topics that are included in this blueprint:

1. Correcting the InventTableModule Update Method
2. Creating an Update Template within Excel
3. Creating a Tabular Update Template in Excel Using Matrix Fields

The Dynamics AX Add-In for Excel is a great tool. For quick updates, or corrections of masses of data it makes like a breeze.

Give it a go.