Exclude the records bearing ZERO (0) balance
I am using a script attached, I have a balance sheet and I dont want the records having 0 balance to appear. How can I achieve it.
How is the balance calculated? And in what field?
The balance is calculated in the same table field named TOTAL, the issue is that I want to run more than 1 query:
1. Find by Account Type
2. Find and hide the accounts that have the balance 0
The attached is the layout
I can't help you without more information. If Total is a summary field, you can't specify find criteria in it. To repeat: How do you calculate the balance?
Total is not a summary field, its derived from the Balance field which is using a calculation of the fields Credit-Debit. Total is only a calculation of the Balance field. Its only holding the value of EntryForm::Balance field.
Set field [AccountBook::Total; ">0"]
will specify that only records where total is greater than 0.
Yeah I tried that too Phil but there are balances that are in Debits as well. So I also have to list those
Then you'll need to tell me more about your database design.
A balance that is in a debit? That makes now sense to me.
Yes there are some clients who are in debits as well.
Account Name Credit Debit Balance
John 10000 2000 8000
Steve 4000 1000 3000
Mac 6000 10000 -4000
So, Mac's balance is in -4000
Also you can see the image
Retrieving data ...