How to Stop Repeatation in Custom Report

[Syed_Salman_Ali]

made a custom report for pending invoices
Final Out Come

Edit Mode

In Bill its Single Line but Showing Double in Report

[Omnipotent.inc]

Tick the checkbox

Group to collapse 

@Syed_Salman_Ali
And then try to create report again

[Tut]

First, it seems the built-in Aged Receivables report would provide the information you want without the trouble of a custom report.

Second, custom reports list postings to general ledger accounts. Since Manager is a double-entry accounting system, it will list both legs of a transaction. You need to apply Where… filters to eliminate the unwanted legs of transactions.