News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) I need a smartlist tha...

Microsoft Dynamics GP (Archived)

I need a smartlist that will pickup expense account numbers that were used for invoices per vendor. I can't seem to find a field name that works?

(0) Share

Report

Report

Posted on by Allison Bruton

35

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

sueconrod 335 on at

Like (0)

Report

Re: I need a smartlist that will pickup expense account numbers that were used for invoices per vendor. I can't seem to find a field name that works?

You can ask for the Purcases Amount and the Purchases Account Number in Smart List but be aware that this will only work if you only have one expense line per invoice. Since this is a one to one relationship on the table. When you have multiple purchases this won't work and you would have to use SmartList Builder in order to get it come show everything.
Mike Smith 6,840 on at

Like (0)

Report

Re: I need a smartlist that will pickup expense account numbers that were used for invoices per vendor. I can't seem to find a field name that works?

Hi Allisson,

Does your organization have SmartList Builder?

I recently had a similar requirement from a client and built a SQL query to analyze this but more from the side of what check was applied and then drilling back to the related purchases account.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans