BeyondERP.Newsletter
Menu

Job page · Inventory management

Transfer order update history cleanup

A periodic job that deletes the update history records that are created when transfer orders are posted.

Business process
Manage data
Menu item
action:InventTransferParmCleanUp
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 update history records that are created when transfer orders are posted.
What you do hereUse this periodic task to improve the performance of functions that read the transfer order update history.
Transfer order update history 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 › Transfer order update history 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 itWhen posting transfer orders, or reading their update history, becomes slow because the update history tables are large.
How oftenOn demand or as a recurring batch job. Microsoft gives no fixed interval.
Batch settingsRun it as a recurring batch job so the update history tables stay small.
What the output showsNo report. Update history records that were created when transfer orders were posted, up to the Created until date, are deleted from the three InventTransferParm tables. Posted transfer orders and their inventory transactions are not affected.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Clean up > Transfer order update history cleanup.
  2. Under Parameters, enter the Created until date. Update history created up to that date is cleaned up.
  3. In Clean up, select which update history records the run should remove.
  4. Set batch options under Run in the background when the history is large.
  5. Afterwards, post a transfer order shipment or receipt as usual; posting works the same, and old records in InventTransferParmTable, InventTransferParmUpdate and InventTransferParmLine are gone.

Source: Microsoft Learn

Test checklist

  1. Transfer order posting still works.
  2. Update history before the Created until date is gone.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Deleted update history can't be restored. The posted transfer orders themselves stay. Microsoft Learn
If you change it laterDeletes transfer order posting history from the InventTransferParmTable, InventTransferParmUpdate and InventTransferParmLine tables. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventTransferParmCleanUp Checked in Dynamics 365
FormSysOperationTemplateForm Checked in Dynamics 365
Roles to set it up and use itTo use itWarehouse worker WMSWarehouseWorkerRetail service RetailServiceRetail store manager RetailStoreManagerInformation technology manager SysServerITManagerGive people one of these roles. On this system, 4 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources