troubleshooting Question

Invoice and Check Detail query in Dynamics

Avatar of Vinny Johnson
Vinny JohnsonFlag for United States of America asked on
Microsoft DynamicsMicrosoft SQL Server 2008
6 Comments1 Solution188 ViewsLast Modified:
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!
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 6 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 6 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