Price/Spiff/Commission Table

Access

Use this feature to create pricing tables for individual products in the Advanced Product Settings.  You set up a price table for each product to which you want to apply this feature.  You can use the tables to determine selling prices and also to associate a specific commission rate and/or spiff amount with a selling price range.

 To access this table, the Pricing Levels field on the Pricing and Commissions tab in the Point of Sale Control Settings must be set to Product. If that field is set to Store, Level Pricing is active on your system.

In Sales Order Entry, you can edit the commission category and spiff amount.  First, select a line item, then click on the Actions button and select Additional Line Item Display.  On the General tab, click on the Actions button to access the Commission/Spiff Updates Screen.

Spiff amounts you enter here override any spiff amounts you enter in the Spiff Table Entry Screen.

If you modify any commission/spiff settings in this routine, the changes do not automatically affect existing sales orders. For the changes to affect an existing sales order, you must access the order and either

    - edit the settings via the Commission/Spiff Updates Screen or

    - re-enter the individual line items.

Creating tables in the Advanced Product Settings

Access the Price/Spiff/Commission Table feature from the Actions menu on the Pricing Tab of the Advanced Product Settings.  

ProductThe selected product defaults from the Advanced Product Settings.  

Replacement CostThe replacement cost for the selected product appears.

Price LevelEnter the cutoff price for this price level.  When this product is sold for a price greater than or equal to the amount entered here, and less than the amount specified at the next highest price level (if any), the system awards a commission to the salesperson for the amounts specified in the Spiff and/or Percentage fields (if any) for the current price level.

Lock Price Table

Price CategoryEnter an alphanumeric Consisting of both letter and number characters and often other symbol characters such as punctuation marks. code of up to 5 characters to identify this price category.

Spiff AmountEnter the spiff amount you want to pay (if any) when this product is sold for a selling price greater than or equal to the price in the Price Level field.

Commission PercentageEnter the percentage of commission you want to pay (if any) when this product is sold for a selling price is greater than or equal to the price in the Price Level field.

Calc Method

To add the price level to the grid, click the Add button.  To change or remove a price level already entered, double-click the line in the grid.  To update the price table, click on Save.

Using the table in Sales Order Entry

When defaulting the product price during Sales Order Entry, one of the following occurs based on the existence of a price table for that product.

• If no price/spiff/commission table has been specified for the product, the system uses the regular selling price, as normal.

OR

• If a table is present, the following occurs:

a.   The system checks the customer record Class code.  If a Class code is present in the customer record and that class matches the Price Category field in the price table, the selling price defaults to the corresponding price level from the table.

b.   If the customer record does not contain a class that is also present (as a Price Category) in the price table, the system uses the highest price level from the table as the default selling price.

Additionally,

• If a sales promotion is in effect for a product, the system determines the selling price as the lower of the promotional price or the default table price based on the customer class.

• Once the system determines a default price, you can manually change the selling price.

a.   From the Merchandise tab in Sales Order entry, click the Actions button located at the bottom of the screen. Select Price/Spiff/Commission Table from the menu to display the price table.

b.   If the you select a line in the table, the system uses the indicated price level as the selling price.  Based on system settings, you may also have the ability to manually override that price.

• If a price table is not present for any given product, sales commission derives via the usual methods in STORIS.

• If a price table is present, the system always bases commission on information from the table for the product.

a.   If you select a promotional price, the system still selects commission and/or spiff amounts from the price table.

b.   When calculating the commission for the individual lines of a soft kit A kit with fewer selling and stocking restrictions than a hard kit, allowing you to treat the components as individual line items. For example, STORIS allows partial shipments of soft kits., the system uses the kit selling price against the table to determine the appropriate commission and/or spiff amount.

c.   When calculating sales commission and/or spiff for hard kits, the system uses the table information from the kit A group of stock products organized into a set so as to be sold as a package or suite. In STORIS, you can create hard or soft kits. master.

d.   To ensure that a negative commission is charged on ‘giveaways’, include a zero sell price line at the bottom of the table with a Gross Profit calculation method.

• The system applies spiff data

- on a go-forward basis to orders created after the spiff was created/edited.  That is, if you create an order before you create/update a spiff but complete the order after you create/update the spiff, the system does not apply the new/updated spiff.

- at the time of order entry.  Therefore, if you edit the spiff while a product is on an open order, the system does not update orders with the new spiff data.  To apply the new spiff data, you must re-enter the item onto the order.