Pricing
      Back to home
      1. User Manual
      2. Spire User Manual - Inventory
      3. Pricing

      PRICE MATRIX - Add / Edit / Delete

      This multi-function pricing and discounting utility links to your Inventory, Customers and Sales Orders to create pricing or discount rules by date, by Customer, by Inventory group and much more.

      See also Access / List Functionality

      Add a New Price / discount in one of 4 ways:

      1.  Manually set up in Price Matrix Module

          - or Customer Details > Price Matrix Tab

          - or Inventory Details > Price Matrix Tab

          - or Sales Text Menu > Price Matrix

             

      • click on   New
        • set Inventory Criteria
               
          • select Warehouse (or leave blank for all warehouses)
          • select or type Part No
          • select or type Unit of Measure
          • option to select a group of items by Product Code for use with the Discount or Margin in the Pricing Method selection (see below)
        • set Customer Criteria
          • select which Customer this price / discount / margin is for
          • option to assign this price to just a specific Ship To Address of the selected Customer
          • assign the Currency for this price
          • Territory - to assign this price to all Customers in this Territory (option not available when establishing pricing from the Customer module)
          • Customer type - to assign this price to all Customers within this User type (option not available when establishing pricing from the Customer module)
        • option to select a Date Range (ie: for a sale)
        • option to establish High Priority so this price will supersede any other prices or discounts in the Price Matrix system with this same criteria
          • **note - ‘Match Lowest Price’ setting in Company Settings > Sales Orders > Orders tab is superseded by this ‘High Priority’ setting
        • Pricing
          • Pricing Method
            • Price
            • Discount
            • Margin - calculates the price based on the Cost selected, using the Margin value entered (cost/(1-margin %/100))=Sell Price
              • note - when the cost is changed, the selling price will automatically change to
              •  maintain this margin
              • select the Cost Method that the Margin will calculate on (Average / Current / Standard Costs are displayed to the right)
            • Default Price displays the default price 01 from the inventory details
        • option to assign a Promotion (to group items for special pricing / discounts)
            • Add a Price Reason from the browse list for use in future Price entries or in the Sales text menu – Promotions
              • enter Code
              • enter Description
              •  CheckBoxCheckedBlue Cumulative Discount Calculation - in conjunction with Minimum Quantity - will add up the quantity of all items on the Sale Order that are assigned this Price Reason in their Price Matrix setting
              • Text Color as it will appear in the list
              • Background Color as it will appear in the list
          •   Save or Save Close

        2.  Copy from an existing Price / Discount in the Price Matrix Module

        •      - or Customer Details > Price Matrix Tab

               - or Inventory Details > Price Matrix Tab

               - or Sales Text Menu > Price Matrix

                   
        • select from the list and click on Copy -or- double-click from the list to open and click on Copy here
            • enter criteria as outlined  above
          • this entry shows an example using the Discount Pricing Method, with a 10% discount on all items assigned ‘EQUIP’ Product Code if 6 or more are purchased

           
          3.  Create a New Price / Discount From a Sales Order 
          • enter Unit Price in the Customer’s Sales order 
            • click on InventoryRefreshIcon Prices
            • select from Store All Prices on the sales order or Store Selected PricesSalesOrderPricesMenu
          • option to select Create records for regular prices where there may be lines for which the price was not changed from the default price 01 but for which you want to create a Price Matrix entry for the current Customer
            • option to apply this custom price to this item in all Warehouses
            • option to apply this custom price to the shipping address only or to both Bill to and Ship to addresses
            • Okay

             4.  Import Price / Discounts (see Import)

             

             Edit Price entry
              • select price entry and click on Edit - or - double-click on the price entry
              • make necessary changes
              •   Save or   Save Close
            Multi-Edit Price entries - select the price entries and click on Edit
                 
              • edit from the available fields on a Multi-Edit
              • Delete
                • select price or group of prices and click on Delete
                • Print from listed report(s) on the selected Price(s) (see Reports)
                • Purge Previous - for any prices which have expired but which are still in the Price Matrix system
                  • enter the End Date or Completion Date from the price / discount entries you wish to purge 

               

              for other pricing options, see also Sell Prices