GLAccountSummaryBalance Function

Definition

The GLAccountSummaryBalance rolls up all accounts below a parent account. Account numbers that will return balances here when the HasChildren field in the GL Accounts list is set to True. Review the GL Accounts list to better understand this relationship. If an account has a number under the Parent column, that number is an indication of the summary account that account will roll up to and is referencing the ID column.

For example, in the screenshot below, the accounts with Parent of 1 as seen on the right all rollup to the Account with Id of 1 which is Cash or account number 1000.

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 Number	Valid Account Number with HasChildren set to T for True	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

Unlike other functions, if an account number is used for this function that isn't truly a summary account, the result of "Not summary account" will be returned to that cell.

Example

Let's say you want to see the Account Summary Balances for Cash, Accounts Receivable, Inventory and Accounts Payable. You can use the GLAccountSummaryBalance 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 > GLAccountSummaryBalance
3. Link all function arguments including Account Number
   1. 
4. Select OK to see the balance total for all accounts under the umbrella of the AccountSummary of "Cash"
5. Repeat for the addition summaries 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.