BeyondERP.Newsletter
Menu

Job page · Inventory management

Inventory on-hand report data clean up

A periodic job that deletes the stored on-hand data of reports that were run before a given date.

Business process
Manage data
Menu item
action:InventOnhandStorageReportCleanUp
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 the stored on-hand data of reports that were run before a given date.
What you do hereUse this periodic task to remove saved data from old on-hand reports.
Inventory on-hand report data clean up 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 on-hand report data clean up
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 stored data from old Inventory on-hand report runs is no longer needed, at a time when nobody is running that report.
How oftenOn demand, when old report data has piled up. Microsoft gives no fixed interval.
Batch settingsSchedule it at a time when the Inventory on-hand report isn't running.
What the output showsNo report. The stored on-hand data of report runs before the date is deleted. If someone needs an old run, it must be run again; it then shows on-hand as of the new run.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Clean up > Inventory on-hand report data clean up.
  2. Read the warning: don't run the cleanup while the Inventory on-hand report is running.
  3. In Delete inventory on-hand report executed before, enter the newest date to keep. Stored data of reports run before that date is deleted.
  4. Use Records to include to limit which report runs are cleaned up, and set batch options if needed.
  5. Afterwards, open the stored Inventory on-hand report runs: only runs from that date onward still have their data.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Delete inventory on-hand report executed beforeData from reports run before this date is deleted.Microsoft Learn

Test checklist

  1. Report runs from before the date no longer have stored data.
  2. Newer report runs still open.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted report data can't be restored. Run the report again if you need the figures. Microsoft Learn
If you change it laterDeletes the stored on-hand data of Inventory on-hand report runs before the date you enter. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventOnhandStorageReportCleanUp Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itQuality control manager InventQualityControlManagerWarehouse manager WMSWarehouseManagerMaterials manager InventMaterialsManagerQuality control clerk InventQualityControlClerkProduction supervisor ProdProductionSupervisorGive people one of these roles. On this system, 31 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources