Items represent objects that you sell, produce, and/or purchase that are tracked within the system. They are used on Sales, Inventory, Fisherman Accounting and Purchasing transactions. The purpose of this page is to add new items and/or update properties, attributes, default GL Accounts, and item certifications may be specified. This record view also supports adding/editing Notes and copying items.
Items are often referred to as: Item ID's, Products, Product Codes, and SKU's.
Software Version: 2023.04.28 and newer
Page Header
Toolbar Icons | Description |
---|---|
Copy | Opens the Item Copy dialog to assist users in copying existing items to create new items in the system. Users may set Item Accounts, Attributes and Certifications to be copied, in addition to the Item properties. The Item Copy dialog window also allows users to enter UPC and GTIN values for the new item. |
New | Opens a new blank record for data entry. |
Notes | Opens the Notes dialog, filtered for the appropriate Note Type(s). From here, users can add, review, or edit Notes associated with the record. This icon is always enabled. |
Save | Saves the changes made to the record. |
Save & Close | Saves your changes and closes the page. |
Fields | Description |
Item | Identifies the Item, displayed as Item ID: Item Description. This is a single-select standard lookup that is required. When setting up a new item, this field defaults to blank and is disabled. When editing an existing item, this field displays as the [Item ID]: ['Item Description] for the Item in Record View. Selecting another item will reload the page for the associated Item. This field is always editable if it is enabled. The lookup contains a list of all Items in the Items Master File. Database Fields: ERPx_IMItem.ItemID, ERPx_IMItem.ItemDescription |
Page Detail
Grid Toolbar
Toolbar Icons | Description |
---|---|
Excel | Exports the contents of the grid to an Excel file that will automatically download. The contents that export are those that are visible to the user. Therefore, if the user has filtered the view, or excluded columns, only the contents in the grid will be exported. |
Help | Opens the online WIKI help page for the current page. |
Quick Column Filter | Used to filter across all columns in the grid. When the user types text into the Quick Column Filter text box, the grid's Filter Row will be automatically hidden. The text in the Quick Column Filter text box automatically replaces any existing Filter Row filters. The results of the data immediately refresh as you enter text. |
Properties Tab
Fields | Description |
---|---|
ID & Description | |
Item ID | Item IDs are the unique identifier for Items. This is a text box that defaults as blank, is required, must be unique, and must be <= 50 characters. If missing, the message "Item ID is required." will be displayed on Save. If not unique the message "Duplicate Item ID's are not allowed." will be displayed on Save. This is only enabled and editable in systems that do not integrate "Item setup" with a third party system. To be editable, the "Item" Transaction Type on both the 'Inbound to NorthScope' and 'Outbound from NorthScope' Integration Modes must be set to "None" on the Integration Configuration page. Careful consideration should be given before changing Item ID's. Database Fields: ERPx_IMItem.ItemID |
Item Description | Identifies the Description associated with the Item ID assigned to a transaction line, journal line detail or master file record. This is a text box that defaults as blank, is required, and must be <= 105 characters. If missing, the message "Item Description is required." will be displayed on Save. This is always editable. Item Descriptions do not have to be unique. However, careful consideration should be used before having multiple Item IDs with the same Item Description. Database Field: ERPx_IMItem.ItemDescription |
Base Configuration | |
Item Type | Identifies the type of item and its behavior in the system. Item Types fall under two main categories:
The lookup contains a list of all Item Types in the ERPx_IMItemType table. Database Fields: ERPx_IMItemType.Description, ERPx_IMItem.ItemTypeSK |
Item Class Description | Item Classes are used to identify default values that will be applied to new Inventory Items and to group Items together for reporting purposes. This is a single-select lookup that defaults as blank and is required. If missing, the message "Item Class is required." will be displayed on Save. This is always editable. The lookup contains a blank value, the current assigned value, and a list of all 'Active' Item Classes. Database Fields: ERPx_IMItemClass.Description, ERPx_IMItem.ItemClassSk |
Manage Items By | Identifies how item quantities are managed. The options include:
If this is changed for an existing item, validation will occur to:
This lookup contains the values in the IMManageItemsBy Enumeration Class. Database Field: ERPx_IMItem.ManageItemsByEN |
UOM Schedule ID | Identifies the UOM Schedule that is used to determine what Units of Measure are to be used for specific items that are bought, sold and manufactured as well as the conversions for those Units of Measure. This lookup contains all UOM Schedules on the Units of Measure list view. Database Fields: ERPx_IMUOMSchedule.ScheduleID, ERPx_IMItem.UOMScheduleSK |
Item Attribute Class | Identifies the Attribute Class configured for the Item. This is a single-select lookup that defaults from the Item Class but is not required. This is always editable. Attribute Classes are assigned to master files to control which Attributes are visible, and/or required, to records within the master file. This lookup contains a list of all Item Attribute Classes. Database Fields: ERPx_MFAttributeClass.ClassDescription, ERPx_IMItem.AttributeClassSk |
Unit Decimals | Identifies the number of 'Unit' decimal places for the item. This is a numeric text box that defaults from the 'Unit Decimals' field on the 'Properties' tab of the Item Class Record View, is required, and must be a whole number between 0 and 5. If the Item does not have transaction history it can be edited to any value that is less than or equal to the 'Decimal Places' set on the assigned UOM Schedule ID. If the value is too high, the message "The UOM Schedule [Current Assigned UOM Sched.] allows up to [UOM Sched. Decimal Places] and your Unit Decimals is set to [Current assigned value]. Please update your Unit Decimals to be less than the UOM Schedule's decimal places." will be displayed on Save. If the Item has transaction history it can only be increased up to the max 'Decimal Places' on the UOM Schedule else the message. If set to a lower value, the message "Unit Decimals cannot be changed to be lower than the previously saved Unit Decimals ([Prev. Value])." will be displayed on Save. Additionally, this value must be a whole number between 0 and 5, else the message "Unit Decimals must be between 0 and 5." will be displayed on Save. Database Field: ERPx_IMItem.UnitDecimals |
Weight Decimals | Identifies the number of 'Weight' decimal places for the item. This is a numeric text box that defaults from the 'Weight Decimals' field on the 'Properties' tab of the Item Class Record View, is required, and must be a whole number between 0 and 5. If the Item does not have transaction history it can be edited to any value that is less than or equal to the 'Decimal Places' set on the assigned UOM Schedule ID. If the value is too high, the message "The UOM Schedule [Current Assigned UOM Sched.] allows up to [UOM Sched. Decimal Places] and your Weight Decimals is set to [Current assigned value]. Please update your Weight Decimals to be less than the UOM Schedule's decimal places." will be displayed on Save. If the Item has transaction history it can only be increased up to the max 'Decimal Places' on the UOM Schedule else the message. If set to a lower value, the message "Weight Decimals cannot be changed to be lower than the previously saved Weight Decimals ([Prev. Value])." will be displayed on Save. Additionally, this value must be a whole number between 0 and 5, else the message "Unit Decimals must be between 0 and 5." will be displayed on Save. Database Field: ERPx_IMItem.WeightDecimals |
Price Decimals | Displays the number of decimal places available to be entered for the price of the item. After the initial Save, this can always be changed to a larger value but cannot be set to a smaller value else the message "Price Decimals cannot be changed to be lower than the previously saved Price Decimals ([Prev. Value])" will be displayed on Save. Database Field: ERPx_IMItem.CurrencyDecimals |
Taxable for Sales | Identifies whether or not the item is taxable on a Quick Sale, Fisherman Sales, or Tender Resale transaction. This is a Yes/No lookup that defaults from the 'Taxable for Sales' field on the 'Properties' tab of the Item Class Record View for the selected Item Class. This is required and is always editable. If set to "Yes" the item will be evaluated for Sales Tax based on the 'Tax Class' assigned to the transaction. If set to "No" the item is not Taxable and no sales tax will be computed for the item regardless of the 'Tax Class' assigned to the transaction. Database Field: ERPx_IMItem.TaxableForSales |
Inactive | Identifies whether the item is active. This is a Yes/No lookup that is required and is always visible. If set to "Yes" the item will be excluded from item lookups on transactions. If set to "No" the item is able to be freely used. Identifies if the record is "Inactive". If inactive (set to "Yes"), it will not be included in look-ups for transactions or other master files. If set to "No" or blank, the record is active and can be freely used. Database Field: ERPx_IMItem.IsInactive |
Default Units of Measure | |
Purchases | Displays the unit of measure that will default when the item is added to a Purchase Order or AP Invoice/Credit Memo. This is a single-select lookup that defaults as blank, is not required, and is always editable. This lookup contains a blank value, the current assigned value, and all 'Active' UOMs on the selected Item's UOM Schedule. Database Fields: ERPx_IMUOM.UOMName, ERPx_IMItem.PurchaseUOMSK |
Inventory - Units | Identifies the default inventory unit of measure that the units are stored in (boxes, Bags, Cases, Totes, etc.) for the item.This is a single-select lookup that defaults as blank and is required. If missing, the message "([Item ID]): The Default Units of Measure: Inventory - Units are required for items managed by units and weight." or "(Item ID): The Default Units of Measure: Inventory - Units are required for unit only items." will be displayed on Save. If the item's 'Manage Items By' value is set to:
A UOM is a quantity used as a standard of measurement. It identifies how much makes up "1" of the measurement. Examples include Bag, Box, Each, Kg, Lb, ext. This lookup contains a blank value, the current assigned value, and all 'Active' Unit UOMs on the selected Item's UOM Schedule. Database Fields: ERPx_IMUOM.UOMName, ERPx_IMItem.DefaultIMUnitUOMSK |
Inventory - Weight | Identifies the default inventory unit of measure that the weight is stored in (Lbs, Kg, Oz, Ton, etc.) for the item. This is a single-select lookup that defaults as blank and is required. If missing, the message "([Item ID]): The Default Units of Measure: Inventory - Weight are required for items managed by units and weight." or |