Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Business Central forum / Generate a report with...
Business Central forum
Suggested answer

Generate a report with a list of all vendors with all their details

(1) ShareShare
ReportReport
Posted on by CU15101146-0 2
Hello,
 
I'm trying to export to excel a report with the list of all the vendors in Business Central. The report must contain Name, Fiscal ID, Address, email, Post code..
 
I can't find a report that generates all this information. 
 
Using the tool "Inspect page" (ctr+alt+F1) I can see all those fields in the table in view table, but I can't export them to Excel in that page. 
 
Thanks in advance for your help
 
 
Categories:
Business Central
  • CU15101146-0 Profile Picture
    CU15101146-0 2 on at
    Generate a report with a list of all vendors with all their details
    Thank you all!
     
    I didn't know the functionality that Valentin Castravet  explained me. That worked for me, It was just what I needed
     
    Thank you all for your help,
     
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 70,243 Super User 2024 Season 2 on at
    Generate a report with a list of all vendors with all their details
    Hi, If you don't need all the fields, it will be much faster to use the Open in Excel function.
     
    PS: Business Central 2023 wave 2 (BC23): Add existing table fields to optimize your pages (Adding Table Fields to Page without Page Extensions)
     
    Thanks.
    ZHU
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 2,138 on at
    Generate a report with a list of all vendors with all their details
    If nothing works then you can customised list page by adding fields and you can export that.
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 2,138 on at
    Generate a report with a list of all vendors with all their details
    yes using configuration package u can export vendor table. And as valentine mentiomed you can customize page from the profile.
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 10,067 Most Valuable Professional on at
    Generate a report with a list of all vendors with all their details
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 22,408 Super User 2024 Season 2 on at
    Generate a report with a list of all vendors with all their details
    If you customize the profile (if you go to profiles -> open your profile -> customize pages) you will be able to add all fields from the table to the page. If you personalize, you will only be able to add certain fields to the page. 
     
  • CU15101146-0 Profile Picture
    CU15101146-0 2 on at
    Generate a report with a list of all vendors with all their details
    Hello,
     
    Thank you for your answer, the problem is that when I try to personalize the fields in the vendor list, the fields I need are not included in the list of fields I can add to the view to export the table aftewards.  I'm only able to see those fields using ctrl+alt+f1 and then clicking in "view table". In that view I am able to see all the fields I need, but the button to export to excel is not available there. 
     
    Thank you again
  • Suggested answer
    gdrenteria Profile Picture
    gdrenteria 10,067 Most Valuable Professional on at
    Generate a report with a list of all vendors with all their details
    hi
    You could add the required fields to the vendor list and export them.
    Best
    GR

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

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,572 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,706 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans