BeyondERP.Newsletter
Menu

Job page · Inventory management

On-hand entries cleanup

A periodic job that deletes closed and unused on-hand entries for items that use one or more tracking dimensions.

Business process
Manage data
Menu item
action:InventCleanupTrackingInventSum
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 closed and unused on-hand entries for items that use one or more tracking dimensions.
What you do hereUse this periodic task to make on-hand inventory queries run faster.
On-hand entries 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 › On-hand entries 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 queries for items with tracking dimensions slow down because of many closed, zero on-hand entries.
How oftenOn demand or as a recurring batch job. Microsoft gives no fixed interval.
Batch settingsRun it as a recurring batch job so closed entries are removed regularly, and test it first in a test environment.
What the output showsFewer on-hand rows for items with tracking dimensions: closed entries whose quantities and cost values are all zero are deleted. On-hand for items without tracking dimensions is never touched. Gaps in past-date reports point to entries this job removed.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Clean up > On-hand entries cleanup.
  2. In Delete if not updated for this many days, enter how long a closed on-hand entry must stay unchanged before it's deleted (the default is 7). Entries that change during that period are kept.
  3. Before you run it, agree with the people who use the Physical inventory by inventory dimension report, because the job can remove data that report needs for past dates.
  4. Use Records to include to limit which on-hand entries are considered, and set batch options under Run in the background.
  5. Afterwards, open on-hand for an item with batch or serial tracking: open quantities and values are the same, and only closed entries with zero quantity and cost are gone.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Delete if not updated for this many daysClosed entries that haven't changed for this many days are deleted; the default is 7.Microsoft Learn

Test checklist

  1. Open on-hand quantities for tracked items are unchanged.
  2. Closed zero entries older than the day limit are gone.
  3. Entries changed within the day limit are still there.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted on-hand entries can't be restored, and reports for past dates can show incomplete data for the periods they covered. Microsoft Learn
If you change it laterHistorical and "as of date" reports can show incomplete data for periods where on-hand rows were removed. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventCleanupTrackingInventSum 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:InventCleanupTrackingInventSum
Everyone

7Sources