Small and medium business | Business Central, N...

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

(1) Share

Report

Posted on by CU15101146-0

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:

Dynamics 365 Business Central

All responses (8)

Answers (0)

CU15101146-0 9 on at

Like (1)

Report

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 74,036 Super User 2024 Season 2 on at

Like (0)

Report

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)

https://yzhums.com/43183/

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 4,744 on at

Like (1)

Report

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. 4,744 on at

Like (1)

Report

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 12,290 Most Valuable Professional on at

Like (1)

Report

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

Hi

You could rely on configuration packages.

Microsoft Dynamics 365 Business Central: How to Export and Import Data (Using Configuration Packages) | Dynamics 365 Lab (yzhums.com)

Definitive Guide To Configuration Packages In Business Central - Business Central Geek

Best

GR
Suggested answer

Valentin Castravet 24,910 Super User 2024 Season 2 on at

Like (1)

Report

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.

Valentin Castravet
Work: Zander ERP Services
Blog: Dynamics 365 Business Central Insights
LinkedIn: www.linkedin.com/in/valentin-c-0500a247/
CU15101146-0 9 on at

Like (0)

Report

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 12,290 Most Valuable Professional on at

Like (1)

Report

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.

Export your Business Central data to Excel - Business Central | Microsoft Learn

Best

GR