Market Lists

A market list is a group of items that you routinely purchase and keep in your inventory. Market lists are often for a specific supplier but you can also have general market lists that are not for a specific supplier.  

Add a Market List and Market List Items

To add a market list with inventory items:

1. Click the Market List link from the Main Menu. The Market List screen opens.
2. Click the Add button. The Add Market List screen opens.
3. Enter the necessary information:
   • Description - Name for the market list.
   • Code - Unique alphanumeric code used by the system.
   • Supplier - Supplier for the market list if it is applicable to a specific supplier.
   • Department - Department responsible for the market list.
   • Allow Non-Inventory - If checked, you can add items not in your inventory item list to the market list.
4. Expand the Additional Information section.
5. Enter the necessary information:
   • Auto-Update - If checked, the cost for the inventory items are updated to the last purchase cost. 
   • Status - You can only add items from active market lists to requisitions and purchase orders.
   • Currency - Currency for the market list. Only available if Enable Multi-Currency is checked on the Accounts Payable Configuration screen.
6. Select the Market List Items tab.
7. Click the Add button. The Select Inventory Item screen opens.
8. Select the inventory item(s) to add to the market list. Use Ctrl+Click or Shift+Click to select multiple items.
9. Click the Select button. The inventory items are added to the market list.

You can also add non-inventory items to a market list if the Allow Non-Inventory check box is checked for the market list. To add non-inventory items to a market list:

1. Select the Market List Items tab.
2. Click the arrow next to the Add button.
3. Select Add Non-Inventory. The Add Non-Inventory Item screen opens.
4. Enter the following information:
   • Description - Name of the item.
   • Unit Cost - Cost per unit for the item.
   • U/M - Unit of measure for the item.
   • Display Order - Order the items displays on the market list.
   • Major - Major inventory group for the item.
   • Minor - Minor inventory group for the item.
5. Click OK.

You can use market list headers to create groupings for your items to help organize your market list. To add a market list header:

1. Select the Market List Items tab.
2. Click the arrow next to the Add button.
3. Select Add Header. The Add Market List Header screen opens.
4. Enter the order to display the market list header into the Display Order field.
5. Enter the name of the market list header into the Item field.
6. Click OK.

Update Item Costs

If you want to update the item costs on a market list to the last purchase price, you can use the Auto Update action.

1. Click the Market List link from the Main Menu. The Market List screen opens.
2. Select the market list with the items you want to update.
3. Right-click and select Auto Update.

Change a Market List Item

You can change the information for a market list item after you have added it to the market list. If you change the information for a market list item, it does not update any existing purchase orders. The new information is only used when adding the market list item in the future.

1. Click the Market List link from the Main Menu. The Market List screen opens.
2. Select the market list with the item to edit.
3. Right-click and select Edit. The Edit Market List screen opens.
4. Select the Market List Items tab.
5. Select the item to edit.
6. Right-click and select Edit. The Edit Market List Item screen opens.
7. Make the desired change.
8. Click OK.

Inactivate a Market List

If you no longer use a market list but want to keep record of it for reporting or other purposes, you can make it inactive. When you make a market list inactive, it is no longer available for selection when adding items from a market list.

1. Click the Market List link from the Main Menu. The Market List screen opens.
2. Select the market list to make inactive.
3. Right-click and select Edit. The Edit Market List screen opens.
4. Expand the Additional Information section.
5. Select Inactive from the Status drop-down.
6. Click OK.

Delete a Market List and Market List Item

If you no longer use a market list and don't want to keep a record of it, you can delete it. You cannot undo the delete process.

1. Click the Market List link from the Main Menu. The Market List screen opens.
2. Right-click on the market list to delete.
3. Select Mark for Delete.
4. Click the Save button.

To delete an item from a market list:

1. Click the Market List link from the Main Menu. The Market List screen opens.
2. Right-click on the market list with the item to delete.
3. Right-click and select Edit. The Edit Market List screen opens.
4. Select the Market List Items tab.
5. Right-click on the market list item to delete.
6. Select Mark for Delete.
7. Click the Save (disk) button.

Market List Security

Allow Override of Market List Cost from PO/Req

This access privilege controls who can override the market list cost when entering requisitions or purchase orders. Roles/users assigned to the privilege are allowed to override the market list cost for a requisition or purchase order. If no roles/users are assigned to the privilege, it is considered inactive and all roles/users can override the market list cost. 

Allow Update of Market List Cost from PO/Req

This access privilege controls who can update the market list cost when entering requisitions or purchase orders using the Update Cost check box. Roles/users assigned to the privilege are able to update the market list cost for a requisition or purchase order and can see the Update Cost check box. If no roles/users are assigned to the privilege, then it is considered inactive and all roles/users can update the market list cost using the Update Cost check box..