I noticed a similar thing when the search criteria is not specific enough. I attributed it to a function of a general search in a double entry accounting system.
Yes, I think this has to do with Receipt #2 being automatically allocated by the program. Try changing the filter to Credit is more than 0. But I’m no expert on custom reports.
yes, the problems is customer made payment for some invoices so, we can’t allocate with invoice
now our problems is un-allocated receipts for invoice shown double lines at custom report
That sheds more light on the subject. The receipt was not only unspecified, but was split between multiple invoices. So the transaction shows up for both invoices it was posted to. But your filtering requires that Transaction + Reference contain Receipt. So you are getting the credit amount for the receipt itself. The actual postings against the invoices were not receipts, they were automatic allocations. Try playing with Amount and/or Amount (sign reversed) instead of Credit as a selection. I’m not sure what that might do.
In my case I was able to fix it by also specifying which account the transactions I wanted displayed were in. I assumed the issue is the general ledger has both the credit and debit transactions. So choosing one fixed it.
Edit:
Printing other fields is likely to show what the two records contain so why it prints twice (other fields are likely to be different).
I believe that this might be a bug, the columns “Debit”, “Credit” and “Amount” when used in conditions seem to refer to the transaction totals since I tried adding “Debit = 0” and the query showed no transactions.
I also tried to figure out what happens with unallocated receipts and it seems that there are two Credit rows and one Debit row to accounts receivable. I tried to find the differences between the two Cr rows but I couldn’t find the field that contains the difference.
Proposal 1: I think there should be a "general ledger transactions | row debit, credit, amount … "
Proposal 2: More fields should be available in the query