Set up prices and discounts
Note
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
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.
- Choose the
icon, enter Customers, and then choose the related link. - Choose the customer, and then choose the Prices action.
- 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.
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.
- Choose the icon, enter Customers, and then choose the related link.
- Open the relevant customer card, and then choose the Line Discounts action.
- 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
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.
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
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.
- Choose the icon, enter Customers, and then choose the related link.
- Open the customer page for a customer that will be eligible for invoice discounts.
- 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
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.
- On the Customers page, choose the Invoice Discounts action. The Cust. Invoice Discounts page opens.
- 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.
- In the Minimum Amount field, enter the minimum amount that an invoice must have to be eligible for the discount.
- In the Discount % field, enter the invoice discount as a percentage of the invoice amount.
- 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.
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.
Choose the
icon, enter Sales Price Worksheet, and then choose the related link.Choose the Suggest Sales Price on Wksh. action.
On the Sales Prices FastTab, fill in the Sales Type and Sales Code fields with the original sales prices you want to copy.
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.
If you want the batch job to create new prices, select the Create New Prices check box.
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.
To bulk update item prices
These steps differ, depending on whether your administrator has turned on the New sales pricing experience feature update.
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.
- Choose the icon, enter Sales Price Worksheet, and then choose the related link.
- Choose the Suggest Item Price on Wksh. action.
- On the Item FastTab, fill in the No. or Inventory Posting Group or other fields with the original item prices you want to update.
- 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.
- 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.
- If you want the batch job to create new prices, select the Create New Prices field.
- 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
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.
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.