Items List View

 The purpose of this page is to view existing items. From here you have the options to add, edit, and activate/inactive these records.

 

Items are often referred to as: Item ID's, Products, Product Codes, and SKU's.

 This list view also contains columns for each Attribute that is set up for the 'Items' attribute type. Additionally, this list view also contains columns for each Lot Certification. However, because these attributes and lot certifications are user defined, they are not included in the help documentation.

Software Version: 2023.09.15 and newer

Page Header

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Copy

Opens the "Item Copy" dialog allowing users to copy existing items.  During the Copy, users can determine if the Item Accounts, Attributes and Certifications are copied alongside with the Item properties.  The "Item Copy" dialog window also allows users to enter UPC and GTIN IDs for the new item.

Delete

Click to see list of database tables and fields audited during the delete.

Edit

Excel

Favorites

Group By Show/Hide

Help

Mass Update

 

  • Item Attributes: A list of Attributes set up as the 'Items' attribute type.

  • Item Properties: Expiration Days - Allows users to update the Expiration Days for Lot Tracked items. The value must be greater than or equal to 0.

New

Quick Column Filter

Refresh

Saved Column Layout

Fields

Description

Checkbox

Actual Cost

 This is not required and can always be edited from the 'Actual Cost' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.CurrentCost

Allow Variable Ordered Wt.

Identifies whether or not the item is allowed to be ordered, in a variable weight, on sales order transactions. This is required and can always be edited from the 'Allow Variable Ordered Weight' property on the 'Advanced Properties' tab of the Item Record View.

The field can only be set to "Yes" when the 'Variable Weight' field is set to "Yes".  For example, if a variable weight item has a target weight of 10 lb / case and this Property is set to "No", it must be ordered in 10 lb increments, if it is set to yes, it can be ordered in any increment. This setting does not impact how it can be allocated, only how it can be ordered. 

Database Field: ERPx_IMItem.AllowVariableOrderedQty

Bar Code Label Description

Displays the description to be used for Item labels. This is not required and can always be edited from the 'Bar Code Label Description' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.BarCodeLabelDescription

Cost Group ID

 This is is not required and can always be edited from the 'Cost Group ID' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMCostGroup.CostGroupID, ERPx_IMCostGroup.CostGroupDescription, ERPx_IMItem.CostGroupSK

Cost UOM

 This is not required and can always be edited from the 'Cost UOM' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.CostUOMSK

Costing Method

Displays how the cost of the item is valued, such as by Item, Lot, etc. This field is required. It can only be edited if the item is lot tracked. If editable, this can be updated from the 'Costing Method' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.ValuationMethodEN

Expiration Days

This is not required and for Lot Tracked items it can be edited from the 'Expiration Days' field on the 'Advanced Properties' tab of the Item Record View, for all other items this is not editable.  

Database Field: ERPx_IMItem.ExpirationDays

GL-Brokerage Accrual

This is not required and can always be edited from the 'Brokerage Accrual (Credit)' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.BrokerageAccrualActSK

GL-Brokerage Expense

This is not required and can always be edited from the 'Brokerage Expense (Debit)' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.BrokerageExpActSK

GL-Brokerage Write Off

This is not required and can always be edited from the 'Brokerage write Off' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.BrokerageWriteOffActSK

GL-Cost of Goods Sold

This is not required and can always be edited from the 'Cost of Goods Sold' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.COGSActSK

GL-Depreciation

This is not required and can always be edited from the 'Depreciation' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.DepreciationActSK

GL-Inventory Adjustments

This is not required and can always be edited from the 'Inventory Adjustment' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InvOffsetActSK   

GL-Inventory Balance Sheet

This is not required and can always be edited from the 'Inventory Balance Sheet' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSK

GL-Purchases

 This is not required and can always be edited from the 'Purchases' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.PurchaseGLAccountSK

GL-Sales

 This is not required and can always be edited from the 'Sales' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.SalesActSK

GL-Sales Freight Accrual

This is not required and can always be edited from the 'Sales Freight Accrual (Credit)' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.FreightAccrualCreditActSK

GL-Sales Freight Expense

This is not required and can always be edited from the 'Sales Freight Expense (Debit)' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.FreightAccrualDebitActSK

GL-Sales Freight Revenue

This is not required and can always be edited from the 'Sales Freight Revenue (Credit)' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.FreightRevenueActSK

GL-Sales Return

This is not required and can always be edited from the 'Sales Returns' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.SalesReturnsActSK

GL-Transfer Freight Accrual

 This is not required and can always be edited from the 'Transfer Freight Accrual (Credit)' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.TransferFrtAccrualGLAccountSK

GL-Transfer Freight Expense

This is not required and can always be edited from the 'Transfer Freight Expense (Debit)' field on the 'GL Accounts' tab of the Item Record View.

Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.TransferFrtExpenseGLAccountSK

Gross Pallet Wt.

Displays the gross pallet weight of the item, as calculated per the shipping weight and Pallet Configuration assigned to the item. This is not required. This field is never directly editable by the user, but can be updated by changing the 'Shipping Weight' field or selecting a different 'Pallet Configuration' on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.GrossPalletWeight

GTIN

Identifies the Global Trade Item Number for the item. This is not required and can always be edited from the 'GTIN' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.GTIN

Hold Code - New Lots

Identifies the hold code to be assigned to an inventory lot when a new lot is created with the item. This is not required and can be edited from the 'Hold Code - New Lots' field on the 'Advanced Properties' tab of the Item Record View for Lot Tracked Items.

Database Field: ERPx_IMItem.LotHoldNew

Hold Code - Sales Returns

Identifies the hold code to be assigned to an inventory lot when a sales return is created with the item. This is not required and can always be edited from the 'Hold Code - Sales Returns' field on the 'Properties' tab of the Item Record View for Lot Tracked Items.

Database Field: ERPx_IMItem.LotHoldReturn

Inactive

Identifies whether the item is active. This is required and can always be edited from the 'Inactive' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.IsInactive

Inventory - Units

This is the item's unit UOM that inventory balances are stored in. It is also the default unit UOM used when the item is entered on transactions keyed in the Inventory Functional Area. This is not required and can always be edited from the 'Inventory - Units' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMUOM.UOMID, ERPx_IMItem.DefaultIMUnitUOMSK

Inventory - Weight

 This is the item's weight UOM that inventory balances are stored in. It is also the default weight UOM used when the item is entered on transactions keyed in the Inventory Functional Area. This is not required and can always be edited from the 'Inventory - Weight' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMUOM.UOMID, ERPx_IMItem.DefaultIMWeightUOMSK

Item Attribute Class

This is not required and can always be edited from the 'Item Attribute Class' field on the 'Properties' tab of the Item Record View.

Database Fields: ERPx_MFAttributeClass.ClassDescription, ERPx_IMItem.AttributeClassSK

Item Class

This is required and can always be edited from the 'Item Class Description' field on the 'Properties' tab of the Item Record View.

Database Fields: ERPx_IMItemClass.ClassID, ERPx_IMItemClass.Description, ERPx_IMItem.ItemClassSk

Item Description

 This is required and can always be edited from the 'Item Description' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.ItemDescription

Item ID

Clicking on the link opens the Item Record View for the selected record. This field is required and can be edited from the Record View in systems that do not integrate "Item setup" with a third party system.

 Careful consideration should be given before changing Item ID's.

Database Field: ERPx_IMItem.ItemID

Item Type

 This is required and not editable after initial Save.

Database Fields: ERPx_IMItemType.Description, ERPx_IMItem.ItemTypeSK

Lot Tracked

This field is required and can always be edited for Items with an 'Item Type' of "Inventory" from the 'Lot Tracked' field on the 'Advanced Properties' tab of the Item Record View. 

Database Fields: ERPx_IMItemClass.TrackMethodEN, ERPx_IMItem.ItemClassSk

Manage Items By

This is required and can be edited from the 'Manage Items By' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.ManageItemsByEN

Market Cost

 This is not required and can always be edited from the 'Market Cost' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.CurrentCost

Min Actual Cost Margin Pct.

Identifies the minimum margin % allowed when selling the item on a Sales Order. This defaults to "0.0000" and is always editable from the 'Market Cost' field on the 'Advanced Properties' tab of the Item Record View..

Database Field: ERPx_IMItem.MinMarginPercent

Pallet Configuration

Displays the name of the pallet configuration to which the item is assigned. This is not required and can always be edited from the 'Minimum Actual Cost Margin Percent' field on the 'Advanced Properties' tab of the Item Record View.

Database Fields: ERPx_IMPalletConfiguration.PalletConfigurationDescription, ERPx_IMItem.PalletConfigurationSK

Price Decimals

 This is required. It can only be edited, if the item has no transaction history, from the 'Price Decimals' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.CurrencyDecimals

Production Batch Class

Displays the default Production Batch Attribute Class associated with an Item. This is not required and can always be edited from the 'Production Batch Class' field on the 'Advanced Properties' tab of the Item Record View.

Database Fields: ERPx_MFAttributeClass.ClassDescription, ERPx_IMItem.ProductionBatchClassSK

Purchases

 This field is not required. It can always be edited from the 'Purchases' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.PurchaseUOMSK

Quality Test Class

Displays the default Quality Test Attribute Class associated with an Item. This is not required and can always be edited from the 'Quality Test Class' field on the 'Advanced Properties' tab of the Item Record View.

Database Fields: ERPx_MFAttributeClass.ClassDescription, ERPx_IMItem.QualityTestClassSK

Reporting

Displays the default reporting Unit of Measure (Lbs, kgs, Cases, etc.) of the item. This is not required and can always be edited from the 'Reporting' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMUOM.UOMID, ERPx_IMItem.DefaultReportingUOMSK

Req. Whole Units

This is required and can always be edited from the 'Required Whole Units' field on the 'Advanced Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.RequireWholeUnits

Sales - Price 

 This field is not required. It can always be edited from the 'Sales - Price' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.DefaultSOPriceUOMSK

Sales - Units

This is the item's default unit UOM within the Sales functional area. This is not required and can always be edited from the 'Sales - Unit' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.DefaultSOUnitUOMSK

Sales - Weight

This is the item's default weight UOM within the Sales functional area. This is not required and can always be edited from the 'Sales - Weight' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.DefaultSOWeightUOMSK

Sales Invoice Description

Displays the description for the Item that will appear on Sales Orders and Invoices. This field is required and can always be edited from the 'Sales Invoice Description' field on the 'Properties' tab of the Item Record View.

Database Field: ERPx_IMItem.SalesInvoiceDescription

Shipping Description

Displays the description for the item that will appear on Export Shipping documentation. This field is required. It can always be edited from the 'Shipping Description' field on the 'Properties' tab of the Item Record View.