Collapse AllExpand All

6.2.1.  Update Actual Costs by Item

Actual costs are the real-time costs associated with an item, including current material and production costs. The actual cost of an item may fluctuate given changes in the cost for materials, or other costs related to changes in bills of materials (BOMs) or routings. For example, the actual costs for purchased items may be updated whenever vouchers are posted for those items. Actual costs provide a current record of costs actually incurred by an item.

Tip

Cost roll ups in xTuple are performed from the bottom up. In other words, to update the costs for a parent item you need to roll the costs for all the child items up into the parent item. For this reason, updating costs by class code is the generally preferred method. That way you can guarantee all the required costs are updated—and none are missed.

To update actual costs individually by item, go to Products > Costing > Update Actual Costs > by Item. The following screen will appear:

Update Actual Costs by Item

Warning

If you are blending the average cost method with the standard cost method, your results may vary.

When updating actual costs by item, you are presented with the following options:

Item Number

Enter the item number of the item whose actual costs you want to update. The lookup feature located to the right of the field leads to a searchable list of make and buy items.

UOM

Inventory unit of measure.

Tip

For manufactured items, rolling up actual costs ensures that lower level costs are reflected in the cost for the parent item.

Roll Up Actual Costs

Select to roll up actual costs. When this option is specified, all selected costs will be added together to establish a revised total actual cost for the item. This revised total goes into effect after the UPDATE button is selected. If all costs are selected, all costs will be rolled up. If a subset of all costs is selected, only the subset will be rolled up. If the Roll Up Actual Costs option is not specified, the selected cost updates will not be valid above their current level.

Update Lower Level Material Costs

Select to update lower level material costs. Not selecting means lower level material costs will not be included in the cost update.

Update Direct Labor Cost

Select to update direct labor cost. Not selecting means the direct labor cost will not be included in the cost update.

Update Lower Level Direct Labor Cost

Select to update lower level direct labor cost. Not selecting means the lower level direct labor cost will not be included in the cost update.

Note

You have the flexibility of updating all or only a subset of the listed costs. Updating a subset might be desirable if only material or user costs have changed, for example.

Update Overhead Cost

Select to update overhead cost. Not selecting means the overhead cost will not be included in the cost update.

Update Lower Level Overhead Cost

Select to update lower level overhead cost. Not selecting means the lower level overhead cost will not be included in the cost update.

Update Machine Overhead

Select to update machine overhead cost. This option is selected by default.

Update Lower Machine Overhead

Select to update lower level machine overhead cost. This option is selected by default.

Update User Costs

Select to update user costs. Not selecting means user costs will not be included in the cost update.

Update Lower Level User Costs

Select to update lower level user costs. Not selecting means lower level user costs will not be included in the cost update.

The following buttons are unique to this screen:

UPDATE

Updates all selected costs for the specified item. If the option Roll Up Actual Costs has been selected, the total actual cost for the specified item will be updated.

SELECT ALL COSTS

Selects all costs for updating. Use this option to save time when selecting all costs for updating. The option Roll Up Actual Costs must be selected separately if you want to include a rolled up total for the parent item in the cost update.