JetExpress for GP - normal balance and inactive accounts

Two quick questions for someone new to JetExpress for GP.

First - GL account typical balance setting - debit vs. credit.
When using the GL function to insert balances, is there any way to have the returned balance automatically returned as positive or negative based on the typical balance debit/credit setting on the GL account in GP? I'm not seeing it if it's there.

I can work around it, but it means more row replicator sections and manual adjustments to the cells containing GL function to reflect the normal balance properly.

Second - excluding inactive accounts.

Using the GL function to insert a set of rows using an account category.
The row replicator expands the list of accounts but includes inactive GL accounts as well.

Is there any way to exclude inactive accounts? Those clutter the report with undesired info. Again, we can work around the issue by creating additional sections to manually exclude the inactive accounts or not using account categories if they contain inactives.

Jet Reports Historic Posts August 01, 2016 21:47

Hi Paul,

Question 1:
The GL() function doesn't allow you to filter or pull back the balance of an account based on the typical balance field. You have a great solution in simply using Excel to reverse the sign based on the account number range.

I must admit that if you were using Jet Professional, this would be a bit easier.

Question 2:
Answering this all depends on what you mean by an "inactive account". If you mean to not display an account because the balance/net change of the account is 0, the answer is yes. You can use Conditional Hide to hide away any rows you don't want to see. Jet has a nice KB article on how to implement this into a report: https://jetsupport.jetreports.com/hc/en … -or-Sheets

Does this help?

JetExpress for GP - normal balance and inactive accounts

1 comment