In this article
To set up Cost Redistribution by Dimensions
To run Cost Redistribution by Dimensions
To view the results from Cost Redistribution by Dimensions
Aggregated Inventory tracks the dimensions within the Aggregated Inventory Entries. During Statement Posting, sales across multiple stores are consolidated into a single Item Ledger Entry for the aggregated location.
Each Aggregated Inventory Entry keeps the sold quantity and specific dimensions of each store, while the aggregated Item Ledger Entry holds the total quantity and the Aggregated Location's dimensions. As a result, the inventory costs in the General Ledger (G/L) are tied to the Aggregated Location's dimensions.
To allocate these costs from the aggregated dimensions in the G/L to the individual store dimensions, you can run the Cost Redistribution by Dimensions routine. This routine identifies the relevant G/L accounts, the total amount, and the percentage shares between the stores. It uses the calculated percentage shares to redistribute the total amount from the aggregated dimensions to the detailed store dimensions.
To set up Cost Redistribution by Dimensions
Before executing the Cost Redistribution by Dimensions 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 Cost Redistribution by Dimensions are the following fields:
| Field | Description |
|---|---|
| Period Type | Specifies the period type (By Month or By Week) that the Cost Redistribution routine will use to filter and group the data. |
| No. of Periods | Specifies how many periods will be included, counting from the current period backwards. The Cost Redistribution routine will perform the calculation for each period. |
| Skip Current Period | Specifies if the Cost Redistribution routine should skip the current period (current Month or Week). |
| Gen. Journal Template | Specifies the Gen. Journal Template used to post entries into the G/L. |
| Gen. Journal Batch | Specifies the Gen. Journal Batch used to post entries into the G/L. |
| Allow Direct Posting | Specifies if the Cost Redistribution routine can post directly to any G/L accounts. |
| Cost Redistribution Source Code | Specifies which Source Code is used for the G/L entries posted by the Cost Redistribution routine. |
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 |
|---|---|
| Period Type | Specifies the period type (By Month or By Week) that the Cost Redistribution routine will use to filter and group the data. |
| No. of Periods | Specifies how many periods will be included, counting from the current period backwards. The Cost Redistribution routine will perform the calculation for each period. |
| Skip Current Period | Specifies if the Cost Redistribution routine should skip the current period (current Month or Week). |
| Gen. Journal Template | Specifies the Gen. Journal Template used to post entries into the G/L. |
| Gen. Journal Batch | Specifies the Gen. Journal Batch used to post entries into the G/L. |
| Allow Direct Posting | Specifies if the Cost Redistribution routine can post directly to any G/L accounts. |
| Cost Redistribution Source Code | Specifies which Source Code is used for the G/L entries posted by the Cost Redistribution routine. |
To run Cost Redistribution by Dimensions
To execute the Cost Redistribution routine, follow these steps:
- Click the icon, enter Aggregated Inventory Entries, and select the relevant link.
- Click Actions - Functions - Other - Run Cost Redistribution by Dimensions.
Before running Cost Redistribution by Dimensions, you must first execute the following processes to ensure that item costs are calculated and posted:
- Adjust Cost – Item Entries
- Post Inventory Cost to G/L
- Cost Rollup (AGRI)
To assist you, there is a wizard that guides you through these processes. Follow these steps to use the wizard:
- Click the icon, enter Run Inventory Cost Routines, and select the relevant link.
You can automate this task to run on a regular basis by setting up a scheduler job for Codeunit ID 10059523 LSC AGRI Cost Distribution Mgt. Use the Code parameter to define a location filter. By default, all activated Aggregated Locations are considered for Cost Redistribution by Dimensions.
To view the results from Cost Redistribution by Dimensions
After each execution, the Cost Redistribution routine will log the results so that you can see which periods have been calculated and the related G/L entries.
- Click the icon, enter Aggr. Inventory Dimension Distribution, and select the relevant link.
- Click Related - Entry - Show Related G/L Entries.
See also