Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Displaying Total Payables and Total Payments on the same line

Hi Experts,

We have create a AR Payment report displaying Total Payables and Total Payments from a customer.

ie.

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.

Thanks,

Vivek

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question