Every product that you are using should have a cost defined against it. In this example we will show how you can manually assign a cost to your Released Products within Dynamics AX.
NOTE: This is part of the Configuring Costing and Cost Sheets in Dynamics AX 2012 blueprint series where we show how to configure costing within Dynamics AX, and also how to set up a costing sheet to better view and analyze the costs. If you want to see all of the other posts in this series, click here.
Costing Versions are used within Dynamics AX to store the costs of your products, and are also used by the BOM cost calculations as reference costs. You can have as many costing versions as you like and can separate them out as Standard, and Planned versions. You can use them to track historical costs, actual production costs, and also financial costs used for analysis.
NOTE: This is part of the Configuring Costing and Cost Sheets in Dynamics AX 2012 blueprint series where we show how to configure costing within Dynamics AX, and also how to set up a costing sheet to better view and analyze the costs. If you want to see all of the other posts in this series, click here.
If you are using the production module within Dynamics AX, then you are probably wanting to get a better handle on your costs. You can easily configure Dynamics AX to calculate costs of BOM’s, and if you want to get a little more industrious then you can also create cost sheets broken out by your particular cost categories, incorporate routing costs, and even add surcharges and other indirect costs.
In this blueprint we will walk through an example that shows how to set up your costing controls within Dynamics AX.
Tables need to be enabled for workflow processing before they can be used by the workflows themselves. This is done simply by adding a method to the table called canSubmitToWorkflow.
NOTE: This is part of the Developing a Product Approval Workflow in Dynamics AX 2012 blog series where we show how to develop a completely new workflow to manage the new product approval process. If you want to see all of the other posts in this series, click here.
Now that we have the status field on the table that we are going to trigger the workflow from, we can add it to the Released Products form so that we will be able to see the statuses of all of the product approvals. The easiest way to do this is by personalizing the form.
NOTE: This is part of the Developing a Product Approval Workflow in Dynamics AX 2012 blog series where we show how to develop a completely new workflow to manage the new product approval process. If you want to see all of the other posts in this series, click here.
Now that we have a Base Enumeration that defines all of the possible states for the approval of the products, we need to add it to the Product table so that we can track the status of the records.
NOTE: This is part of the Developing a Product Approval Workflow in Dynamics AX 2012 blog series where we show how to develop a completely new workflow to manage the new product approval process. If you want to see all of the other posts in this series, click here.
Having all of the prices and costs listed out is good, but it’s not very usable for updating the costs when the values are related. To make the template more useful, we will use the Matrix Fields options within the Dynamics AX Add-In for Excel to create summary price fields that we can update in a tabular format.
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.
The easiest way by far to update Dynamics AX in mass is to use the Dynamics AX Add-In for Excel. Creating a template that you can use for the updates is a really simple process and just takes a minute or so.
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.
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.
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.
Extending Dynamics AX 