Vendor list including countries

(0) Share

Report

Posted on by Heleen M

Hi,

I'm looking for a way to export the entire vendor listing including the adresses.

Any idea?

I have the same question (0)

All responses (5)

Answers (2)

Verified answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

You can use the below.

Vendor v2

Partypostaladdress

Was this reply helpful? Yes No
Heleen M 20 on at

Like (0)

Report

Hi Ramit,

Thank you for your answer, can you please elaborate a bit more?

I'm pretty new to D365.

Thank you!

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Heleen M,

A vendor can have multiple address records.

Which one do you want to export and why?

Do you make use of a separate address purpose type that you are looking for?

Some additional information would help.

Many thanks,

Ludwig

Was this reply helpful? Yes No
Heleen M 20 on at

Like (0)

Report

Hi Ludwig,

We're looking to export a vendor list (from all vendors in the finance & operations module).

This listing will include the supplier number, the name and the country of the primary address.

If the entire address is included, this is also fine, but for reportingpurposes we need only the country.

Hope this clears things up :).

Kind regards,

Heleen

Was this reply helpful? Yes No
Verified answer

André Arnaud de Cal... 301,025 Super User 2025 Season 2 on at

Like (0)

Report

Hi Heleen,

You can use the 'Open in Excel' button at the right-top corner to open the vendor details in Excel. With the embedded Dynamics connector, you can design which columns should appear in Excel. You can also refresh the data.

Note that a normal business user should have explicit permissions on the data entity used for the 'Open in Excel' option.

Was this reply helpful? Yes No