The GL function is the fundamental F9 formula, as it links any cell in your spreadsheet to any balance in your General Ledger. This is accomplished with a string of parameters that tell F9 what balance you would like returned.
The syntax of the GL formula is: =GL (Account, Period,Organization, Year, Activity, Class).
- Account = General Ledger account number
- Period = Fiscal period
- Organization = Specific organization (Database)
- Year = Fiscal year
- Activity = Account type activity we wish to see (Actual or Budget)
- Class = Fund class (restricted, unrestricted, temporarily restricted)