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:
- Click the Market List link from the Main Menu. The Market List screen opens.
- Click the Add button. The Add Market List screen opens.
- 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.
- Expand the Additional Information section.
- 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.
- Select the Market List Items tab.
- Click the Add button. The Select Inventory Item screen opens.
- Select the inventory item(s) to add to the market list. Use Ctrl+Click or Shift+Click to select multiple items.
- 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:
- Select the Market List Items tab.
- Click the arrow next to the Add button.
- Select Add Non-Inventory. The Add Non-Inventory Item screen opens.
- 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.
- 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:
- Select the Market List Items tab.
- Click the arrow next to the Add button.
- Select Add Header. The Add Market List Header screen opens.
- Enter the order to display the market list header into the Display Order field.
- Enter the name of the market list header into the Item field.
- 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.
- Click the Market List link from the Main Menu. The Market List screen opens.
- Select the market list with the items you want to update.
- 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.
- Click the Market List link from the Main Menu. The Market List screen opens.
- Select the market list with the item to edit.
- Right-click and select Edit. The Edit Market List screen opens.
- Select the Market List Items tab.
- Select the item to edit.
- Right-click and select Edit. The Edit Market List Item screen opens.
- Make the desired change.
- 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.
- Click the Market List link from the Main Menu. The Market List screen opens.
- Select the market list to make inactive.
- Right-click and select Edit. The Edit Market List screen opens.
- Expand the Additional Information section.
- Select Inactive from the Status drop-down.
- 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.
- Click the Market List link from the Main Menu. The Market List screen opens.
- Right-click on the market list to delete.
- Select Mark for Delete.
- Click the Save button.
To delete an item from a market list:
- Click the Market List link from the Main Menu. The Market List screen opens.
- Right-click on the market list with the item to delete.
- Right-click and select Edit. The Edit Market List screen opens.
- Select the Market List Items tab.
- Right-click on the market list item to delete.
- Select Mark for Delete.
- 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..
Comments
2 comments
Is it possible to import a market list from Excel?
0 upvotes
We do not have a standard import tool. Tech services may be able to do it via SQL processing
0 upvotes
Please sign in to leave a comment.