QBE - Standard Invioce Entry

Hi all,
I want to see all open invoices as of Date January, 31th.
I have picked the checkbox all and see all invoices. in fild "Open Amount" I will filter just all invoices with is not equal to null. I tried !=, !, !=Null, =null.
What can I do so it works?
Thanks in advanced
Best
Sascha

Try >.01 ?

The open amount field is a nuemric field. Open invoices are those where the open amount is not equal ro zero, thus in the QBE field enter "!=0" (without the double quotes of course).

Hi all,

thanks for your posts, but it didn´t work.
When I put !=0 then I see all invoices, paid or unpaid.
When I put >0.1 then I see only the invoices which have been paid up to date.
The problem is, I want to check the G/L account against the debtors book and the balance must be the same. When I pick the box "all" and insert the date, then I see all invoices which have ever been booked and that is really a lot, but I want to see only the invoices which have been unpaid until the inserted date.
Best regards
Sascha