Zero-Row Suppression

This option will be visible only for queries that support it.

Normally, FinJinni Queries will bring back any data rows present in the QuickBooks data and will automatically sum value columns in summary queries. In some cases, this can result in unwanted rows that have all zero values (e.g. a matching debit and credit). If you encounter undesired zero rows, you can use the “Suppress Zero Values” option to filter them out.

Note: This option is checked by default for Balance Sheet queries. You can uncheck it if you want to see the additional rows.