BeyondERP.Newsletter
Menu

Job page · Inventory management

Inventory dimensions cleanup

A periodic job that deletes inventory dimension combinations that are defined but not used in the current company.

Business process
Manage data
Menu item
action:InventUnusedDimCleanUp
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 inventory dimension combinations that are defined but not used in the current company.
What you do hereUse this periodic task to keep the inventory dimensions table small by removing combinations that nothing refers to.
Inventory dimensions 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 › Inventory dimensions cleanup
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 itOnly with a good reason, for example when the InventDim table has grown large with combinations nothing refers to, and after the business has confirmed they're not needed.
How oftenRarely, on demand. Microsoft warns against running it without a good reason.
Batch settingsSchedule it as a batch job outside business hours, because it reads purchase lines, sales lines, inventory transactions and on-hand records for every combination it considers.
What the output showsNo report and no log. Unused InventDim records created in the date range are deleted. If the same combination is used again later, the system creates a new record with a new InventDimId, so a new ID on a later transaction is expected.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Clean up > Inventory dimensions cleanup.
  2. Read the warning under Parameters: every inventory dimension combination created in the date range that is defined but not used in the current company is deleted for good, and no alert or database log is created.
  3. Enter the Clean up after and Clean up before dates and times to set the creation date range the job looks at. A narrow range limits how many combinations can be removed.
  4. Schedule it to run in the background outside business hours, as Microsoft advises for this job.
  5. Afterwards, open some open orders and on-hand records from the range: they keep their dimensions, because combinations that are still referenced are never deleted.

Source: Microsoft Learn

Test checklist

  1. Open orders and on-hand in the date range still show their dimensions.
  2. New transactions with a removed combination get a new InventDimId without errors.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted dimension combinations can't be restored and no log is kept. Run it only with good reason and outside business hours. Microsoft Learn
If you change it laterUnused dimension combinations are deleted for good and no log is kept, so run the job only with good reason and outside business hours. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventUnusedDimCleanUp Checked in Dynamics 365
FormDialog 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:InventUnusedDimCleanUp
Everyone

7Sources