BeyondERP.Newsletter
Menu

Job page · Cost management

Inventory value report data clean up

A periodic task that deletes stored inventory value reports that were run before a selected date.

Business process
Manage data
Menu item
action:InventValueReportTempBufferCleanUp
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 task that deletes stored inventory value reports that were run before a selected date.
What you do hereUse this task to delete several older inventory value reports at the same time, so that stored reports do not take up too much space in the database.
Inventory value 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 pathCost management › Inventory accounting › Clean up › Inventory value report data clean up
Related pagesInventory value report storage 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 stored inventory value reports take up too much database space and the older ones are exported and archived.
How oftenOn demand; Microsoft notes that you typically run this job manually each time it's needed.
Batch settingsYou can schedule it on the Run in the background FastTab, but normally run it once by hand after the export is done.
What the output showsStored inventory value reports generated before the date are removed from Inventory value report storage. A report still listed after the run was generated on or after the date, or was excluded by the filter.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Cost management > Inventory accounting > Clean up > Inventory value report data clean up.
  2. First export every stored inventory value report you plan to delete through the Inventory value report storage data entity and keep the file outside the system.
  3. In Delete inventory value report executed before, select the date before which all stored inventory value reports are deleted.
  4. On the Records to include FastTab, select Filter to narrow the set of reports, for example by report name, then select OK.
  5. Open Inventory value report storage and check that only reports generated before the date are gone.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Delete inventory value report executed beforeThe date before which all stored inventory value reports are deleted.Microsoft Learn

Test checklist

  1. An export file exists for every deleted report.
  2. Reports generated after the date are still listed in Inventory value report storage.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted reports can't be restored, and you might not be able to generate them again for old periods because the system may time out working back through the transactions. Export them first. Microsoft Learn
If you change it laterDeleted inventory value reports might not be possible to generate again later, so export them before you delete them. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventValueReportTempBufferCleanUp
Roles to set it up and use itTo use itInventory accountant InventCostAccountantInventory accountant clerk InventCostCostClerkAccounting manager LedgerAccountingManagerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources