Solution Properties
Solution ID:
200427112241033
Last Modified Date:
Thu Apr 18 10:19:11 UTC 2024
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. Let's take a look.

 NOTE: To use price lists you must have Sage 50 Accounts Professional. If you'd like to upgrade, simply 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 may 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, for example, a 5% increase, you should use the Global Changes wizard. 

Set up price lists

When working with price lists you can:

How prices are applied

When there are a mixture of special prices, price lists and customer discounts, Sage 50 Accounts applies them as follows:


Prices are applied as above, however, the invoice and order defaults determine how quantity and value discounts are applied 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 PriceTo calculate the discount for each item of an invoice or sales order from the unit price of the item select this check box. This calculates the discounted price as (unit sales price - discount) x quantity.

    To calculate the discount from the total of each item, clear this check box. This calculates the discounted price as (unit sales price x quantity) - discount.
    Special PricesTo give quantity and value discounts to those customers who have a special price for the product, select this check box.
    Price List PricesTo give quantity and value discounts to those customers who have a price list price, select this check box.
    Standard PricesThe Standard Prices check box is selected by default and can't be amended.
    All CustomersTo apply quantity and value discounts as set up in the customer record, taking into account the options checked for special prices and price lists, select this option.
    Only Customers who are not associated with a Price ListTo apply value discounts when the customer is not attached to a price list and quantity discounts to standard prices when the customer is not attached to a price list, select this option.

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


Calculation methods

Calculation MethodValue
Fixed PriceEnter a fixed price. This price doesn't change if the sales or cost price on the product record changes.
Standard Sales PriceThe value box is not 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 ValueThis option decreases the sales price in the product record by a fixed amount. Enter the required amount.
Markup % on Cost PriceThis 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 PriceThis 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 DirectionRound up toThis option will always round up.
NearestThis 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 toThis option will always round down.
To

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

 NOTE: The number of decimal places depends on what is set in the Unit D.P. in Settings > Product Defaults.

Multiples ofSelect this to round to a multiple of a specific number. You can also add or deduct an adjustment.

For example, if you choose to round up to multiples of 1.00 with an adjustment of -0.01 and your calculated price is 10.2345, the list price will be 10.99. This is because 10.2345 rounds up to 11.00 and the adjustment of -0.01 is then applied.

[BCB:119:Limitless - 50 Accounts - Customers:ECB]
Steps to duplicate
Related Solutions