Update Recipes
This function updates the Input Costs and other details of components in Recipes with new prices from the Item register. Before running it, produce a
Recipe Cost Comparison report if you need to see the differences between a Recipe and the details in the Item register.
- Recipe
- Paste Special
Recipe register, Production module
- Range Reporting Alpha
- To update the costs in particular Recipes, enter a Recipe Code or a range of Recipe Codes here.
- Item
- Paste Special
Item register
- Range Reporting Alpha
- To update the costs of particular Items when used as components in Recipes, enter an Item Number or range of Item Numbers here.
- Item Group
- Paste Special
Item Group register, Sales Ledger
- To update the costs of Items belonging to a single Item Group when used as components in Recipes, enter an Item Group Code here.
- Replace in Item with
- Paste Special
Item register
- If you want to update the Recipes by changing an Input Item, specify the new Item here. This Item will replace the one specified in the field above in every Recipe in the range (except Locked Recipes).
- If you enter a range of Items in the field above, no action will be taken. You can only replace one Input Item at a time.
- Update to
- Determine here how the new Input Costs of the components are to be calculated.
- Cost Price
- The new Input Costs are taken from the Cost Prices of the components as shown on the 'Costs' cards of their records in the Item register.
- Unit Stock Value
- The new costs are calculated using the unit stock value of the component Items. This will be calculated using the Cost Model specified in the relevant Item or Item Group record. If that Cost Model is Default, the Primary Cost Model specified in the Cost Accounting setting will be used. This option will therefore use as the new cost the FIFO, LIFO, Weighted Average or other value of an Item, depending on the Cost Model.
- If you use this option, any Service Items used as components in Recipes will have their Input Cost set to zero. This will also be the case for any Stocked Items of which there is no stock.
- If the Recipe has one Out Item
- Use these options to specify whether you would like the cost of the Output Item (as shown in the Recipe) to be updated to reflect the changes made to the costs of the Input Items. These options will only affect Recipes with a single Output row: if there are several Output Items, you should update them manually so that the costs can be apportioned correctly.
- Do not update
- The cost of the Output Item will not be updated.
- Update Out Item Cost
- The cost of the Output Item will be updated.
- Update Out Item Cost and Item's Cost Price
- The cost of the Output Item will be updated, and the Cost Price in its record in the Item register will also be updated.
- If the Output Item is a Structured Item, it is recommended that you do not use this option. Where costs are required (e.g. in gross margin calculations), they will be taken from the Item records of the components. If the Output Item is a Stocked Item, then you should use this option.
- Update Item Descriptions
- Check this box if you would like the names of the Items in the selected Recipes to be updated from the Item register.
Press the [Run] button to start the updating process.
---
Maintenance functions in the Production module:
See also:
Go back to:
