What are Inventory Dimensions in Dynamics 365 Supply Chain?

by | May 28, 2021 | Dynamics 365 for Finance and Operations, Inventory

What are Inventory Dimensions in Dynamics 365 Supply Chain? When evaluating a new ERP platform, clients migrating from legacy systems that do not have the ability, or have limited ability to see inventory in multiple ways are often confused by the concept of inventory dimensions in Dynamics 365 Supply Chain. Inventory dimensions are how the system can store, cost, trace and potentially price your inventory within Dynamics 365.

How to Set Up Inventory Dimensions in Dynamics 365 Supply Chain

When starting a new implementation, it is important to consider how you want your inventory to function prior to setting any inventory dimensions. There are three groups that make up the inventory dimensions as outlined in Figure 1.

Inventory Dimensions in Dynamics 365 Supply Chain

Once you have determined your approach to inventory dimensions you can unlock the power and depth of the Dimensions display option within Dynamics 365. Dimension display allows a user to toggle different inventory dimensions on and off to view their data in many ways.

Utilizing the on-hand inventory screen within Dynamics 365 we can demonstrate the Dimensions display and how it allows more detailed reporting of on-hand quantities that are more specific to the physical location of the items.

Site 1

A site is defined as a grouping of business resources (typically warehouses) in a particular geographic region that share the same transactions and cost structure.  The region can be a city, multiple cities, or even a warehouse within a city.  In Figure 2 we demonstrate a site structure where Site 1 contains three separate warehouses within a city.

Within each warehouse, the structure can be further broken down into locations that can contain Aisles, Racks, Shelves, and Bins.

When viewing on-hand inventory at dimension level these values can be toggled on and off through the Dimension display.  Below we will demonstrate five different views of on-hand inventory for sample item Dekalb Corn Seed which has assigned inventory dimensions of Site, Warehouse, Location, and Batch Number.

Menu Path: Inventory management > Inquiries and reports > On-hand list

menu path

Site View

In this view, the user activated only the site dimension so all on-hand inventory for all three warehouses is rolled up under the site.

site view

Site & Warehouse View

In this view, the user-activated Site and Warehouse but then filtered for only Warehouse 12 inventory.

site and warehouse view

Site, Warehouse & Location View

In this view, the user-activated Site, Warehouse, and Location but then filtered for only Location 13-02 inventory.

site warehouse and location view

Site, Warehouse, Location, and Batch Number View

In this view, the user-activated Site, Warehouse, Location, and Batch number but then filtered for only batch number 67846 inventory.

site warehouse location and batch number view

Site, Warehouse, Location, and Batch Number View

In this view, the user-activated Site, Warehouse, Location, and Batch number but have no filters applied so they see all on-hand inventory for this item.

site warehouse location and batch number view 2

Each time a new dimension is toggled on or off the active grid will update to reflect the addition or subtraction to on-hand inventory.  Inventory dimensions can also be toggled on or off for view within the lines grid in sales orders, purchase orders, trade agreement journals, and all inventory journals such as counting, transfer, adjustment, movement, item arrival, and ownership change.  Below is a before and after view of the dimensions display in the sales order lines grid once site, warehouse, location, and batch number are activated.

Before:

before

After:

after

If your company is evaluating Dynamics 365 Finance and Supply Chain or you are a current Dynamics 365 Supply Chain user, embrace the power and flexibility inventory dimensions can provide your users.  To learn more, reach out to the experts at Stoneridge Software.

 

Related Posts

0 Comments

Submit a Comment

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

Upcoming Events

june

02jun2:00 pm2:30 pmBusiness Intelligence for Batch Manufacturers

16jun10:00 am10:30 amHow AP automation can speed up month-end close in D365 Finance

17jun11:00 am12:00 pmConfab Live with Stoneridge – Real Time Marketing Strategies for Success

23jun10:00 am10:30 amThe Modern Manufacturer: Cost Accounting in D365

30jun10:00 am10:30 amAP Automation Checklist for a 2022 Rebound

30jun2:00 pm2:30 pmAchieving Success: How Technology Is Helping Nonprofits Thrive

july

01jul11:00 am12:00 pmConfab Live with Stoneridge – Dataverse Virtual Entities

14jul12:00 pm12:30 pmBeyond Reporting - What Business Intelligence Can Do For Your Agribusiness

15jul11:00 am12:00 pmConfab Live with Stoneridge – Integration Strategies for End User Success

21jul10:00 am10:30 amThe Modern Manufacturer: Manufacturing Software in the Real World

21jul12:00 pm1:00 pmIs it Worth it to Upgrade to Dynamics 365 Finance and Supply Chain Management? - Everything AX Users Need to Consider

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