=GL (What, Account, Start Date, End Date,…, Data Source)
Purpose: GL Function returns the budget, balance, net change, debits, or credits of the Dynamics NAV or Business Central G/L Account of a given company, based on filters.
GL function is one of many Jet functions like NF, NP and NL etc. Below are the parameters and their description.
To retrieve the balance of G/L account 44000, you would use the following:
fx =GL(“Balance”,”44000″)
This GL returns the net change of account 44000 between 1/1/2021 and 1/31/2021…
fx =GL(“Balance”,”44000″,”1/1/21″,”1/31/21″)
For the Budget of account 40000 with Business Group Code as CORPORATE, you can use the following:
fx =GL(“Budget”,”40000″,,,,”CORPORATE”)