StatAccountAmount Function

Definition

The StatAccountAmount function returns the amount of a Stat Account in the account's default unit of measure 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 (Must have AccountGroup of Stat)	Yes
Reserved	Ignore	No
Reserved2	Ignore	No
Class	Classification Name	No
Department	Department Name	No
Location	Location Name	No
Entity	Entity Name	No

Remarks

The Reserved and Reserved2 input parameters in the StatAccountAmount function are placeholders to ensure other functions with similar parameters function the same way. They will not be used for this function.

Example

In this example, let's say I want to return the headcount or size of our company's labor workforce for the current Fiscal Year. We can use the StatAccoutAmount function to easily return that value.

1. Start by having a place where all required function arguments can be entered. This will include Subsidiary, Fiscal Year, Period, and Period Range. We are going to be looking at Account 9900 as well which is named Headcount.
2. Select the cell you will be returning the labor count into and select Functions > StatAccountAmount as your function.
3. Fill in or link your required parameters and select OK.
   1. 
4. See the final Headquarter for FY 2024 as 173 employees for my Headquarters (Consolidated) subsidiary.
   1. 

Note: Right click on the returned value to Drill Down into more detailed information about specific statistical amounts.