web
You’re offline. This is a read only version of the page.
close
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

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

I have the same question (0)
  • 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,284 Super User 2025 Season 2 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
    3,967 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,238

#2
YUN ZHU Profile Picture

YUN ZHU 773 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 630

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans