Invoice and Check Detail query in Dynamics

So i can update an external database, I am needing to create a view in MS Dynamics which holds all the  information relating to invoice processing with the following fields:

Receipt Number (for PO Invoices)
Voucher Number
Vendor ID
Vendor Name
Invoice Number
Invoice Date
Batch Number
PO Number
Check Number (which paid the invoice)
Check Date

There may be instances where one invoice is paid from multiple checks.  If i need to create two views, one for invoices and the other for the distributions, that would work as well.

Any help would be appreciated!
Vinny JohnsonAsked:
Who is Participating?
 
Victoria YudinConnect With a Mentor Owner / Dynamics GP ConsultantCommented:
Vinny,

If you're using Dynamics GP, I have views on my blog that (I think) will address what you're looking for. If not, they will get you very close. Here is the page for payables code: http://victoriayudin.com/gp-reports/payables-sql-views/.
0
 
Feridun KadirPrincipal ConsultantCommented:
Which Dynamics product is your question for?
0
 
Vinny JohnsonAuthor Commented:
Sorry...should have specified we are running Dynamics Version 12.0 running on SQL 2012 backend
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
Feridun KadirPrincipal ConsultantCommented:
Ah but you need to say which product, is it AX, GP, NAV......?
0
 
Vinny JohnsonAuthor Commented:
Thank you for the answer and link to the sql views that was EXACTLY what i was looking for.  Sorry it took so long for me to reply....I got pulled into another project
0
 
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Excellent - glad that helped!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.