Microsoft have announced that they are making the ‘New Pricing Experience’ mandatory in Business Central, according to Wave 1 2026 release information.
This purpose of this article is to give you an idea of how this will impact your current price lists, and what new functionalities you are going to have available to you.
First things first, there is nothing to worry about. When the update happens, Microsoft will take your current price lists and convert them into ‘Sales Price Lists’/’Purchase Price Lists’. You will keep all your current data.
It is worth mentioning here that Microsoft first announced the New Pricing Experience in 2020 and it has been an optional module since then. Microsoft are now saying that the New Pricing Experience is to become mandatory in the V28 2026 release (but they have said these things before, so take it with a pinch of salt!).
If you don’t know whether you are on the new or old pricing experience, search ‘sales price lists’ in the tell me box in Business Central. When you try to open the relevant page, you will either see a message telling you to activate the New Pricing Experience (meaning you’re on the old experience), or sales prices lists will just open (meaning you are on the new experience).
What’s the Difference?
Old Pricing Experience
In the old pricing experience, your prices were stored in the Sales Price table
When you open a price list from a customer/vendor card, you would only see prices for that customer/vendor, because filters are automatically applied when the page opens
If I clear the filters, we can see all sales prices for all customers/customer discount groups etc, combined into one list.
To summarise – in the old pricing experience, your prices are actually stored in one big price list, but when you open them from a customer card, filters are applied.
New Pricing Experience
When the new price experience is enabled, you will be able to create separate price lists based on individual customers, customer price groups and customer discount groups, etc. (the same is true for vendor prices).
For example, in the below screenshot I have separated price lists for individual customers (Adatum and Trey 2025), Customer Price Group DEALER, and Customer Discount Group 10%.
**IMPORTANT – when Microsoft apply the new pricing experience, all your current prices will be copied into one price list titled ‘DEFAULT’ (or something similar), as per price list S00001 in the above screenshot.
New Pricing Experience Functionalities
The purpose of the New Pricing Experience is to give you more control over price list changes.
Price list Increases
Let’s say that you need to increase your prices for a certain customer.
Here I have a price list that only applies to customer TREY, which is only for the year 2025. I am going to increase these prices by 5% for the year of 2026.
Option 1- Copy an old price list
Create a ‘+New’ price list.
Give the price list a description, choose ‘customer’, then choose the customer code. Then click ‘Copy Lines’.
Use the three dots to choose the price list you want to copy from
Choose the price list you want to copy (in my case, the 2025 price list for customer TREY).
Enter your adjustment factor (in my case, 5%), and a rounding method. Then click ’OK’.
My prices have been copied from the old price list and increased by 5%. I then entered a starting & ending date of 2026.
To start using the price list, change the ‘Status’ to ‘Active’ (if there are other prices for this customer for this item, the system will ask you to ‘Verify’).
Your price list is now active.
Option 2- Edit in Excel
If you do not want to create a new price list and you would prefer to just edit the old one, either overtype the prices in Business Central, or use ‘Edit in Excel’ on the price list lines.
(Edit in Excel allows you to export lines to Excel and make the relevant changes, then ‘Publish’ them back into Business Central).
Choose Which Items To Include in a Price List
If you want to add certain items to a price list without having to go through them manually, you can use filters to add groups of items to price lists.
In your price list, click ‘Suggest Lines’.
Click the three dots to add a filter –
In this example I am adding items that have the ‘Item Category Code’ of ‘CHAIR’, into my price list.
The items are now added, and I can update the prices as needed.
Summary & Help Text
- When the update happens, your prices will be converted into one ‘Sales Price list’ and/or ‘Purchase Price List’.
- Microsoft have advised the New Pricing Experience will be made mandatory as part of the V27.3 update (but they have made promises like this before, so take it with a pinch of salt). I recommend you enable the New Pricing Experience in a sandbox to test it before it happens in your live data.
- Day to day usage of prices will stay the same (prices will be automatically applied as usual).
- You do not need to split your prices lists out if you do not want to. You can continue to use the ‘DEFAULT’ price list which will be created by Microsoft when the update happens.
- You will not be forced to use new functionality, but the New Pricing Experience offers new functionalities that will likely make your life easier and make updating price lists much faster.
This article does not cover all the functionalities that the New Pricing Experience offers. If you want to learn more, follow this link
Need advice on using pricing in Business Central?
Get in touch with a member of the Qi team today!