What's Cooking in Business Central: Edit Sales Price Lists in Excel
This 3-minute 'What's Cooking in Business Central' episode demos editing sales price lists in Excel, which is stated to ship with 2025 Wave 1. The presenter checks that the 'new sales price experience' feature is enabled in Feature Management, edits a price list, and uses the new Edit in Excel button. A price changed in Excel is then published back to Business Central. The feature had 151 votes on the ideas site and was contributed as open source code by a community developer.
- What's Cooking in Business Central series introduction
- Series format and episode preview
- Enabling the edit sales price list feature
- Creating and testing a sales price list rule
- Demonstrating the new edit in Excel button
- Editing prices in Excel and syncing changes
- Feature origin and open source contribution
Overview
This short episode of the “What’s Cooking in Business Central” series shows how to edit sales price lists in Excel. The presenter enables the feature through feature management, creates and tests a sales price list rule, and then shows the new Edit in Excel button on the price list.
The demo edits prices in Excel and shows the changes syncing between Business Central and the spreadsheet. The episode ends with the origin of the feature: it was a highly requested item on BCIdeas with 151 votes, and a community contributor, named in the transcript as Stepan Sage, wrote the code for it.
Key points
- The capability is described as shipping with Business Central 2025 Wave 1.
- For the demo, the presenter makes sure the ‘new sales price experience’ feature is enabled in Feature Management.
- The sales price list page now shows a new Edit in Excel button that was not there before.
- Prices changed in Excel can be published back, and after a refresh Business Central shows the updated price (800 changed to 700 in the demo).
- The demo edits the existing default sales price list to add a quantity discount (10 or more desks at 800 instead of 1,000) and checks it on a sales invoice.
- The feature was highly requested (151 votes) and was written as an open source contribution on GitHub by community developer Stefan Sage.
Features
| Feature | Status | At | Evidence |
|---|---|---|---|
| Edit sales price list in Excel | announced, demoed | 0:56 | “the edit sales price list in Excel capability which will ship with businessle 2025 Wave 1” (0:56) |
| New sales price experience | status not stated, demoed | 0:56 |
AL objects mentioned
As heard in the captions. A name that matches one object page by exact type and name links to it; the others stay as named.
- table “sales press list” at 1:18
Not found in BC28-30: table “sales press list”.
Quotes
- 0:56 “edit sales price list in Excel capability which will ship with businessle 2025 Wave 1”
- 1:50 “if we go up here you will see a new button edit in Excel which wasn’t there previously”
- 2:11 “how it syns our data from business Central to excel”
- 2:31 “this was highly requested on bcas 151 votes”
- 2:51 “stepan Sage uh took the opportunity and took on this task wrote the code that is necessary to enable this feature”
Disclaimers in the video
- 0:56 preview: will ship with businessle 2025 Wave 1
Presenters (as heard): stepan Sage.