In this article
Aggregated Inventory keeps track of the cost and sales amount in the Aggregated Inventory Entries. Aggregated Inventory Entries are first inserted with the expected cost and sales amount. To sync the cost and sales information with the Item Ledger Entries and the Value Entries, you can run the Unit Cost Rollup routine. This routine updates the expected and actual cost and sales amount in the Aggregated Inventory Entries with the latest information from the linked Item Ledger Entries and Value Entries.
Each execution saves the last processed Value Entry No. for each Aggregated Location. The next execution will start from that point and only consider the newer Value Entries.
To set up Unit Cost Rollup
Before executing the Unit Cost Rollup routine, you need to complete the required settings.
Follow the steps below to complete the setup on the Retail Setup:
- Click the
icon, enter Retail Setup, and select the relevant link.
- Open the Aggregated Inventory FastTab. Under the section Unit Cost Rollup are the following fields:
| Field | Description |
|---|---|
| Commit Buffer | Specifies after how many processed records the Unit Cost Rollup routine would commit the changes to the database. |
| Timeout Duration (min) | Specifies after how many processing minutes the Unit Cost Rollup routine would force a timeout. |
Follow the steps below to complete the setup on the Location card:
- Click the icon, enter Location, and select the relevant link.
- Open the Aggregated Inventory FastTab that has the following fields:
| Field | Description |
|---|---|
| Unit Cost Rollup Active | Specifies whether the Unit Cost Rollup is active for this specific location. Only Aggregated Locations can be activated. |
To run Unit Cost Rollup
To execute the Unit Cost Rollup routine, follow these steps:
- Click the icon, enter Aggregated Inventory Entries, and select the relevant link.
- Click Actions - Functions - Other - Run Unit Cost Rollup.
You can automate this task to run on a regular basis by setting up a scheduler job for Codeunit ID 10059520 LSC AGRI Cost Rollup Mgt.. Use the Code parameter to define a location filter. By default, all activated Aggregated Locations are considered for Unit Cost Rollup.
See also
Cost Redistribution by Dimensions