BeyondERP.Newsletter
Menu

Job page · Warehouse management

Item Consolidation

A periodic task page that shows the volumetric utilization of locations in a warehouse and lets you create inventory movement work to consolidate items.

Used by
Warehouse planner, Warehouse manager, Warehouse worker
Business process
Process inventory movements
Menu item
WHSItemConsolidationDisplayMenuItem
Main table
WHSItemConsolidationView
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA periodic task page that shows the volumetric utilization of locations in a warehouse and lets you create inventory movement work to consolidate items.
What you do hereUse this task to consolidate items into fewer locations so that you make better use of warehouse space.
ExampleFor example, when the same item sits in several locations that are only partly used, you can select those locations and consolidate the inventory.
Item Consolidation page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processMaintain inventory levels › Process inventory movements
Menu pathWarehouse management › Periodic tasks › Item Consolidation
Set up firstLocation profiles Microsoft Learn Movement types Microsoft Learn
Used next byWork details Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itWhen locations hold small quantities of the same item and you want to free space by moving them together.
How oftenOn demand, for example when utilization shows many half-empty locations.
What the output showsInventory movement work that moves the stock to the chosen location: one work ID per move. If the target already holds inventory, one work ID is created; for a new location, two.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Warehouse management > Periodic tasks > Item Consolidation.
  2. In the Warehouse field, select the warehouse to consolidate inventory for; the list shows the Utilization percentage of each location.
  3. Select all the locations whose inventory should be brought together.
  4. Select Consolidate inventory, then in the dialog choose the target location and a movement type, for example one set up for consolidation.
  5. Note the work ID in the message, and find the movement work on Work details.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
WarehouseSelects the warehouse that the consolidation is done for.Microsoft Learn
Utilization percentageShows the volumetric utilization of each location.Microsoft Learn WHSUtilizationPercent

Test checklist

  1. Movement work exists for the selected locations.
  2. After the work is done, the source locations are empty.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, before the work is done: Cancel the movement work before workers process it. Microsoft Learn
If you change it laterCreates inventory movement work; stock moves once workers complete it. Microsoft Learn
Technical architect

5Technical

Menu itemWHSItemConsolidationDisplayMenuItem Checked in Dynamics 365
FormWHSItemConsolidationForm Checked in Dynamics 365
TableWHSItemConsolidationViewShown as “ITEM CONSOLIDATION VIEW” in Record infoChecked in Dynamics 365
Who can open itPrivilegesLocation Utilization Maintain WHSLocationUtilizationMaintainLocation Utilization View WHSLocationUtilizationViewDutiesWarehouse Operation Master Inquire WHSWarehouseOperationMasterInquireWarehouse Operation Master Maintain WHSWarehouseOperationMasterMaintain
3 security rolesWarehouse planner WHSWarehousePlannerWarehouse manager WMSWarehouseManagerWarehouse worker WMSWarehouseWorker
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itWarehouse manager WMSWarehouseManagerWarehouse planner WHSWarehousePlannerTo use itWarehouse worker WMSWarehouseWorkerGive people one of these roles. On this system, 3 roles can open this page.Checked in Dynamics 365
Actions on the page(Action Pane without tabs): Consolidate inventoryChecked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=WHSItemConsolidationDisplayMenuItem
Everyone

7Sources