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.
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!
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?
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
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.
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/.