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!
Our community of experts have been thoroughly vetted for their expertise and industry experience.