The following describes how to calculate and update cost for several items at the same time through a batch job.
The standard cost is only updated for the selected items if the following is true:
- Item cost type and Work centre price selected in the batch job match the values defined in the MFG control file.
- Status item cost in the Item file is set to 9 (Calculation demands) or BLANK for the item.
- Select the Work with reports/jobs – MFG Basic Data menu item.
- On Work with batch jobs, select PROD_COST and click Submit job.
- You access Product costing selection. Complete the following fields:
- Calculation date
- Enter the calculation date. The calculation must be set to current date if the purpose of the calculation is to update the standard cost on the item.
- Selection
- Indicate how the selection of items to be calculated should be performed by ticking one of the following: All items, Item required for costing or Item selection. Note: If you select Item selection, you will access a panel where you can define what items should be included in the selection.
- Item cost type
- Indicate from where the component prices should be retrieved by ticking one of the following: Average cost, Standard cost, FIFO or Simulation. Note: This value must be equal to that defined in the MFG control file if the standard cost is to be updated in the Item file.
- Work centre price
- Indicate from where the work centres prices should be retrieved during the calculation by ticking one of the following: Standard, Actual or Simulation. Note: This value must be equal to that defined in the MFG control file if the standard cost is to be updated in the Item file.
- Calc cost max dec
- Indicate how many decimals should be used in the basic data product costing. If you set this field to YES, the standard cost will be calculated and displayed with 6 decimals (maximum decimals). If you set this field to NO, the number of decimals defined for the system currency in Work with currencies will be used in the calculation of the standard cost.
- Save costing
- Indicate if the cost calculation should be saved in the Product costing enquiry file.
- Upd base sales price
- Indicate if the base sales price in the Item file should be updated with the new calculated value.
- Calc with std qty PC
- The default value in this field is retrieved from the MFG control file. Indicate if the standard cost should be calculated using the Standard quantity PC instead of the Stock unit from the Item file. If you set this field to YES, the product costing element will be presented according to the standard quantity for PC, but the update to the Item file will be made by stock unit.
- Rounding off
- This field is only mandatory if Upd base sales price is set to YES. Indicate how the base sales price should be rounded off by ticking one of the following: No decimals, One decimal, Two decimals or No rounding off.
- Allowed divergence %
- Enter a value in percentage defining the allowed divergence between the previous standard cost and the calculated standard cost. If, for example, the cost has been changed by 50 % and the allowed divergence is 45 %, no updating will be made to the standard cost price in the Item file or in the Product costing file. Note: To allow all divergences, enter 999.
- Print error rep only
- Indicate if only those items that were not updated should be printed on the report. If you set this field to YES, all calculated items, whether updated or not, will be printed.
- Cost model
- Enter the cost model to be used in the calculation. If this field is left blank the active cost model from the MFG control file will be used.
- Item file
- Product costing enquiry
- Product costing report
Click OK to submit the product costing calculation to the job queue. Exit the routine.
You can view the result in the following: