Can someone tell me please what I need to change so as to get only debits for a given period (in the custom report), as listed in bank account. At the moment what I’m getting with the following settings, is both debits and credits.
Probably something I have completely overlooked.
You didn’t show the resulting report. Are you certain you are seeing credits and not, for example, debits originating from credit notes?
It would help to know what you are trying to show with the custom report. Right now, your order and grouping filters are not functional.
Thanks for your help. I know extremely little on how custom reports work. What I’m trying to do is something like the iamge below, but not a mixture of receipts and payments, just one or the other.
Hope this makes sense.
You just need one more filter, for Receipt or Payment as you desire:
Ordering and grouping is optional, depending on whether you have more than one bank account. You can also get reversed results by replacing Debit with Credit in the selection and filtering sections. Then, you would just be catching the other legs of the double entries.
Thank you so much. Exactly what I was after.