Sales price setup

You can create a sales price for a specific group of customers. Business Central combines different ways of affecting a price, like defining a specific price, discount or a combination of both for a group of customers. These configurations can be performed in the Sales Price List page.

Set up sales price for Bring It To You Ltd. fictional company

  1. Click the Lightbulb button, enter Sales Price List, and choose the related link.
  2. From Item Card access the Sales Price via Special Sales Prices & Discount in the ribbon.
    On an item level, there will be a line or a list if that item is already in a Sales Price of some sort. Otherwise, you need to create a new list by selecting the Sales Price List.
  3. Click Sales Prices & Discount in the Item Card to access the Sales Price card.
  4. Populate the following fields with the values in the Example column:
Field NameDescriptionExample
CodeProvide a code that is used for the price identification.S00010
WholesalesProvide a description for the sales price scheme.Wholesales
Assign-to TypeAssign the pricing to a group or a specific person. You can choose between All Customers, a specific Customer, Customer Price Group, a sales Campaign, a specific Contact.Customer Price Group
Assign-to No.Specify the entity to which the prices are assigned. The options depend on the selection in the Assign-to Type field. If you choose an entity, the price list will be used only for that entity.WHOLESALE
VAT Bus. Posting Gr. (Price)Specifies the default VAT business posting group code.NATIONAL
Price Includes VATSpecifies the if prices used in this scheme include VAT.Enabled
View Columns forSpecify what kind of columns you will have in the detail section.Price
StatusSpecifies whether the price list is in Draft (can be edited), Inactive (cannot be edited or used), or Active status (used for price calculations).Draft
Currency CodeSpecifies the currency code of the price list.
Starting/Ending DatesSpecifies the period during which the price list is active.01/03/2023 – 31/05/2023
Line DefaultsIf flagged, all of the following actions are allowed in the detail lines. Allow Updating Defaults - Specifies whether users can change the values in the fields on the price list lines that contain default values from the header. This does not affect the ability to allow line or invoice discounts; Allow Invoice Disc. - Specifies whether invoice discount is allowed. You can change this value on the lines; Allow Line Disc. - Specifies whether line discounts are allowed. You can change this value on the lines.All enabled
  1. Define the details of the scheme in the Lines section.
    In this example, all customers that benefit from a Wholesale Customer Price Group will pay the item 70004 at a beneficial price of 1,200.00 per unit instead of the default unit price of 1,500.00 within the period between March 1st and March 23rd exclusively.


Next steps

Apply item discount

Item discount is applied in much the same way as described in the main procedure above, the only difference being that instead of defining unit prices, you can define the discount.

In the following example, you’re assigning a discount percentage that all customers will benefit from. If 5 x items with Item Discount Group = A are sold, the customer will benefit from 15% discount on the 5 items.

You can also set a “Wild Card” whereby you include all Items in the scheme. In the last line, the Product Type = Item & The Product No = BLANK. This is a function in Business Central that permits you to give a 3 % on all items to all customers.


Combine sales price with item discount

In this example, you can see that different sales price, item discounts or even a combination of both can be set in the system in one price list. Both pricing and discount setup can be performed in one page instead of having to navigate to each Item card to set up pricing and apply discounts individually.


Set up price worksheet

If you want to update prices for multiple items without having to change settings in each Item Card individually, you can create a Default Price List in the Price Worksheet administrative section.