I am trying to generate a report that shows some invoice detail along with the payment info that applies to the invoice, such as the check or checks that went to pay for the invoice and the dates and amounts etc.
This sounds like it would be an easy thing to create since I can get this info on a per document basis from Inquiry. But I need this in a report form, ie for auditing purposes or to show a vendor their invoices that I have paid.
I am trying to use SmartList Builder because it is easy to create something that I can export to Excel, manipulate, then save as a pipe-delimited file. But it is not immediately clear the relationships between the tables PM30200 and PM30300 and how they are used to provide the functionality in the Inquiry window.
I am surprised that it is not a "canned" report since this is extremely useful info. I also can't imagine that I am the first to try and get this info in a report form.
Can anyone enlighten me? What am I missing?
Thanks.
*This post is locked for comments