SmartList not recognizing Purchases Account Number

(0) Share

Report

Posted on by Anorris .

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

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,633 Moderator on at

Like (0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No