How To: Set a Stock Item Price Against a Customer

  1. Open a Promotion screen (show me how).
  2. Select the [ Price Lists | Stock Item/Customer ] tab.
  3. Click BtnGreenOpen.jpg and locate the required customer.
  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 to add more stock items if necessary.
  8. Press Ctrl+S or click the disk icon is the button bar's SAVE button to save.


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

See Also

Did you find this article helpful?