On-hand entries aggregation by financial dimensions
Cost managementInventory accountingClean up
action:InventSumSummarize
Business process
Manage data
Menu item
action:InventSumSummarize
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 is
A periodic job that rolls up on-hand records with zero quantity and cleans up records that are marked as closed.
What you do here
Use this periodic task to reduce the number of on-hand records and speed up any function that reads them, while inventory value reports still show the same values.
Example
For example, when items use batch numbers, each batch gets its own on-hand record, and once a batch is sold its zero-quantity record can be rolled up to the site level.
The page in Dynamics 365. page title tab to open what to set or check
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 it
When on-hand queries slow down because many batch or serial number records with zero quantity remain in the on-hand table.
How often
On demand, when the number of closed on-hand records has grown again.
Batch settings
Run it in the background outside business hours; on large item ranges it reads the whole on-hand table.
What the output shows
Fewer on-hand records. Values from zero-quantity records are rolled up to the site level, so inventory value reports show the same totals. A changed total per item and site after the run points to a problem and should be raised before you continue.
Go to Cost management > Inventory accounting > Clean up > On-hand entries aggregation by financial dimensions.
Before you start, run an inventory value report for a few items with batch or serial numbers, so you have values to compare with afterwards.
Know what the job does: it finds InventSum records with no open quantities, copies their remaining values to the record for the same item and site, and deletes the lower-level record.
Use Records to include to limit the first run to a few items or one item group, then select OK.
Run the same inventory value report again and check that the value per item and site is unchanged while the number of on-hand records has gone down.
No: Deleted on-hand records can't be restored. Historical and as-of-date reports can show less detail for the periods involved. Microsoft Learn
If you change it later
Historical and "as of date" reports can show incomplete data for periods where on-hand rows were removed. Microsoft Learn
Technical architect
5Technical
Menu item
action:InventSumSummarizeChecked in Dynamics 365
Form
SysOperationTemplateFormChecked in Dynamics 365
Roles to set it up and use it
To use itInformation technology manager SysServerITManagerGive people one of these roles. On this system, 1 role can run this page.Checked in Dynamics 365