News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Top 100 vendors

Microsoft Dynamics GP (Archived)

Top 100 vendors

(0) Share

Report

Report

Posted on by Tom Pitts

275

Looking to find, or how to create, a report that will show top 100 vendors by YTD purchases. Thanks

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

kmalone43 894 on at

Like (0)

Report

RE: Top 100 vendors

If you've been closing your fiscal years in the payables module, take a look at the YTD Purchases columm on the 'Vendors' SmartList. Could include all records and sort by the YTD column.
Suggested answer

sandipdjadhav 18,297 on at

Like (0)

Report

RE: Top 100 vendors

Hello Tom,

Please check Victoria's blog for more details - Here is link for you to get top vendors- https://victoriayudin.com/2016/03/21/sql-code-to-show-top-x-percent-of-vendor-data/

For more details check her other sql views that may help you to create reports.

Thanks much

Sandip

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans