Displaying Total Payables and Total Payments on the same line
We have create a AR Payment report displaying Total Payables and Total Payments from a customer.
Customer No | Document Number | Clearing Document Number | Total Payables (Invoice Amount) | Total Payments (Clearing Document Amount)
all on one line.
The problem with this is that, Clearing Document in itself is a Accounting Document and it currently displays two lines:
Customer | Document No. | Clearing Document Number | Amount
ABC | 1234 | 9999 | $100
ABC | 9999 | 9999 | ($100)
Is there any way, I can get a single line out of the 2 lines of output that I currently get; i.e have the Invoice Amount and Clearing Document Amount on the same line and suppress the Actual Clearing Document line (line 2)
Customer | Document No | Clearing Document No | Total Payables | Total Payments
ABC | 1234 | 9999 | $100 | ($100)
Any answers/suggestions/comments welcome.