[mkns]

Hi,

I thought that a Trial Balance Report which filtered out $0 lines (Credit/Debit/amount all equal $0) could be achieved by using something along the lines of a Filter on “Trial Balance – Amount – Not Equal to 0” and/or “Trial Balance – Amount (Debit/Credit) – Not Equal to 0” would achieve this but it simply does not.

I still see lines with Credit/Debit/Amount showing as $0 even with both filters above applied and only showing the Account, Debit, Credit and Amount columns.

Is there something I’m missing?

Thanks for any advice/help!
This is a cached copy. Click here to see the original post.

[frederic.jannelle]

RE: Trial Balance with filter to hide $0 lines.

Have you tried unchecking the ‘Show Zeros’ field under the More Options tab?

[mkns]

Thanks for the suggestion but it was not checked to begin with.

Also, I tried checking “Activity only” and that hides many of the zero lines but still not all.

It seems like I must be missing something because what I’m trying to do seems like such a simple customization of a basic Report Template. Is this behavior at least something anyone can replicate?

[Aminian]

I am unable to reproduce this problem. Have you customized the report?

[chriscorcoran]

Try removing all your filters and then rerun the report using Frederic”s advice above (ie ensure that show 0’s is not checked in the More Options tab).

[mkns]

The only other change I have made to the default report is to “ungroup” (Group checkbox is unchecked) the “Account” column.

Even when this column is “Grouped” though, I still see a couple entries which are 0/0 for credit/debite (and the filter is credit/debit != 0).

Thanks for the replies, I will ask NetSuite for help.

[mkns]

I contacted NetSuite and they confirmed this is a defect (albeit minor) Defect 143466.

The “workaround” is, of course, to export to Excel/CSV and do your own filtering.

[Author]

Posts