BeyondERP.Newsletter
Menu

Job page · Cost 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 pathCost management › Inventory accounting › 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 when the inventory dimensions table has grown with unused combinations and you have a clear reason to clean it, after a trial run in a test environment.
How oftenRarely, on demand; Microsoft advises not to run it without a good reason.
Batch settingsRun it as a scheduled batch job outside business hours, as Microsoft recommends.
What the output showsUnused inventory dimension combinations in the chosen range are removed from the InventDim table. Combinations referenced by order lines, inventory transactions or on-hand records stay. If the same combination is needed again later, the system creates a new record with a new InventDimId.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inventory accounting > Clean up > Inventory dimensions cleanup.
  2. Read the warning under Parameters: every inventory dimension combination that is defined but not used in the current company is deleted for good, and no alert or database log is created.
  3. Enter Clean up after and Clean up before to target only the dimension combinations that were created in that date and time range.
  4. Schedule it under Run in the background for a time outside business hours, then select OK.
  5. Compare the number of inventory dimension records before and after the run, and open a few orders and on-hand records to see that dimensions still in use are intact.

Source: Microsoft Learn

Test checklist

  1. Open purchase lines, sales lines and on-hand records still show their dimensions.
  2. Only combinations created between the two dates were removed.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted dimension combinations can't be restored and nothing is logged. Run it only after testing, with a narrow date range. 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