How To: Set Stock Item Prices Against a Price List

  1. Open a Promotion screen (show me how).
  2. Select the [ Price Lists | Stock Item/Price List ] tab.
  3. Select the required price list from the drop-down list.
    Note: if the Price List is not listed in the options you will need to create it in System Data before you can add stock items to it. See Creating a Price List below.
  4. Press Alt+E or click the green triangle icon is the buttonbar's EDIT button to enter edit mode.
  5. Press F3 or click the NEW ITEM button has an icon that shows two sheets of paper (identified by having the top right corner folded down), arranged diagonally on the icon from top left to bottom right to add a new item. You can add the same item more than once if you are going to use quantity price breaks. The following columns are read-only:
    • Stock Code and Stock Description.
    • Price: displays the price calculated from other fields e.g. Amount.
    • List Price: is automatically populated by system from the sell price held against the stock item in the stock screen.
    • Massaged Markup%: calculates the new MarkUp% based on the original base Buy Price and the calculated price.
  6. Enter the required information in the relevant columns:
    • Qty breaks Low/High: sets the pricing to only take effect when the order quantities are within the range 1 to 999 (these values can be changed).
    • Amount: price list price to be used.
    • Disc%: discount percentage to be applied to item.
    • Base Markup%: percentage increase to add to Base Buy Price or Massaged Buy Price.
    • Base Buy Price: automatically populated by system from the buy price held against the stock item in the stock screen.
    • Massaged Buy Price: 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 (unlike the stock item buy price, which is automatically updated whenever new stock is purchased).
    • Fixed Buy Price: a static buy price value that can be used with the Base Markup% to calculate the Price.
      Note: the Base Buy Price can be copied into the Fixed Buy Price using the context menu option Reset Fixed Prices.
  7. Repeat for more stock items if necessary.
  8. Press Ctrl+S or click the disk icon is the button bar's SAVE button to save.

Notes:

  • 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%.
  • 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).

Creating a Price List

  1. Open a System Data screen (show me how).
  2. Select [ Sales Order Processing | Price Lists ] tab.
  3. Press Alt+E or click the green triangle icon is the buttonbar's EDIT button to enter edit mode.
  4. Press Ctrl+N or click the New item icon is the button bar's NEW button button on the Button Bar.
  5. Enter the details relevant to the price list and tick the 'Price List' checkbox.
  6. Press Ctrl+S or click the disk icon is the button bar's SAVE button to save.

See Also


Did you find this article helpful?