Item Sets are used to combine a group of items that are priced the same for Brokerage, Rebate, On Invoice, and Accrual Programs. From here users can add, remove, and/or edit Item Sets.
| Toolbar Icons | Description |
|---|
| Delete | | Insert excerpt |
|---|
| Delete - LV |
|---|
| Delete - LV |
|---|
| nopanel | true |
|---|
|
 Item sets with history cannot be deleted.
|
| Grid Layout | | Insert excerpt |
|---|
| Toolbar Icon - Grid |
|---|
| Toolbar Icon - Grid |
|---|
| nopanel | true |
|---|
|
|
| New | | Insert excerpt |
|---|
| New - RV Header |
|---|
| New - RV Header |
|---|
| nopanel | true |
|---|
|
|
| Save | | Insert excerpt |
|---|
| Save - RV Header |
|---|
| Save - RV Header |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
| Item Set | A textbox to enter or edit the Item Set name (e.g., the unique identifier). This defaults to blank, is required, and must be unique. This is always editable and can be changed to any value <= 50 characters. |
| Item Set Description | A textbox to enter or edit the Item Set Description (e.g., describe what it is used for). This defaults to blank, is not required, and duplicates are allowed. This is always editable and can be changed to any value <= 500 characters. |
| Type | A single select lookup to identify where the Item Set can be used. This defaults to 'All Modules' and is always editable. The lookup contains the following values: - All Modules
- Customer Catalogs
- Price Lists
- Reports
- Sales Programs
|
Properties Tab
The Properties tab is used to specify the overall selection criteria for the items belonging to, or intentionally excluded from, the Item Set.
| Property Name | Description |
|---|
| Item Type | A multi select lookup to identify one or more Item Types. The list of Items included in the Items tab will be only those belonging to the Item Types selected. This defaults as "ALL" and is always editable. The lookup contains: All, AP Expense, Freight, Inventory, Misc, and Tax. |
| Item Class | A multi select lookup to identify one or more Item Classes. The list of Items included in the Items tab will be only those belonging to the Item Classes selected. This defaults as "ALL" and is always editable. The lookup contains an option for "ALL" and the list of all 'Active' Item Classes. |
| Attribute Class | A multi select lookup to identify one or more Item Attribute Classes. The list of Attributes shown on the Attributes Tab will be those that are included in the Attribute Class(es) selected here. Those Attributes can then be filtered and the items that match those Attribute Values will be included in the Items tab. This defaults as "ALL" and is always editable. The lookup contains an option for "ALL" and the list of all Item Attribute Classes. |
| UOM Schedule | A multi select lookup to identify one or more UOM Schedules. The list of Items included in the Items tab will be only those belonging to the UOM Schedule(s) selected. This defaults as "ALL" and is always editable. The lookup contains an option for "ALL" and the list of all UOM Schedules. |
| Included Manually Selected Items | A multi select lookup to identify one or more exception Items that need to be included in the Item Set but do not meet the other criteria specified. Items selected here will be added to the Items tab. This defaults as "ALL" and is always editable. The lookup contains an option for "ALL" and the list of all 'Active' Items. |
| Excluded Items | A multi select lookup to identify one or more exception Items that need to be excluded from the Item Set even if they meet the other criteria specified. Items selected here will be removed from the Items tab. This defaults as "ALL" and is always editable. The lookup contains an option for "ALL" and the list of all 'Active' Items. |
Attributes Tab
The Attributes tab displays all the Attributes that are valid for the Item Attribute Class(es) selected in the Attribute Class lookup on the Properties Tab. Attribute Values can be specified to limit the list of Items added to the Items Tab.
| Fields | Description |
|---|
| Attributes | Displays the name of the attribute value. |
| Value | A multi select lookup to select one or more applicable Attribute Values. This is not required and always editable. Items that contain the selected Attribute Values will be added to the Items Tab. |
Items Tab
The Items tab displays items assigned to the item set record. These are items that meet the properties and attribute values selected on the Properties and Attribute -tabs. The Items tab is updated on save. The grid also includes all the user defined Item Attributes as columns that can be added.
| Toolbar Icon | Description |
| Excel | | Insert excerpt |
|---|
| Excel - Global (old) |
|---|
| Excel - Global (old) |
|---|
| nopanel | true |
|---|
|
|
| Columns | Description |
|---|
| Attribute Class | Identifies the Attribute Class assigned to the Item. |
| Description | | Insert excerpt |
|---|
| Item Description |
|---|
| Item Description |
|---|
| nopanel | true |
|---|
|
|
| Item | | Insert excerpt |
|---|
| Item ID |
|---|
| Item ID |
|---|
| nopanel | true |
|---|
|
|
| Item Class | | Insert excerpt |
|---|
| Item Class |
|---|
| Item Class |
|---|
| nopanel | true |
|---|
|
|
| Item Type | | Insert excerpt |
|---|
| Item Type: Inventory |
|---|
| Item Type: Inventory |
|---|
| nopanel | true |
|---|
|
|
| UOM Schedule | | Insert excerpt |
|---|
| UOM - Schedule |
|---|
| UOM - Schedule |
|---|
| nopanel | true |
|---|
|
|
...
| Expand |
|---|
|
Technical Details
| Table Names: |
|---|
| dbo.ERPx_IMItemSet | | dbo.ERPx_IMItemSetItems |
| Stored Procedures: |
|---|
dbo.SPx_IMSEL_ItemSet | dbo.SPx_IMSEL_ItemSetAttributes | dbo.SPx_IMSEL_ItemSetHeader | dbo.SPx_IMSEL_ItemSetItemList | dbo.SPx_IMSEL_ItemSetProperties | dbo.SPx_IMUpdate_ItemSet | dbo.SPx_IMUpdate_ItemSetItems |
|
...