GLAccountGroupBalance Function

Definition

The GLAccountGroupBalance provides the second highest level of grouping for accounts and utilizes the AccountGroup field in the GL Accounts list to return a summarized balance.

Function Arguments

Argument Name	Input Information	Required
Subsidiary	Subsidiary Name	No
Fiscal Year	Fiscal Year in the format specified in NetSuite	Yes
Period	Period Number (ex: 1 for January)	Yes
Period Range	Valid values include ITD, YTD, RTD, QTD, PTD	Yes
Account Group	Valid Account Group based on options available for review in the GL Accounts list.	Yes
Book	Book Number. Default is 1 if omitted.	No
Item	Item ID	No
Class	Classification Name	No
Department	Department Name	No
Location	Location Name	No
Entity	Entity Name	No
Transaction Type	Transaction Type	No
Posted	Specified whether to include only Posted (P) or Non-Posted (NP) Transactions. Valid values are P (default) or NP.	No
Currency	If left blank, will default to the currency defined by the Subsidiary. Currency Names are listed in the Data Retrieval section of the ribbon.	No

Remarks

Easily add the Accounts Group list next to an account numbers list by using the GetListInfo Function as seen below.

Example

Let's say you want to see the Account Group Balances for Current Asset, Long Term Asset, Current Liability, and Equity accounts. You can use the GLAccountGroupBalance function to return this easily.

1. Start by having a place whereall required function arguments can be entered
   1. 
2. Select Finsyte Functions > GL Level Totals > GLAccountGroupBalance
3. Link all function arguments including the Account Group which can either by typed in (ex: "Current Asset") or selected from a cell reference
   1. 
4. Select OK to see the balance total for all accounts under the umbrella of the AccountGroup of "Current Asset"
5. Repeat for the addition groups to see the separate balances returned
   1. 

Note: Right click on the amount to select Drill Down to Base Accounts which will create a new tab where all accounts under the selected group are shown with the GLAccountBalance function.