Hello - I'm customising a report in Quickbooks Online and can't figure out how to Filter using the No. field. I want to filter so that it only shows transactions where No. is in the range 1 - 200000. (In desktop QB when you filter by Number it has boxes for min/max of range - I'm trying to duplicate this behaviour; what this does for us is to show cheque transactions, which are numbered, and ignore all other non-numbered transactions.) Can anyone help or point me to a reference guide on how to filter by this column please? Thanks!
Hi Ashleigh. It started as a "Transaction List by Date" report. Cheques that we write have a number in the No. column eg. 6963. If I filter on the No. field for just "6963" and it exists within the specified date range, it finds the transaction, no problem. But I actually want a list of all the cheques written in a month, quarter or year, and I might not know their numbers, so I wanted to put in a range of numbers e.g. 1 to 200000. I tried "1 to 200000", "1-200000", ">0" - all of these produce blank reports.