I am trying to create a report to show how much we spent per each vendor during a certain pariod.
I am using tables JrnlHdr, JrnlRow and Vendors. I am pulling fields Name, Reference, TransactionDate and MainAmount.
For some reason it is coming up double - it is showing invoice and payment on that invoice. Also it sometimes duplicates the invoice itself.
How can I fix this?
I was trying to filter by JrnlRow.RowNumber (4 - purchase or 2 -cash disbursements) but it does not work.
Thank you.
I am using tables JrnlHdr, JrnlRow and Vendors. I am pulling fields Name, Reference, TransactionDate and MainAmount.
For some reason it is coming up double - it is showing invoice and payment on that invoice. Also it sometimes duplicates the invoice itself.
How can I fix this?
I was trying to filter by JrnlRow.RowNumber (4 - purchase or 2 -cash disbursements) but it does not work.
Thank you.