GLAccountTypeBalance Function

Definition

The GLAccountTypeBalance provides the third highest level of grouping for accounts and utilizes the AccountType 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 Type	Valid Account Type 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 Type 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 Type Balances for Bank, Accounts Receivable, Fixed Asset and Income accounts. You can use the GLAccountTypeBalance 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 > GLAccountTypeBalance
3. Link all function arguments including the Account Type which can either by typed in (ex: "Bank") or selected from a cell reference
   1. 
4. Select OK to see the balance total for all accounts under the umbrella of the AccountType of "Bank"
5. Repeat for the addition types 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 type are shown with the GLAccountBalance function.