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

GL Function Reference


Related Articles...

Overview

=GL (What,Arg1,Arg2,Arg3,...,Arg22)

The GL function is available for Dynamics NAV databases, Dynamics GP databases, and Jet Budgets

Purpose (with NAV or GP):  Returns the budget, balance, net change, debits, or credits of the G/L Account of a given company, based on filters.

Purpose (with Jet Budgets):  Returns the budget value recorded for a given budget, based on filters

For details, see one of the following:

  1. NAV Cronus Examples

    To retrieve the balance of G/L account 44100, you would type the following:

    =GL("Balance","44100")

     

    If you wanted to know the net change of account 44100 between 1/1/2002 and 1/31/2002, you would type the following:

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

     

    For G/L Balances with standard NAV:

    • 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

    For the balance of account "40100" with Global Dimension 1 of "USA" and Global Dim 2 of "COPPER", you can use the following function.

    =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)

  2. GP Fabrikam Examples

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

    =GL("Cell","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("Cell","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("Cell","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 Formula has many parameters so the Jet Function wizard (Jfx) is a convenient tool for entering the GL Function.

  3. Jet Budgets Example

    The GL function can also be used to return values recorded within the Jet Budgets application.  This can be convenient for comparing values between Jet Budgets and either Dynamics NAV or GP.  Or can be used for retrieving data from your Jet budget and importing that data into either NAV or GP.

    To retrieve the value recorded for account number 44100 in the Jet Budget named Budget 2020 for the month of January 2020, you would type the following:

    =GL("JetBudget","Budget 2020","44100","1/1/2020","1/31/2020")

Was this article helpful?
0 out of 0 found this helpful

Comments