Before we start, in the current release of Dynamics AX R2, there is a tweak that we need to make to the AXInventModuleTable class in order to enable the Excel Add-In to update the data.

NOTE: This is part of the Creating an Excel template for Updating Product Costs and Prices blog series where we show how to create a template within Excel to update product costs and prices. If you want to see all of the other posts in this series, click here.

How to do it…

To create change that you have to make to the AXInventModuleTable class in order to enable the update from the Excel Add-In, follow these steps:

1. Open up the AOT explorer, expand out the Classes group and find the save method.
   
2. Replace the code in the save method with this:

   public void save()

   {

   //axInventTable.save();

   super();

   }

3. After you have finished, save the changes, and also it may be a good idea to run an incremental CIL build.