troubleshooting Question

GP AP Invoicing Question

Avatar of FMCA-IT
FMCA-IT asked on
Microsoft DynamicsMicrosoft SQL Server
18 Comments1 Solution1066 ViewsLast Modified:
Hi all,

I'm trying to create a query in Great Plains for AP Invoices.  I need the results to include the "normal" vendor info(at least the vendorid, but name, etc), the invoice info(like number, entry date,amount, etc), and the G/L accounts to credit and debit.

I have located a few tables that contain some of the data:

pm00200 - Vendor info
pm00300 - Vendor address
pm00400 - Seems to be invoice stuff or at least part of it.
pm30200 - Seems to be paid invoice stuff(i think).

But I don't see anything that necessarily links them together(trxsorce?) and also gets me the Expense and Payable G/L accounts to credit and debit.

Any ideas?

Thank you
ASKER CERTIFIED SOLUTION
Victoria Yudin
Owner / Dynamics GP Consultant

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros