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


02sep10:00 am10:30 amThe Modern Manufacturer - Cycle Count Management

02sep12:00 pm12:30 pmBest Practices for Work Order Planning and Routing for Field Service Companies

09sep10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

09sep12:00 pm12:30 pmOverview of Microsoft Promotion for NAV and GP Clients

10sep11:00 am12:00 pmConfab with Stoneridge - Livestream - Field Service Comparisons

16sep10:00 am10:30 amThe Modern Manufacturer - Product Lifecycle Management

16sep12:00 pm12:30 pmHow to Upgrade to Dynamics 365 Finance and Operations: Examining Custom Code and ISV Implications

16sep2:00 pm2:30 pmScheduling and Dispatching for the Modern Field Service Company

23sep12:00 pm1:00 pmDynamics 365 Business Central Wave 2 Release Preview - An Overview of the Most Exciting New Features Coming in October

24sep11:00 am12:00 pmConfab with Stoneridge - Livestream - The Modern Workplace: Teams, Sharepoint, Outlook, Office, and AI Integration

30sep10:00 am10:30 amThe Modern Manufacturer - Return Management

30sep12:00 pm12:30 pmEmpowering Your Field Service Technicians with a Mobile Solution


07oct12:00 pm1:00 pmThe Three Paths to Business Central from Dynamics GP

08oct11:00 am12:00 pmConfab with Stoneridge - Livestream - The Vision and Strategy of Microsoft Business Systems

14oct10:00 am10:30 amThe Modern Manufacturer - Complex Cost Modeling

14oct12:00 pm12:30 pmGenerating Custom Inspection or Process Forms

19octAll Day22Stoneridge Connect Fall 2020

22oct11:00 am12:00 pmConfab with Stoneridge - Livestream - Stoneridge Connect Recap

28oct10:00 am10:30 amThe Modern Manufacturer - Engineering Change Orders

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!