I am looking for suggestions on how to proceed with creating a BAQ pertaining to AP invoices.
I’m using the APInv tables of: Header, Detail, and Misc.
Assume I have an AP invoice which has three separate lines showing up in results, each line showing is appropriate partnum, qty, price, etc.
But this Invoice also has a Misc Header Charge, which is why I have the Misc table included in this BAQ. I want the BAQ to show the charge description and the amount from the Misc table, but I only want the BAQ results to show it as one line, not with all three invoice lines.
Thank you for any suggestions