BeyondERP.Newsletter
Menu

Job page · Inventory management

Warehouse management on-hand cleanup

A periodic job that deletes on-hand records with only zero values for items that use warehouse management processes.

Business process
Manage data
Menu item
action:InventCleanupWHSInventSumWithInventDim
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 job that deletes on-hand records with only zero values for items that use warehouse management processes.
What you do hereUse this periodic task to make on-hand calculations for warehouse-managed items much faster.
Warehouse management on-hand cleanup 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 processManage data
Menu pathInventory management › Periodic tasks › Clean up › Warehouse management on-hand cleanup
Related pagesPhysical inventory by inventory dimension 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 on-hand calculations for warehouse-managed items slow down because InventSum and WHSInventReserve hold many records with only zero values.
How oftenAs a recurring batch job outside working hours. Microsoft gives no fixed interval.
Batch settingsSchedule it outside working hours with a Maximum execution time, so it stops and saves its progress before the day starts. It commits about every 100 deletions, so lock escalations can still occur.
What the output showsRecords in InventSum and WHSInventReserve below the Location level whose values are all zero are deleted. If negative physical inventory is allowed, some zero entries can stay, for example a license plate with +1 and -1 of two serial numbers.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Clean up > Warehouse management on-hand cleanup.
  2. In Delete if not updated for this many days, enter the minimum number of days to wait before an on-hand entry that dropped to zero is deleted. Enter 0 or leave it blank to clean up as soon as possible.
  3. In Maximum execution time (hours), enter how long the job may run before it saves its work and closes. Enter 0 or leave it blank to let it run until it's done.
  4. Set the scope and schedule under Run in the background, at times when system load is lightest and outside working hours, to avoid deadlocks with users.
  5. Afterwards, open the On-hand list with the Quantity <> 0 condition cleared: zero entries below the Location level, such as license plates, no longer appear.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Delete if not updated for this many daysThe minimum number of days to wait before an entry that drops to zero is deleted.Microsoft Learn
Maximum execution time (hours)The longest time the job may run before it saves its work and stops.Microsoft Learn

Test checklist

  1. Zero records below the Location level are gone from the On-hand list.
  2. On-hand quantities that aren't zero are unchanged.
  3. The job stopped within the Maximum execution time you set.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted zero records can't be restored. Users can no longer see that inventory used to be at a license plate, and Physical inventory by inventory dimension reports with an As of date can be incomplete. Microsoft Learn
If you change it laterIf all records for a level such as a license plate are deleted, users can no longer see that inventory used to be on hand there. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventCleanupWHSInventSumWithInventDim Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources