Items List View
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 |
---|---|
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 |
|
New | |
Quick Column Filter | |
Refresh | |
Saved Column Layout | |
Fields | Description |
Checkbox | |
Actual Cost |
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 |
Database Field: ERPx_IMCostGroup.CostGroupID, ERPx_IMCostGroup.CostGroupDescription, ERPx_IMItem.CostGroupSK |
Cost UOM |
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 |
Database Field: ERPx_IMItem.ExpirationDays |
GL-Brokerage Accrual |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.BrokerageAccrualActSK |
GL-Brokerage Expense |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.BrokerageExpActSK |
GL-Brokerage Write Off |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.BrokerageWriteOffActSK |
GL-Cost of Goods Sold |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.COGSActSK |
GL-Depreciation |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.DepreciationActSK |
GL-Inventory Adjustments | Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InvOffsetActSK |
GL-Inventory Balance Sheet |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.InventoryActSK |
GL-Purchases |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.PurchaseGLAccountSK |
GL-Sales |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.SalesActSK |
GL-Sales Freight Accrual |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.FreightAccrualCreditActSK |
GL-Sales Freight Expense |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.FreightAccrualDebitActSK |
GL-Sales Freight Revenue |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.FreightRevenueActSK |
GL-Sales Return | Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.SalesReturnsActSK |
GL-Transfer Freight Accrual |
Database Fields: ERPx_GLAccount.AccountNumber, ERPx_GLAccount.Description, ERPx_IMItem.TransferFrtAccrualGLAccountSK |
GL-Transfer Freight Expense |
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 |
Database Field: ERPx_IMUOM.UOMID, ERPx_IMItem.DefaultIMUnitUOMSK |
Inventory - Weight |
Database Field: ERPx_IMUOM.UOMID, ERPx_IMItem.DefaultIMWeightUOMSK |
Item Attribute Class |
Database Fields: ERPx_MFAttributeClass.ClassDescription, ERPx_IMItem.AttributeClassSK |
Item Class |
Database Fields: ERPx_IMItemClass.ClassID, ERPx_IMItemClass.Description, ERPx_IMItem.ItemClassSk |
Item Description |
Database Field: ERPx_IMItem.ItemDescription |
Item ID |
Careful consideration should be given before changing Item ID's. Database Field: ERPx_IMItem.ItemID |
Item Type |
Database Fields: ERPx_IMItemType.Description, ERPx_IMItem.ItemTypeSK |
Lot Tracked |
Database Fields: ERPx_IMItemClass.TrackMethodEN, ERPx_IMItem.ItemClassSk |
Manage Items By |
Database Field: ERPx_IMItem.ManageItemsByEN |
Market Cost |
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 |
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 |
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 |
Database Field: ERPx_IMItem.RequireWholeUnits |
Sales - Price |
Database Field: ERPx_IMItem.DefaultSOPriceUOMSK |
Sales - Units |
Database Field: ERPx_IMItem.DefaultSOUnitUOMSK |
Sales - Weight |
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. |