PRICE MATRIX - Access / List Functionality

How to use this pricing and discounting utility and understand it's links to your Inventory, Customers and Sales Orders

 

see also Add / Edit / Delete Prices / Discounts

Access the Price Matrix utility in one of five ways:

  1. Price Matrix module
  2. Customer module > Customer details > Price Matrix tab
  3. Inventory module > Inventory details > Price Matrix tab
  4. Sales Text Menu > Price Matrix
  5. Sales Order > Prices > Store Prices

Price Matrix List Customization


  • Refresh to load any newly entered Prices on this list
 
  •   Filters - create a filter for this list
    • click on Filters
    • choose from the Any or All selector
    • select from the list of fields to set the criteria
    • 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: date)
    • 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:
        • give this filter a name
                                  PriceMatrixFilterName

      • select User if this filter will be used you only
      • select Company if it is to be accessed by all users in the Company
      • CheckBoxCheckedBlue Show in module list to display beneath the module name

      • 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:
                         PriceMatrixFilterMenu
    • click on the Filters button to release the current filter to see entire list or start new filter
  • Icon Menu Customization 
    • hover over the Icon Group handle until you see
    • drag the Icon Group to where you want it
  • Column Customization
    • 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 (‘ACM’ in this example) and the list will highlight the closest match, in currently sorted column
           
  •   - 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
    • Price Matrix Context Menu - right-click on any line(s) to display
                 
    • 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
      • Save
      • option to Open File right away
      • from excel, make any changes or build any desired formulas

     

    see also Sell Prices