Avatar of Vinny Johnson
Vinny JohnsonFlag for United States of America

asked on 

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!
Microsoft DynamicsMicrosoft SQL Server 2008

Avatar of undefined
Last Comment
Victoria Yudin
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image

Which Dynamics product is your question for?
Avatar of Vinny Johnson
Vinny Johnson
Flag of United States of America image

ASKER

Sorry...should have specified we are running Dynamics Version 12.0 running on SQL 2012 backend
ASKER CERTIFIED SOLUTION
Avatar of Victoria Yudin
Victoria Yudin
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Feridun Kadir
Feridun Kadir
Flag of United Kingdom of Great Britain and Northern Ireland image

Ah but you need to say which product, is it AX, GP, NAV......?
Avatar of Vinny Johnson
Vinny Johnson
Flag of United States of America image

ASKER

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
Excellent - glad that helped!
Microsoft SQL Server 2008
Microsoft SQL Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.

50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo