Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Introducing the GL Function




NAV Cronus Examples

=GL("Balance","44100")


=GL("Balance","44100","1/1/02","1/31/02")


  • you can filter on the two Global Dimensions for G/L Balances or
  • if using a NAV Analysis View, you can filter on up to 4 dimensions that are tied to that View

=GL("Balance","40100",,,,"USA","COPPER")

Please note that some NAV verticals that allow more than 2 Global Dimensions may not be compatible with the GL function.



GP Fabrikam Examples

To retrieve the balance of G/L account 000-1100-00, you would type the following:

=GL(,"Balance","000-1100-00")


If you wanted to know the net change of account 000-1100-00 for the 1st quarter of 2002, you could type the following:

=GL(,"Balance","000-1100-00","2002/1","2002/3")


With GP, you can filter on the account number as a whole or you can filter on the individual segments of the account number. So you could also create the last GL function to find the 2002 1st quarter net change for account 000-1100-00 like the following:

=GL(,"Balance",,"2002/1","2002/3",,"000","1100","00")



Note that while some numbers such as 2002 and the start period and end period do not need quotes, "000" and "00" must be quoted so that Excel does not interpret them as numbers and change them to single zeros.

The GL function is not available in Jet Reports Universal.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments