Collapse AllExpand All

6.3.1. Post Actual Costs by Item

When you post actual costs you are replacing your existing standard costs with your newer actual costs. The standard cost of an item is the cost used for posting general ledger transactions. Standard cost is distinguished from actual cost in the sense that standard cost is fixed, whereas actual cost is subject to fluctuations arising from material or production changes. For example, the actual costs for purchased items may be updated whenever vouchers are posted for those items. Because standard and actual costs may diverge, posting actual costs to standard is the way you bring the two costs into alignment.

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, posting costs by class code is the generally preferred method. That way you can guarantee all the required costs are posted—and none are missed.

To post actual costs to standard cost individually by item, go to Products > Costing > Post Actual Costs > by Item. The following screen will appear:

Post Actual Costs by Item

Warning

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

When posting 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 post.

UOM

Inventory unit of measure.

Tip

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

Roll Up Standard Costs

Select to roll up standard costs. When this option is specified, all selected costs will be added together to establish a revised total standard cost for the item. This revised total goes into effect after the POST 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 Standard Costs option is not specified, the selected cost postings will not be valid above their current level.

Post Material Costs

Select to post material costs. Not selecting means material costs will not be posted to the standard cost for the item.

Post Lower Level Material Costs

Select to post lower level material costs. Not selecting means lower level material costs will not be posted to the standard cost for the item.

Post Direct Labor Cost

Select to post direct labor cost. Not selecting means the direct labor cost will not be posted to the standard cost for the item.

Post Lower Level Direct Labor Cost

Select to post lower level direct labor cost. Not selecting means the lower level direct labor cost will not be posted to the standard cost for the item.

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.

Post Overhead Cost

Select to post overhead cost. Not selecting means the overhead cost will not be posted to the standard cost for the item.

Post Lower Level Overhead Cost

Select to post lower level overhead cost. Not selecting means the lower level overhead cost will not be posted to the standard cost for the item.

Post Machine Overhead

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

Post Lower Machine Overhead

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

Post User Costs

Select to post user costs. Not selecting means user costs will not be posted to the standard cost for the item.

Post Lower Level User Costs

Select to post lower level user costs. Not selecting means lower level user costs will not be posted to the standard cost for the item.

The following buttons are unique to this screen:

POST

Posts all selected actual costs by item to standard cost. If the option Roll Up Standard Costs has been selected, the total standard cost for the specified item will be updated.

Tip

Actual costs may also be posted to standard cost on an item-by-item basis using the right-click menu found on the Maintain Item Costs screen.

SELECT ALL COSTS

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