BeyondERP.Newsletter
Menu

Job page · Inventory management

Inventory settlements cleanup

A periodic job that groups closed inventory transactions or deletes canceled inventory settlements.

Business process
Manage data
Menu item
action:InventCostCleanUp
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 groups closed inventory transactions or deletes canceled inventory settlements.
What you do hereUse this periodic task to free system resources by grouping or deleting old settlement data.
Inventory settlements 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 settlements cleanup
Used next byInventory transaction consolidation 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 itOnly after the business has confirmed that settlement detail before the chosen dates is no longer needed. If you also plan Inventory transaction consolidation, run this cleanup first.
How oftenOn demand, when old settlement data needs to be reduced. Microsoft gives no fixed interval for this routine.
Batch settingsRun it as a batch job after testing it in a test environment, as Microsoft recommends for every cleanup routine.
What the output showsGrouped settlements for closed transactions and deleted canceled settlements before the dates you entered. There is no report; if inventory no longer reconciles with finance for a period, the dates were set too close to the present.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Inventory management > Periodic tasks > Clean up > Inventory settlements cleanup.
  2. In Group settlements posted before, enter the date before which the settlements of closed inventory transactions are grouped. Keep it well away from the current date and fiscal year, because grouped transactions lose part of their settlement detail.
  3. To remove canceled inventory settlements, set Delete canceled settlements posted before to the cut-off date. Leave either date empty when you only want the other action.
  4. Use Records to include to limit which settlement records the run covers, and run it in the background when the backlog is large.
  5. Afterwards, open the inventory settlements for an old closed transaction: settlements before the group date are grouped, and canceled settlements before the delete date are gone.

Source: Microsoft Learn

Fields on the page

FieldWhat it means
Group settlements posted beforeClosed transaction settlements posted before this date are grouped.Microsoft Learn
Delete canceled settlements posted beforeCanceled settlements before this date are deleted.Microsoft Learn

Test checklist

  1. Settlements of closed transactions before the group date appear grouped.
  2. Canceled settlements before the delete date no longer appear.
  3. Settlements after both dates are unchanged.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneNo: Grouped settlements can't be split again and deleted canceled settlements can't be restored or reconciled with finance transactions. Test the routine in a test environment first. Microsoft Learn
If you change it laterGrouped closed transactions can no longer be changed, and deleted canceled settlements can't be reconciled with finance transactions. Microsoft Learn
Technical architect

5Technical

Menu itemaction:InventCostCleanUp Checked in Dynamics 365
FormDialog Checked in Dynamics 365
Roles to set it up and use itTo use itInventory accountant InventCostAccountantInformation technology manager SysServerITManagerGive people one of these roles. On this system, 2 roles can run this page.Checked in Dynamics 365
Developer

6Developer

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

7Sources