Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Introducing the GL Function


Related Articles...

Overview

Reports based on the G/L are easy with the GL function. The GL function is available for both Dynamics NAV and Dynamics GP databases.


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.

 

Please see our GL for NAV Tutorial

(be sure to press the Play button in the lower left corner to start the tutorial)


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