Great Plains - Payables Management

Our controller has asked for a report with the last 3 months of invoices entered with account of 2100 and WHO entered them?
I am having a hard time finding this information.. If I run the report in SQL, what tables would I use?  THanks!
pstreAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Wayne88Commented:
Is it GP2013?  Do you have Smartlist installed?  If not then you will have to query the database directly (MS SQL)

Check this link
pstreAuthor Commented:
Umm... I asked for the table names in my request -- do you care to elaborate?
Victoria YudinOwner / Dynamics GP ConsultantCommented:
I have a view on my blog that can get you most of this information:
http://victoriayudin.com/2008/11/28/sql-view-to-show-all-gl-distributions-for-ap-transactions/

What it will not have is the user who entered the transaction, as GP does not store that. There is a user who posted (PTDUSRID) and a user who last modified (MDFUSRID) that you can link in from both the PM30200 and PM20000 tables.

Another option for some companies is to get the user from the batch number - for example, many of our customers put the initials of the user entering invoices into the batch number.

Hope this helps.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Steve EndowMicrosoft MVP - Dynamics GPCommented:
Victoria's view and guidance is your best bet.

I've found that many GP questions that involve the word "Who" can be tough to answer, since GP just doesn't track or store that info by default.

I have a blog post that discusses this challenge in the context of GP's Activity Tracking feature.  If you anticipate that you may be asked to answer GP "who" questions in the future, you might consider selectively enabling Activity Tracking.  As I note in my post, I would only enable the minimum tracking that you think you might need.

http://dynamicsgpland.blogspot.com/2010/04/dynamics-gp-activity-tracking.html

If you need a more comprehensive solution, you might want to consider Rockton Auditor or FastPath.

Thanks,

Steve Endow
Microsoft MVP - Dynamics GP
Dynamics GP Certified IT Professional
pstreAuthor Commented:
Thanks, Victoria - this worked!!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Tax / Financial Software

From novice to tech pro — start learning today.