Language:


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 th