Set Up Prices and Discounts

Note

In 2020 release wave 2, we released streamlined processes for setting up and managing prices and discounts. If you're a new customer using that version, you're using the new experience. If you're an existing customer, whether you are using the new experience depends on whether your administrator has enabled the New sales pricing experience feature update on the Feature Management page. For more information, see Enabling Upcoming Features Ahead of Time.

Price and discount strategies for the purchase and sale of items and services are fundamental tools for successful businesses. After you set up the items and services your company buys and sells, you can define what you pay or charge for them, and those amounts will be automatically added to sales and purchase documents.

Setting Up Prices and Discounts

Before you create price lists, you must define your pricing and discount strategies on the Sales & Receivables Setup and Purchase & Payables Setup pages.

You can set up and use two types of discounts:

Discount Type	Description
Line Discount	A discount amount that is given for lines on sales and purchase documents. Typically, line discounts are based on a combination of customer, item, minimum quantity, unit of measure, or period of time that you define for sales and purchases on the Sales & Receivables Setup and Purchase & Payables Setup pages.
Invoice Discount	A discount percentage that is subtracted from sales and purchase document total if the sum of all lines on the document exceeds a certain minimum.

Because sales prices and sales line discounts are based on a combination of item and customer, you can also perform this configuration from the item page of the item where the rules and values apply.

Tip

If an item should never be sold with a discount, leave the discount fields on the item page empty, and do not include the item in any line discount setups.

About Price Lists

Price lists are flexible and let you specify the business partner or activity that they apply to. For example, you can set up one price list that applies to all vendors and customers, or offer special prices or discounts for each business partner, perhaps based on a minimum quantity on purchase or sales orders, or a certain combination of customer, item, minimum quantity, unit of measure, or periods of time. The prices and discounts you define are automatically applied to purchase and sales documents.

Set Up Prices

These steps differ, depending on whether your administrator has turned on the New sales pricing experience feature update.

Current Experience

1. Choose the icon, enter Customers, and then choose the related link.
2. Choose the customer, and then choose the Prices action.
3. Fill in the fields on the line as necessary. Hover over a field to read a short description. Fill a line for each combination that will grant a special sales price to the customer.

New Experience

You can add items and services manually for each line, or you can use the Suggest Lines action to create new prices for selected items, item discount groups, resources, and other product types. If you choose Suggest Lines, on the Price Lines - Create New page you can use filters to select the items or services to include on the price list. You can also specify whether to consider a minimum quantity when calculating prices, the adjustment factor to apply for new price list lines, and the rounding method to apply for prices.

By default, the status of new price lists is Draft. When you're ready to start using the list, you can change the status to Active.

To review price lists and prices that apply for specific customers or vendors, on the Customer or Vendor pages, choose either Sales Price Lists or Purchase Price Lists action. For items and resources, you can view price list lines by choosing Sales Prices or Purchase Prices on the Item and Resource pages.

1. Choose the icon, enter Customers, and then choose the related link.
2. Choose the customer, and then choose the Sales Price Lists action.
3. Choose New to create a new sales price list.
4. On the General and Tax FastTabs, fill in the fields as necessary. Hover over a field to read a short description.
5. To add items to the list, do one of the following:
   • To add many items, choose Suggest Lines, and then enter filter criteria to specify the types of items to add. Optionally, you can also enter some additional settings for the items that are specific to the price list. You can change these later, if needed.
   • To copy items from another price list, choose Copy Lines, and then choose the price list to copy.
   • To add items manually, in the Product Type field, choose the type of product that the price list is for. Depending on your selection, fill in the remaining fields as necessary. Hover over a field to read a short description.
6. To start using the price list, in the Status field, choose Active.

To set up a sales line discount for a customer

These steps differ, depending on whether your administrator has turned on the New sales pricing experience feature update.

Current Experience

1. Choose the icon, enter Customers, and then choose the related link.
2. Open the relevant customer card, and then choose the Line Discounts action.
3. Fill in the fields on the line as necessary. Hover over a field to read a short description. Fill a line for each combination that will grant a sales line discount to the customer.

Note

When you open the Sales Prices and Sales Line Discounts pages from a specific customer, the Sales Type Filter and Sales Code Filter fields are set for the customer and cannot be changed or removed.

To set up prices or line discounts for all customers, a customer price group, or a campaign, you must open the pages from an item card. Alternatively, for sales prices, use the Sales Price Worksheet page. For more information, see To bulk update item prices.

New Experience

1. Choose the icon, enter Customers, and then choose the related link.

2. Choose the customer, and then choose the Sales Price Lists action.

3. Open the price list for which to specify the line discount.

4. Turn on the Allow Line Disc. toggle.

5. Create a new line, or choose an existing line, and then fill in the fields as necessary. Hover over a field to read a short description.

6. In the Defines field, choose either Price & Discount, or just Discount.

7. In the Line Discount % field, specify the discount percentage.

   Tip

   If you're editing an existing line, you can filter the lines by choosing the appropriate option in the View Columns for field.

Work with Invoice Discounts and Service Charges

When you use invoice discounts, the size of the invoice amount determines the size of the discount that is granted. On the Invoice Discounts page, you can also add a service charge to invoices over a certain amount.

Before you can use invoice discounts with sales, you must enter certain information in application. You must decide which customers will be granted this type of discount, and the discount percentages you will use.

If you invoice discounts to be calculated automatically, you can specify this on the Sales & Receivables Setup page.

For each customer, you can specify whether you will grant invoice discounts if the requirement is satisfied (that is, if the invoice amount is large enough). You can define the terms of the invoice discount in local currency for domestic customers and in foreign currency for foreign customers.

You link discount percentages to specific invoice amounts on the Invoice Discounts page. You can enter as many percentages as you need. Each customer can have their own page, or you can link several customers to the same page.

In addition to (or instead of) a discount percentage, you can link a service charge amount to a specific invoice amount.

Tip

Before you start entering this information, it is a good idea to prepare your discount structure beforehand, so it's easier to see which customers to link to the same invoice discount page. For more information about discounts in sales, see Set up discounts for your customers.

To set up an invoice discount for a customer

After you have decided which customers are eligible for invoice discounts, enter the invoice discount code on the customer cards and set up the terms for each code.

1. Choose the icon, enter Customers, and then choose the related link.
2. Open the customer page for a customer that will be eligible for invoice discounts.
3. In the Invoice Disc. Code field, select a code for the relevant invoice discount terms to use to calculate invoice discounts for the customer.

Note

Invoice discount codes are represented by existing customer cards. This enables you to quickly assign invoice discount terms to customers by picking the name of another customer who will have the same terms.

Proceed to set up new the sales invoice discount terms.

1. On the Customers page, choose the Invoice Discounts action. The Cust. Invoice Discounts page opens.
2. In the Currency Code field, enter the code for a currency that the invoice discount terms on the line applies to. Leave the field blank to set up invoice discount terms in USD.
3. In the Minimum Amount field, enter the minimum amount that an invoice must have to be eligible for the discount.
4. In the Discount % field, enter the invoice discount as a percentage of the invoice amount.
5. Repeat steps 5 through 7 for each currency that the customer will receive a different invoice discount for.

The invoice discount is now set up and assigned to the customer in question. When you select the customer code in the Invoice Disc. Code field on other customer cards, the same invoice discount is assigned to those customers.

To copy sales prices

These steps differ, depending on whether your administrator has turned on the New sales pricing experience feature update.

Current Experience

If you want to copy sales prices, such as an individual customer's sales prices to use for a customer price group, you must run the Suggest Sales Price on Wksh. batch job on the Sales Price Worksheet page.

1. Choose the icon, enter Sales Price Worksheet, and then choose the related link.

2. Choose the Suggest Sales Price on Wksh. action.

3. On the Sales Prices FastTab, fill in the Sales Type and Sales Code fields with the original sales prices you want to copy.

4. In the top section of the request page, fill in the Sales Type and Sales Code fields with the type and name you want the sales prices copied to.

5. If you want the batch job to create new prices, select the Create New Prices check box.

6. Choose the OK button to fill in the lines on the Sales Price Worksheet page with the suggested new prices, indicating that they are valid for the selected sales type.

   Note

   This batch job only creates suggestions and it does not implement the suggested changes. If you are satisfied with the suggestions and want to implement them, that is insert them on the Sales Prices page, choose the Implement Price Changes action on the Sales Price Worksheet page.

New Experience

The status of the price list must be Draft.

1. Choose the icon, enter Sales Price Lists, and then choose the related link.

2. Choose the price list to copy, and then choose Copy Lines.

3. Fill in the fields as necessary. Hover over a field to read a short description.

   Note

   You cannot have two lines that have the same settings but different prices. If that happens, a message will display when you activate a price list. You can choose the price to use by opening the list and deleting the incorrect price.

To bulk update item prices

These steps differ, depending on whether your administrator has turned on the New sales pricing experience feature update.

Current Experience

If you want to bulk update item prices, such as increase all item prices by some percentage, you must run the Suggest Item Price on Wksh. batch job. You can find a link to the batch job on the Sales Price Worksheet page.

1. Choose the icon, enter Sales Price Worksheet, and then choose the related link.
2. Choose the Suggest Item Price on Wksh. action.
3. On the Item FastTab, fill in the No. or Inventory Posting Group or other fields with the original item prices you want to update.
4. In the top section of the request page, fill in the Sales Type and Sales Code with the type and name you want the sales prices copied to.
5. If you want the batch job to automatically adjust suggested item prices, enter adjustment in Adjustment Factor field. For example, you would enter 1.15 in Adjustment Factor for 15% increase in item price.
6. If you want the batch job to create new prices, select the Create New Prices field.
7. Choose the OK button to fill in the lines on the Sales Price Worksheet page with the suggested new prices, indicating that they are valid for the selected Item.

Note

This batch job only creates suggestions and it does not implement the suggested changes. If you are satisfied with the suggestions and want to implement them, that is insert them in the Sales Prices table, you can use the Implement Price Changes batch job, which is found on the Actions tab, in the Functions group, on the Sales Price Worksheet page.

New Experience

To update prices for multiple items, you must create a new price list, and then copy the lines from an existing price list. When you copy the lines you can use filters to specify what to copy, and you can specify an integer or decimal number in the Adjustment Factor field to increase or decrease prices. The price list must be in the Draft status. If needed, you can then deactivate the old price list.

Note

You cannot have two lines that have the same settings but different prices. If that happens, a message will display when you activate a price list. You can choose the price to use by opening the list and deleting the incorrect price.

Calculating the Best Price

When you have recorded special prices and line discounts for sales and purchases, Business Central ensures that your profit on item trade is always optimal by automatically calculating the best price on sales and purchase documents, and on job and item journal lines. For more information, see Best Price Calculation.

See also

Setting Up Sales
Sales
Work with Business Central

Find free e-learning modules for Business Central here