GL Account Functions

GL Account functions help make it easier for Finsyte users to return needed financial/general ledger information dynamically based on parameters.

The GL Account function list includes:

• GLAccountBalance: Returns the total balance of a GL Account based on a series of arguments.
• GLAccountCreditBalance: Returns the credited balance of an account based on a series of arguments.
• GLAccountDebitBalance: Returns the debited balance of an account based on a series of arguments.
• GLAccountName: Takes the Account Number as an input and returns the Name (Column: AccountSearchDisplayNameCopy) from the GL Accounts list in NetSuite.
• GLAccountNetIncome: Returns the summarized account balance for all transactions under the account type of Income, Cost of Goods Sold, Expense, Other Income and Other Expense.
• GLAccountRetainedEarnings: Returns the summarized account balance for all transactions under the account type of Income, Cost of Goods Sold, Expense, Other Income and Other Expense. This function will return the summarized balance as of the last period of the previous year based on the inputed argument of Fiscal Year.