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)
Check Number (which paid the invoice)
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!