Costing Maintenance

---

You can access this form on the Inventory Item Maintenance form, or from the Data Entry menu. Use the form to view and maintain inventory item costs. The details you enter on the form depend on the costing options specified in Module Control. If you have selected the option to record costs at a location level, you can maintain costs by location. If you have selected the option to record costs at a master level, only one cost is maintained, which is applicable to all locations.

The company costing method is defined in Module Control. This applies to all items in the company, and is used to value inventory, calculate the cost of goods sold, and as a basis for pricing where a cost plus pricing method is selected.

The cost displayed defaults to item lines during transaction entry (except where a standard costing method is being used, and the option to Use as default for data entry is not selected in Module Control). If you are costing at a location level, Greentree checks for a location specific cost during transaction entry, using the location that is entered into the transaction line. If a location specific cost is not found, Greentree uses a non-location specific cost, otherwise it defaults to zero.

The number of decimal places of the cost value is determined by the Decimal Unit that is selected in Module Control.

Code/Description

Enter or select the item using either code or description. If you open the form from the IN Maintenance form, these fields will be pre-populated with the selected item in read-only format.

Location

If you are maintaining costs at a location level, select the location that the costs apply to. You can enter this information directly into the table, or into the form field. To create or maintain costs that apply to all locations, other than those specifically entered here, do not enter a location.

This is enabled if you are entering a standard cost - for average and last costs, Greentree generates costs against a empty location.

Unit of measure

This defaults, in read-only format, to the stocking unit of measure for the item.

Average cost

Enter, view or update the average cost on the form field, or into the table. Average cost is calculated by applying the average cost formula - transaction quantity x unit cost - averaged over all transactions for the item.

You can only change the average cost if the option to Allow system cost change is selected in Module Control.

Average cost - Cost date

This is the date that the average cost for this item was last updated.

This is system-generated and read-only.

Last cost

Enter, view or update the last cost on the form field, or into the table. This cost is the cost of the last (increasing effect) transaction for the item.

You can only change the last cost if the option to Allow system cost change is selected in Module Control.

Last cost - Cost date

This is system-generated and read-only. It is the date that the last cost for this item was last updated.

Standard cost

Enter, view or update the cost on the form field, or into the table. Where a standard cost method is being used, you always have to enter/update this cost.

Standard cost - Cost date

This is system-generated and read-only. It is the date that the cost for this item was last updated.

Display active locations only

If you select this option, costs for inactive locations will not appear in the table.

Add new location cost

Click this button if you are maintaining costs at a location level, and want to add a new location cost where you are using the form instead of the table to enter the information.

Table

All costs of the item displays in this table.

• IN Location Maintenance
• IN Control
• Module Control

---