What are Inventory Dimensions in Dynamics 365 Supply Chain?

By Lynn Litzau | May 28, 2021

Inventory Dimensions in Dynamics 365 Supply Chain

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

Recommended Reading:

5.13.22 Power Platform

Using Power BI Object Level Security

  The following article will demonstrate how to use Power BI Object Level Security to disable column data based on […]

Read the Article
5.12.22 Dynamics CRM

How to Use the Stoneridge Support Portal

Stoneridge Software’s support portal is an intuitive and useful function that makes it easy for you to access resources to […]

Read the Article
5.6.22 Dynamics GP

Dynamics GP Transaction Removal: Purchase Orders

  Are you having performance issues with Purchase Orders?  Do you find that there are old Purchase Orders on your […]

Read the Article
5.5.22 Dynamics GP

The Real Story about the Long-Term Future of Dynamics GP Support

I’ve seen a number of people put forward comment that Dynamics GP is going away and you have to get […]

Read the Article

New Features in Dynamics 365 Business Central 2022 Wave 1 Release Part 3 – Financial Enhancements

The Dynamics 365 Businses Central 2022 Wave 1 Release has a lot of new and exciting features to help your […]

Read the Article
4.29.22 Dynamics GP

Dynamics GP Transaction Removals: Bank Reconciliation

  This is part 2 of a 3 part series on Dynamics GP Transaction Removals. These quick tips will hopefully […]

Read the Article
4.28.22 Dynamics GP

Uncommonly Used Features – Integrate Purchasing and Payables to Fixed Assets in Dynamics GP

Being able to integrate Purchasing and Payables to Fixed Assets in Dynamics GP will help you create visibility for your […]

Read the Article

New Features in the Dynamics 365 Business Central 2022 Wave 1 Release Part 2 – Ease-of-Use Features

  There are many new features in the Dynamics 365 Business Central 2022 Wave 1 Release to get excited about! […]

Read the Article
4.22.22 Dynamics GP

Dynamics GP Transaction Removal Series: Receivables

  This is part 1 of a 3 part series on Dynamics GP Transaction Removal. These quick tips will hopefully […]

Read the Article

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X