SELL PRICES - Access / List Functionality

Manage markup or margin settings for pre-established Selling Price Levels

InventorySellPricesIcon-1

Setup access:

(see also Add Sell Price)

1. Price Levels in Inventory Text Menu

InventoryTextMenuPriceLevels

2. Sell Prices tab in Inventory module

InventoryListSellPricesTabLeft-1

Sell Prices List Customization

  • Refresh to load any newly entered Price Settings on this list
  • Filters - create a filter for this list

  InventoryListSellPricesTabFilter

    •   click on Filters
    • choose from the Any or All selector
    • select from the list of fields to set the criteria (ie:  Product Code)
    • select from the operators ie: is, is not, etc - this operator list changes based on the field selected in the previous step
    • enter the criteria information (ie: 'PARTS')
    • if desired click to add a line of criteria
    • to remove the line click
    • make any column adjustments (see Column Customization)
    • click Filters for save options:
               FiltersMenu

      • Save as default -  will load this filter when the Filter button is depressed
      • Remove default to remove the previously set default Filter
      • Save filter - to save changes on a previously saved Filter
      • Save filter as… - will allow you to name the Filter with the following settings:InventoryListSellPricesTabFilterSave
      •  give this filter a name
      • select RadialButtonBlue User if this filter will be used by you only
      • select RadialButtonBlue Company if it is to be accessed by all users in the Company
      • CheckBoxCheckedBlue Show in module list to display beneath the module name:
                 InventoryListSellPricesTabFilterModuleList
      • CheckBoxCheckedBlue Save column state if you have removed or added columns, or have sorted the list by one of the columns
      • click OK 
      • the new Filter is also accessible in the Filter menu:
                          SellPricesFilterMenu
  • click on the Filters button to release the current filter in order to see entire list, or to start a new filter
  • Icon Menu Customization 
    • hover over the Icon Group handle until you see
    • drag the Icon Group to where you want it
  • Column CustomizationInventoryListSellPricesColumnList
    • drag and drop columns to desired positioning
    • right-click on any column heading for access to column chooser for display customization👉
  • Column Sort / Search - click on any column heading to sort the list by that column
    • further narrow your search by just typing (‘pre’ in this example) and the list will highlight the closest match, in currently sorted column

            InventoryListSellPricesTabColumnSortSearch

  •   - type any character(s) into this field and the list will narrow to only records containing the character(s) typed, somewhere in the details
    • Open a Price record and use the Navigate buttons to page through Prices in the list, filtered or not filtered, in order of the current column sort
    • Sell Prices Context Menu - right-click on any line(s) to display
                  InventoryListSellPricesTabQuickMenu
    • Export the Prices list (will export exact column layout) to Excel (.xlsx only) or CSV format
               
        • select Prices(s) from a filtered or unfiltered list (see Filters above)
        • click Export
        • choose the location File Name, and Save as type (.xlsx or .csv)
        • Save
        • option to Open File right away
        • from excel, make any changes or build any desired formulas
      InventoryListSellPricesTabChangePriceIcon Change Price - see Inventory Pricing
      OpenInventoryIcon Open Inventory to view or edit inventory details for the price selected

       

      for other pricing options, see  Price Matrix