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

0 Comments

Submit a Comment

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

Upcoming Events

august

12aug10:00 am10:30 amWhy Levridge Grain? How to Achieve Efficient and Accurate Scale Tickets

12aug12:00 pm1:00 pmThe Three Paths to Dynamics 365 Finance and Supply Chain from Dynamics AX

13aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Inspire Keynote Breakdown

19aug10:00 am11:00 amWhat is Levridge? An Overview of the Ultimate Ag Solution

19aug12:00 pm12:30 pmThe Modern Manufacturer - Death by Safety Stock

27aug11:00 am12:00 pmConfab with Stoneridge - Livestream - Dynamics 365 2020 Wave 2 Preview

september

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

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

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

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

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!

X