Promotion Price Lists Stock Item / Price List Tab

For the Other Action Menu options (press F9 or the Other Actions Menu on the Button Bar) see Promotion Other Actions Menu.

The [ Promotion | Price Lists | Stock Item / Price List ] tab is the most commonly used section as it is essentially where true price lists are defined, see How To: Set Stock Item Prices Against a Price List. A price list is a list of prices that can be assigned to various different customers. For example, you could define a Wholesale price list, a special pub group price list and a residential customer price list that can be assigned to customers that fall into these categories. A single customer can belong to one, or more, different price lists and the prices on the price list value for a specified period. For the other types of Price List see the Promotion Price Lists Tab.

The screen consists of two areas:

  • Filters and Action Buttons
  • Grid



Filters and Action Buttons

  • Price List: drop down to select the price list.
  • BtnCopyPriceList.jpg : copies the selected price list from one customer to another, see How To: Copy a Price List.
  • Allow editing list prices: if this box is ticked users can amend the list price of the item. This also changes the sell price (list price) in the stock screen.
  • Price List is Net: even though the overall system may be set to use gross selling prices (i.e. the stock items sell prices are all gross), a price list can be set that bucks the trend, see Net and Gross Prices for more information..
  • Reverse view [GROSS]: affects the Amount column so if the prices are in Net the user can toggle to see them in Gross and vice versa, see Net and Gross Prices for more information. The Amount column heading will have a (G) or (N) to indicate whether the prices being displayed are in Gross (G) or Net (N).
  • View by Comp Class/Stock Item: toggles between selecting named Price List from drop-down, or Stock Item look up which will display all instances of the selected item where it is included in a user defined price list.
  • Price List Date Range: the start and end dates which the items on the Price List are valid for. These can be changed in the grid for individual stock items. Once the dates are selected the user applies them to the items in the grid using the adjacent Tick to apply the dates in a Price List button, see How To: Create a Price List for items with prices that are valid for a specified date range. Dates can be removed from the grid using the Cross to remove the dates. from a Price List button.
    Note: this only works when 'Comp Class' radio button is selected.
  • Limit by Currency: limits the prices to be used on sales orders to the selected currency. This is used where you are selling to customers using non-base currency and wish the prices to remain consistent. If you don't use a price list the system would use the current conversion rate for the sell price (e.g. 100 = 120 when the conversion rate is 1.2 Euro to the £) when adding stock items to sales orders for customers who use a non-base currency. This would result in fluctuations in prices for the same stock items as the currency rates are changed or updated. An example of use is setting up a Euro price list for all EU customers who pay by Euro, see How To: Setup a Price List for a Euro Customer.
    Notes:
    1. It is not possible to assign a non-Sterling Price List to a customer whose billing currency (as defined in their [ Customer | Detail | Financial ] screen) is Sterling.
    2. Limiting by Currency:
      1. If you setup the price list to be limited by the currency (sterling), then if you added the price list and an applicable item to a EURO customer, it would use the conversion rate stored in Khaos Control, to work out the EURO equivalent.
      2. If you don't limit the price list by a currency, then it will use the value on the price list as a static value, irrespective of the currency it was being added in, so it'd be the same amount in GBP & EUR.
WARNING icon
WARNING: You can't mix and match currencies.
If a customer is setup as paying by one currency you must not use a price list limited by another currency for them.

Grid

Price List Hierarchy Flow Diagram
  • Stock Code: stock item's code.
  • Stock Description: stock item's description.
  • Price (N)/(G): read only field displaying calculated price from other fields. (Non-Importable)
    • (N): This suffix means that this price will be Net when added to a sales order. This pricing system is controlled by a combination of the Sell Prices are Net option in [ System Values | Sales | Pricing ] and the Price List in Net tickbox.
    • (G): This suffix means that this price will be Gross when added to a sales order. This pricing system is controlled by a combination of the option 'Sell prices are net' in [ System Values | Sales | Pricing | Pricing ] and the Price List is Net checkbox.
  • Qty breaks Low/High: sets the pricing to only take effect when the order quantities are within a certain range (by default set between 1 and 999).
  • Amount (N)/(G): price list price to be used.
  • Disc%: discount percentage to be applied to item.
  • List Price (N)/(G): sell Price automatically populated by system from the sell price held against the stock item in the stock screen. (Non-Importable)
  • Base
    • Markup%: percentage increase to add to Base Buy Price or Massaged Buy Price.
      Note: if you define a Price List by Base MarkUp%, it will calculate the Amount (G) or Amount (N) depending on whether the Buy Price in the system is in Net or Gross. It will ignore whether the Price List is in Net or Gross and will calculate based on the Buy Price (N)/(G).
    • Buy Price (N)/(G): buy price automatically populated by system from the buy price held against the stock item in the stock screen. (Non-Importable)
    • Price from Stock Value checkbox: works with the Stock Value and Markup% columns, see How To: Add a Sell Price as a Mark-up % of the Stock Value in a Price List:
      • Ticked: the sell price is calculated by applying the 'Mark-up%' to the "Stock Value', so selling price = stock value + Mark-up%.
      • Unticked: the sell price is calculated as previously where there is a 'Mark-up%' by applying it to the 'Buy Price'.
        Notes:
        1. Defining the selling price based upon the stock value is only allowed for Price Lists using 'Net' values.
        2. If the stock value of an item changes, then so will the sell price on the price list if calculating based upon the stock value.
    • Stock Value: this is the Stock Value from the [ Stock | Detail | Properties ] screen and is not editable.
  • Massaged
    • Markup%: read only field calculating the new MarkUp% based on the original base Buy Price and the calculated price. (Non-Importable)
    • Buy Price: price that can be used with Base Markup%. If a Massaged Buy Price is entered the system will use this price, rather than the base buy price, to work out the calculated price for the item displayed in the Price Field.
      Note: massaged buy prices need to be manually updated. (Non-Importable)
  • Fixed
    • Buy Price: a static buy price value that can be used with the Base Markup% to calculate the Price; for example, if you are updating the stock item's buy price after saving a purchase order or posting a purchase invoice and wish to use a static buy price in your price lists. The Base Buy Price can be copied into the Fixed Buy Price using the context menu option Reset Fixed Prices.
  • Discontinued: indicates that the stock item has been marked as discontinued in their [ Stock | Detail | Options ] screen.
  • SO Line: if the sales order contains multiple lines for the same stock item, ticking this box will result in the system assessing quantities on a line by line basis for the purposes of applying price break discounts. If the box is not ticked, the quantity of the item on the sales order as a whole will be used.
  • Start Date: the date the prices on the Price List will be valid from.
  • End Date: the date the prices on the Price List will be valid to.

Note: there is a hierarchy for which price the system will use:

  1. Amount
  2. Disc% with no Amount set will use the List Price.
  3. Disc% with the Amount set will use the Amount.
  4. Fixed Buy Price with the Base Markup%.
  5. Massaged Buy Price with the Base Markup%.
  6. Base Buy Price with the Base Markup%.

Grid Context Menu

  • Goto Stock Item...: opens the [ Stock | Detail | Properties ] screen for the selected stock item.
  • Goto Company: opens the [ Customer | Detail | General ] screen for selected customer.
    Note: only on the Stock Item / Customer grid.
  • Full Refresh: refreshes the screen, by loading values from the database, instead of just refreshing the grid data locally.
  • Quick Stock Entry Ctrl+Q: this opens the 'quick stock entry' dialog. The user can enter multiple stock codes and then add all the stock items to the Adjustment grid in one go, it works in a similar ay to Quick Stock Entry in Sales Orders except that the dialog only has the display area.
  • Reset Massaged Prices: enters the buy prices into the Massaged Buy Price column.
  • Reset Fixed Prices: enters the buy prices into the Fixed Buy Price column.
  • Update Prices / Discounts: opens the Stock Price Update Dialog enabling the user to update the Price List amounts and discounts en masse.
  • Apply Value Range: allows the user to specify a value that is to be applied to all of the currently selected rows/items for the current column.
  • Clear Selection: deselects the currently selected line(s).

Notes:

  1. Two common reasons for using massaged buy prices are:
    1. To take account of overheads, such as landed charges, agents fees, custom duties and delivery charges, when calculating the selling price.
    2. To maintain a constant selling price throughout the lifetime of the price list, ignoring any changes to the buy price.
  2. It must be remembered that massaged buy prices need to be manually updated (unlike the stock item buy price, which is automatically updated whenever new stock is purchased).
  3. Although several fields can be used in conjunction (e.g. a discount can apply to a base price with a markup), it is recommended that only one field is used for each item line in the grid to avoid confusion (i.e. enter either a discount or an amount or a markup percentage). In addition, only one Massaged Buy Price can be set against a stock code on a price list even if multiple lines are used for price banding.

See Also


Did you find this article helpful?