• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 135
  • Last Modified:

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!
0
vinny3333
Asked:
vinny3333
  • 2
  • 2
  • 2
1 Solution
 
Feridun KadirPrincipal ConsultantCommented:
Which Dynamics product is your question for?
0
 
vinny3333Author Commented:
Sorry...should have specified we are running Dynamics Version 12.0 running on SQL 2012 backend
0
 
Victoria YudinCommented:
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now