GLAccountDebitBalance Function

Definition

The GLAccountDebitBalance function returns the debit balance only of a GL Account based on a series of arguments.

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, TTD	Yes
Account Number	Valid Account Number	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
Custom Segment Parameters	Custom segment filter values. Multiple custom segments can be specified.	No

Remarks

• There are some accounts from the GL Accounts list that are only accessible from certain subsidiaries. To review this, refer to the SubsidiaryHasAccess column in the GL Accounts list.
• If reversing signs is needed, right click on the balance and select Switch Signs.

Example

Let's say you want to see the account debit balance for your Cost of Goods Sold account (5000) in FY 2024 for your Consolidated Subsidiary as of the current period, you can do this using the GLAccountDebitBalance function.

1. Start by having a place where all required function arguments can be entered.
   1. 
2. Select Finsyte Functions > GLAccountDebitBalance
3. Link all function arguments including Account Number.
4. Select OK to see the balance returned.
   1. 

Note: Right click on the amount to Drill Down into more detailed information about specific account balances.