News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) SmartList not recogniz...

Microsoft Dynamics GP (Archived)

SmartList not recognizing Purchases Account Number

(0) Share

Report

Report

Posted on by Anorris .

5

I am running GP 2010. I am trying to run a SmartList for Payables Transactions. I can get a list of invoices for the vendor ID that I'm interested in, and when I drill down on an individual transaction, I can of course see the purchase account number in the distribution. However, when I include the Purchases Account Number field in my search criteria, I get a blank list. Am I using the wrong field in my search? I don't see any other options that seem like they could possibly be what I want.

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at

Like (0)

Report

Re: SmartList not recognizing Purchases Account Number

The Purchases Account Number that is available in the out of the box SmartList is the account number on the Vendor Card, not the one on the transaction. You need to use SmartList Builder to create a custom SmartList that will pull in the transaction Purchases Account. Victoria Yudin has a SQL view she created for use in such a SmartList victoriayudin.com/.../sql-view-to-show-all-gl-distributions-for-ap-transactions.

Hope this helps,

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,489 Super User 2025 Season 1

#2

Martin Dráb 231,305 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans