Column Filter Show/Hide

Delete

Excel

Favorites

Group By Show/Hide

Help

Mass Update

• Rate: Set the Fixed Cost Rate for many Cost Items at the same time.  This value must be >=0, otherwise the message "Rate cannot be less than 0." will be displayed. 

• Effective Date: A date control used to set the effective date of the cost change.

• Scaling Method: A single-select lookup to assign how the cost item scales on a BOM. The options include By Batch or Variable.

• Cost Offset GL Account: A single-select lookup to assign the GL Account that will be used for the cost portion of item cost amount (typically a credit) when a BOM is used to assign an item cost.

New

Quick Column Filter

Save

Saved Layout

Fields

Description

Checkbox

Cost Item Description 

Identifies the description of the Cost Item.  This is an editable text box that is required, if missing the message "Cost Item Description is required." will be displayed on Save.  It defaults to blank, must be <= 100 characters and is always editable. 

Database Field: ERPx_IMCostItem.CostItemDescription

Cost Item ID

Identifies the unique identifier of the Cost Item. This is an editable text box that is required, if missing the message "Cost Item ID is required." will be displayed on Save. This must be unique by combination of Cost Item ID and UOM else the message "Cost Item ID + UOM must be unique" will be displayed on Save. This allows users to setup the same Cost Item ID both when used by Lbs or Hours. This defaults to blank, must be <= 25 characters and is always editable. 

Database Field: ERPx_IMCostItem.CostItemID

Cost Offset GL Account

The lookup contains the current assigned value and a list of all 'Active' GL Accounts. 

Database Fields: ERPx_GLAccount.AccountNumber: Description, ERPx_IMCostItem.CostOffsetGLAcctSK

Created 

Database Field: ERPx_IMCostItem.CreatedDate

Created By

Database Field: ERPx_IMCostItem.CreatedBy

Effective Date

Identifies the date that the cost Rate became effective. This is a date field that is required, if missing the message "Effective Date is required." will be displayed on Save. It defaults to the current date and is always editable.

Database Field: ERPx_IMCostItem.EffectiveDate

Inactive 

Database Field: ERPx_IMCostItem.IsInactive

Last Updated 

Database Field: ERPx_IMCostItem.LastUpdated

Last Updated By

Database Field: ERPx_IMCostItem.LastUser

Rate

Identifies the current rate of the Cost Item. This is a numeric textbox that is required, if missing the message "Rate is required." will be displayed on Save. It defaults to blank, must be >=0 else the message "Rate cannot be less than 0." is displayed on Save and always editable. 

Database Field: ERPx_IMCostItem.Rate

Scaling Method

Identifies how the quantity of the Cost Item scales on a BOM.  This is a single select lookup that is required, if missing, the message "Scaling Method is required." will be displayed on Save.  This defaults to blank and is always editable. The available options include:

• By Batch: It scales up or down by the batch qty. For example, if the Batch Qty of a cost item was 10 Hours / 1,000 lbs then the cost qty would be 20 hours for any amount of production between 1,001 - 1,999 lbs.

• Variable: It scales up or down in proportion to the batch quantity. For example, if the Batch Qty of a cost item was 10 Hours / 1,000 lbs then the cost qty would be 11 hours if 1,100 lbs were produced.

This lookup contains the values in the BOMScalingMethod Enumeration Class where Enumeration Value = 3, 4. 

Database Field: ERPx_IMCostItem.ScalingMethodEN

UOM

Identifies the Unit of Measure of the Rate.  This is a single select lookup that is required, if missing, the message "UOM is required." will be displayed on Save.  This defaults to blank and is always editable.

The lookup contains the current assigned value and a list of all 'Active' Units of Measure. 

Database Fields: ERPx_IMItem.UOMID, ERPx_IMCostItem.UOMSK