GL Function Reference
GL Function (What,Arg1,Arg2,Arg3,...,Arg22)
The GL function is available for Dynamics NAV databases, and Dynamics GP databases.
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.
For details, see one of the following:
-
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)
-
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 (J f x) is a convenient tool for entering the GL Function.