web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Managing pricelist data

(0) ShareShare
ReportReport
Posted on by 15

Hi All,

We have just updated BC365 with the new pricelist functionalities. I am having issues finding the correct way of managing our data. We have about 200.000 different articles and about 20 different suppliers. We would like to put in the Purchase prices and discounts in to the system for each product and each supplier. Only specific items are supplied by a specific supplier.

What is the best way to manage this?

I see when you go in to a article and you select “prices & discounts" --> Purchase prices the next page (price list lines) you are able to select edit in excel. Only issue is here it does not allow you to add or delete any products. Only edit the existing ones.

If next we click on “Open pricelist” I unfortunately don’t have the option here to Edit in excel. We are only able to open in excel so this Is also no option.

I did try and do it true the suggest lines function but I can’t seem to figure that out. I am able to get all items in there but this is also not the wanted result since not always all items are supplied by a specific supplier. We just want to add the specific lines for that supplier. And with lets say 5000 lines it is not easy to delete the ones which are not carried by the specific supplier.

Hope one of you knows what I mean by this and you know an effective way of working to get this going.. I am probably seeing this wrong.

Many thanks for your support and please let me know how I can support you in any way.

Thank you.

I have the same question (0)
  • Suggested answer
    Andy Sather Profile Picture
    Microsoft Employee on at

    Hello,

    If you don't get further responses to this issue, you may want to raise a support request to Microsoft support via your CSP / Partner.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,003 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,225 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans