Batch Item Standard Cost Calculation Request Page
Access the Batch Item Standard Cost Calculation batch job from the Tell Me feature. Choose the
icon, enter Batch Item Standard Cost Calculation, and then choose the related link.
The Batch Item Standard Cost Calculation request page defines which information is used to create the calculations. Considering that this batch job is automating the creation and processes of the calculations, most of the fields in the request page are the same as in the General FastTab of the Calculation Card.
Options FastTab
The fields on the Options FastTab are described in the following table.
| Field | Description |
|---|---|
| Default Price Source for Items | Determines whether the value of the Price Source for Items field in the calculation schedules assigned to items is used to create the Calculations. |
| Price Source for Items | Specifies the Price Source for Items value that will be used for all Calculations created by the Batch Item Standard Cost Calculation when the Default Price Source for Items toggle is turned off. The options are Item Unit Cost and Purchase Pricing. |
| Default Price Source for Capacities | Determines whether the value of the Price Source for Capacities field in the calculation schedules assigned to items is used to create the Calculations. |
| Price Source for Capacities | Specifies the Price Source for Capacities option that will be used for all Calculations created by the Batch Item Standard Cost Calculation when the Default Price Source for Capacities toggle is turned off. The options are Unit Cost and Direct Unit Cost. |
| Multi-Level Calculation | Determines whether Calculations created by the Batch Item Standard Cost Calculation process should be performed as multi-level calculations. |
| Update Stockkeeping Units | Determines whether the standard costs of stockkeeping units should be updated by the Batch Item Standard Cost Calculation process. |
| Show Batch Calculation Log | Determines whether the Batch Calculation Log is opened after the batch calculation is completed. |
Enhanced Options FastTab
The fields on the Enhanced Options FastTab are described in the following table.
| Field | Description |
|---|---|
| Calculation Mode | Specifies how the batch process handles existing calculations. The options are Overwrite Existing Calculation (updates existing calculations directly) and Create New Certified Calculation (creates new certified calculations and expires previous ones). For more information, see Calculation Modes. |
| Enable Revaluation | Determines whether the standard Revaluation Journal should be automatically populated with calculation results. Users must review and post the journal lines manually. For more information, see Revaluation Journal Integration. |
| Journal Template Name | Specifies the name of the journal template to be used for storing batch calculation results. Required when Preview Mode is enabled. |
| Preview Mode | Determines whether calculation results should be stored in the Batch Calculation Journal for preview before application. When enabled, calculations receive the Simulated status. For more information, see Preview Functionality. |
| Show Preview Journal | Determines if the Batch Calculation Journal is opened when the batch job is set to run in Preview Mode. |
Calculation Modes
The Calculation Mode field provides two distinct approaches for managing calculations:
Overwrite Existing Calculation
When selected, the batch process updates existing calculations directly. If a calculation with matching settings already exists for an item or stockkeeping unit, the system reuses and updates it with new values. This mode is suitable when you want to refresh current calculations without creating additional calculation history.Create New Certified Calculation
When selected, this mode creates new certified calculations for processed items and stockkeeping units. When the batch job is run, the system automatically expires previous calculations, maintaining a traceable cost history. This mode is recommended when you need to preserve calculation history and maintain an audit trail of cost changes over time.
Revaluation Journal Integration
When the Enable Revaluation toggle is enabled, the standard Revaluation Journal is automatically populated with calculation results. This integration streamlines the inventory revaluation process by transferring calculated costs directly to the standard Business Central workflow. Users must review the revaluation journal lines and manually post them according to standard Business Central procedures.
Preview Functionality
When the Preview Mode toggle is enabled, a preview workflow allows you to review calculation results before applying them.
- When enabled, all calculation results are stored in the specified Batch Calculation Journal.
- Calculations receive the Simulated status and are not immediately applied.
- Users can review the journal entries and decide whether to apply or discard the results.
- If journal lines are deleted without applying results, the related calculations receive the Deleted status and remain in the Calculations list for manual removal.
- Deleted calculations cannot be used for further processing.
This workflow provides an additional verification step before committing cost changes to items and stockkeeping units.
Filter FastTab
In the Filter FastTab, items can be filtered by various predefined fields, namely No., Costing Method, Inventory Posting Group, Replenishment System, and Standard Calc. Schedule No.. Other field filters can be added as needed.
Note
The behavior of existing batch calculations depends on the selected Cost Calculation Mode. When using Overwrite Existing Calculation, matching calculations are reused and updated. When using Create New Certified Calculation, new calculations are created regardless of existing ones. It is advisable to use filters when running the Batch Item Standard Cost Calculation batch job.
Scheduling
The Schedule button utilizes the standard scheduling feature of Business Central, which allows you to schedule when the Batch Item Standard Cost Calculation batch job runs.
For information about scheduling with the job queue in Business Central, see the article in Microsoft Learn.
Run the Batch Process
After entering the options, filters, and any scheduling requirements, choose the OK button to run the batch process. The batch process executes in the following order:
Only items with Type = Inventory are processed. Items without a Calculation Schedule or with an invalid schedule code will not be included.
For each item within the filter, a Calculation is created based on the item's Calculation Schedule. If a calculation with matching settings already exists for an item/stockkeeping unit, it is reused. All calculations are marked as Batch Item Standard Cost Calculation (visible in the Calculations page and on the Document FastTab of the Calculation Card by choosing Show more).
The calculation processing workflow depends on whether the Preview Mode option is enabled or disabled:
- Enabled: Calculations receive the Simulated status and results are stored in the Batch Calculation Journal for review. Users must then approve journal lines to apply the calculations or delete lines to discard them.
- Disabled: Calculations are immediately applied according to the selected Calculation Mode (Overwrite Existing Calculation or Create New Certified Calculation).
Stockkeeping units are updated according to the parameters set for transferring the standard cost to the stockkeeping unit.
Depending on the setting of the Show Batch Calculation Log field, the Batch Calculation Log will open after the process completes.
Feedback
Submit feedback for this page .