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

Edit purchase prices in Excel

(0) ShareShare
ReportReport
Posted on by 15

Hi there,

Fully new hear ;-)

We are just implementing Dynamics in to our business and I am unable to find out why I am unable to open / edit the “purchase prices” in excel directly from Dynamics. There is just no button available in the menu. I find this strange since we are able to do this directly in “sales prices” and “item vendor catalog” via the edit in excel button.

To make clear what I am missing I added the images below.

Just to give some background. We are have large QTY items which we sometimes have to edit/ add and where pricing changes a lot. For that reason we would like to be able to update these. If any better suggestions please let me know.

Hopefully anyone can help me out here :-) THX!

Ruud van den Bergh

Item vendor works perfect:

dynamics-1.png

dynamics-2.png

As you can see below it does not show the option to edit in excel..

dynamics-3.png

  • Ruud van den Bergh Profile Picture
    15 on at

    Anyone? Hopefully anyone can help by telling me what i am doing wrong :-)

    Many thanks Everyone!

  • Teddy Herryanto (That NAV Guy) Profile Picture
    14,306 Super User 2026 Season 1 on at

    I think it has something to do with the way they design the page. The excel button is just not available on that page.

  • Suggested answer
    Olister Rumao Profile Picture
    4,009 on at

    Hi,

    Just as Teddy said, even I have the same opinion.
    Although if you want you add the Excel Button, we can add it by customizing through an extension.

    But if you want Excel feature without customizing, you can make use of Configuration Package.
    https://docs.microsoft.com/en-us/dynamics365/business-central/admin-how-to-prepare-a-configuration-package

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 757 Super User 2026 Season 2

#2
YUN ZHU Profile Picture

YUN ZHU 451 Super User 2026 Season 2

#3
AndrewThomas81 Profile Picture

AndrewThomas81 391 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans