Skip to main content

Notifications

Announcements

No record found.

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.

  • Suggested answer
    Andy Sather Profile Picture
    on at
    RE: Managing pricelist data

    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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

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

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 2,655

#2
Mansi Soni Profile Picture

Mansi Soni 1,574

#3
YUN ZHU Profile Picture

YUN ZHU 1,453 Super User 2025 Season 1

Featured topics

Product updates

Dynamics 365 release plans