Custom report help

1

I have a custom report layout to list Payments Only for the organisation’s committee. The problem I have is that it is showing the split up of GST in a Debit Column and the total in a Credit column. It would be simpler to delete the Debit column but that only deletes the amounts not the whole lines. First sample:

Sample with Debit line
Sample with Debit line1652×480 37.6 KB

Second sample without debit column:

Sample no debit line
Sample no debit line1430×330 20.9 KB

The layout for the latter is:

custom layout
custom layout1698×956 73 KB

Is there a way to eliminate those two extra lines with no amounts?
I would be glad of suggestions please.

David

2

Sorry that layout is before deleting the Debit column.

3

Why not try the new advanced query function? Click on the Payments tab and then click on advanced query and create a new one. Click on print below the query to see the resulting view screen.

1 Like
4

This report definition may be what you need

image
image892×577 68.9 KB

5

Thanks but I couldn’t quite figure this one out. The next answer is perfect though. David

6

Thanks so much for this solution. It works perfectly! David