Solution Properties
Solution ID:
200427112241033
Last Modified Date:
Tue Mar 11 10:25:36 UTC 2025
Taxonomy Path:
Case category//How do I...//setting up
Author:
[email protected]
Customer price lists and special prices
Description

You can use price lists to set up different product prices and apply them to one or more customers.

 NOTE: To use price lists, you must have Sage 50 Accounts Professional. To upgrade, leave your details and we'll be in touch.

Cause
Resolution

You can use price lists to set up different product prices and apply them to one or more customers. You can group together customers who purchase products from you at a discounted price.

With special price lists, you can set up a different product price for a particular customer. For example, you have a customer who pays a particular price for one product but a trade price for other products.

 TIP: If you want to apply a price change across all products for all customers, use the Global Changes wizard. 

Set up price lists

When working with price lists, you can:

How prices are applied

When there is a mixture of special prices, price lists and customer discounts, the software applies them as follows:

A flowchart which explains how price lists work in Sage 50 Accounts.

 

Prices apply as stated above, but invoice and order defaults determine how to apply quantity and value discounts to special prices and price lists. To set up the invoice and order defaults:

  1. Click Settings then click Invoice Defaults or Invoice & Order Defaults.
  2. Click the Discounts tab.
  3. Select from the following options:
    Discount by Unit Price To calculate the discount for each item of an invoice or sales order from the unit price of the item, select this checkbox. This calculates the discounted price as (unit sales price - discount) x quantity.

    To calculate the discount from the total of each item, clear this checkbox. This calculates the discounted price as (unit sales price x quantity) - discount.
    Special Prices To give quantity and value discounts to those customers who have a special price for the product, select this checkbox.
    Price List Prices To give quantity and value discounts to those customers who have a price list price, select this checkbox.
    Standard Prices The Standard Prices checkbox is selected by default, you can't change this option.
    All Customers

    Select this option to apply quantity and value discounts from the customer record, considering the checked options for special prices and price lists.
    Only Customers who are not associated with a Price List

    Select this option to apply value discounts when the customer isn’t on a price list and quantity discounts to standard prices when the customer isn’t on a price list.

    If you select this option, you cannot choose the Price List Prices checkbox.
    Always apply Value Discounts to special items (S1, S2 and S3) To apply value discounts to S1, S2 or S3 items, select this checkbox.
    Show Discount on Main Invoice/Order Screen To show the discount column on your invoice or order screen, select this checkbox.
  4. Click OK.

 

Calculation methods

Calculation Method Value
Fixed Price Enter a fixed price. This price doesn't change if the sales or cost price on the product record changes.
Standard Sales Price The value box isn’t available as this option uses the sales price in the product record.
Decrease Sales Price by % This option decreases the sales price in the product record by a percentage. Enter the required percentage.
Decrease Sales Price by Value This option decreases the sales price in the product record by a fixed amount. Enter the required amount.
Markup % on Cost Price This option calculates the selling price by increasing the cost price in the product record by a percentage. Enter the required percentage.
Markup Value on Cost Price This option calculates the selling price by adding a fixed amount to the cost price in the product record. Enter the required amount.
Increase Sales Price by % This option calculates the selling price by increasing the sales price in the product record by a percentage. Enter the required percentage.

Rounding Direction
Rounding Direction Round up to This option will always round up.
Nearest This option will round up if the last number is 5 or higher and round down if the last number is 4 or lower.
Round down to This option will always round down.
To

Select this to round to a specific number of decimal places. You can choose up to six decimal places.

 NOTE: The number of decimal places depends on what's set in the Unit D.P. in Settings, then Product Defaults.
Multiples of Select this to round to a multiple of a specific number. You can also add or deduct an adjustment.

For example, if you round up to multiples of 1.00 with a -0.01 adjustment and the calculated price is 10.2345, the list price will be 10.99. 

This happens because 10.2345 rounds up to 11.00, and then you apply the -0.01 adjustment.
[BCB:119:Limitless - 50 Accounts - Customers:ECB]
Steps to duplicate
Related Solutions