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!
Who is Participating?
Victoria YudinConnect With a Mentor Owner / Dynamics GP ConsultantCommented:

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:
Feridun KadirPrincipal ConsultantCommented:
Which Dynamics product is your question for?
vinny3333Author Commented:
Sorry...should have specified we are running Dynamics Version 12.0 running on SQL 2012 backend
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Feridun KadirPrincipal ConsultantCommented:
Ah but you need to say which product, is it AX, GP, NAV......?
vinny3333Author 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
Victoria YudinOwner / Dynamics GP ConsultantCommented:
Excellent - glad that helped!
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.