Using Dynamics AX to Track Part Status in Inventory

by | Updated August 15, 2016 | Dynamics AX, Inventory, Manufacturing

Depending on your business model, there may come a time when you end up with a used or refurbished part that you need to store in inventory. You are then faced with a couple of quandaries. First, how do you make sure that the part shows up in inventory as a used part without creating a new part number for it? Second, how can you add it to inventory at a different cost than a new part without affecting any costing calculations?

The solution I have found in Microsoft Dynamics AX is to use a product dimension for Status. Once you have setup the products correctly, this will allow you to define a status on each inventory transaction and to track a different cost per status. An important note – you must set up the product to use this dimension when you first create the product as this cannot be changed at a later date.

Create a Product Dimension Group

Your first step in defining statuses to be used on a product is to create a product dimension group. Go to Product information management > Setup > Dimension groups > Product dimension groups and create a new product dimension group. Select one of the dimensions that isn’t already being used for other purposes (except for the Configuration dimension) and mark it as Active. Make sure that it is active for purchase prices and sales prices as well. To minimize confusion, it is also a good idea to rename the dimension to Status (I used the Style dimension and renamed it to Status).

Product Dimension Groups in Dynamics AX


Create a Product Master

Once you have the product dimension group created you can create your products. When using product dimensions there are a few extra steps that are required in order to apply those dimensions to your product. The first step is to create a product master. There are a couple of ways to do this but today I’m going to focus on creating a product master that is automatically released to the company. Go to Product information management > Common > Released products. Create a new released product and make sure to select Product master as the Product subtype and your new product dimension.

New Released Product in Dynamics AX


Create Product Variants

This next step is actually more of a two-step process. You first need to define the applicable Product dimensions for this product. Select the released product you just created and click the Product dimensions button on the product tab of the action pane. Create a new dimension for each status (you will have to type each status for the first product but all the subsequent products you create you will be able to just select them from the dropdown).

Product Dimension in Dynamics AX

Now that the statuses have been defined, you need to create the product variants in order to use the statuses. With your released product still selected, click the Released product variants button on the Product tab of the action pane. You will need to create a variant for each of the statuses. On the Released product variants window, select the Variant suggestions button. Select all of the suggested variants and click Create. This will create a variant for each of the statuses you defined in the product dimensions form.

Released Product variants in Dynamics AX


Allow Costing by Variant

The final step before you can begin using the new product is to make sure that it allows a different cost for each variant. Open the released product and make sure that the Use cost price by variant checkbox on the Manage costs fast tab is checked.

Released Product Details in Dynamics AX

Now you are able to track the status of this part in inventory and manage your costs appropriately.

Related Posts


Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events


06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

13oct12:00 pm12:30 pmWave 2 Release – What’s Coming for Dynamics 365 Sales and Customer Service

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference


04nov11:00 am12:00 pmConfab LIVE with Stoneridge - Challenging the Development Paradigm

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!