Using Dynamics AX to Track Part Status in Inventory

by | Apr 22, 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.


Submit a Comment

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

Upcoming Events


02jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Conference Room Pilots

03jun10:00 am10:30 amWhy Levridge Grain? Streamlining Sales Contracts

04jun11:00 am12:00 pmConfab With Stoneridge - Livestream - Customer Insights

04jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Dealing with Challenges Mid-Project

09jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Customizations vs Configurations and How You Manage Them

10jun10:00 am11:00 amOn the Job with Dynamics 365 - Manufacturing Buyer

11jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Data Migration - Early and Often

15jun(jun 15)9:00 am16(jun 16)4:00 pmDynamics 365 Finance and Supply Chain Management Training for AX 2012 Developers

16jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Environment Management and Deployments

17jun10:00 am10:30 amWhy Levridge Grain? Best Practices for Managing Load Orders for Grain Processors

17jun12:00 pm1:00 pmMobilizing an efficient, streamlined AP department with AP Automation

17jun2:00 pm3:00 pmGuide for B2B Businesses: Tackling Supply Chain Optimization and Customer Experience Challenges

18jun11:00 am12:00 pmConfab with Stoneridge - Livestream - Enterprise Asset Management and Preventative Maintenance

18jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Testing - Definition and Activities

23jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Training for All

24jun10:00 am11:00 amOn the Job with Dynamics 365 - Manufacturing Production Manager

25jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Going Live

30jun1:00 pm1:30 pmHow to Implement Microsoft Dynamics: Hypercare

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!