GLItemQuantity Function

Description

The GLItemQuantity function returns the summarizied quantity of an item based on a set of parameters.

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	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	Specifies whether to include only Posted or Non-Posted transactions. P is default for Posted. NP is Non-Posted.	No
Currency	If left blank, will default to the currency defined by the Subsidiary.	No
Custom Segment Parameters	Custom segment filter values. Multiple custom segments can be specified.	No

Remarks

• Drilldown is available for GLItemQuantity values.

Example

Let's say you want to analyze the GLItemQuantity for all in stock Blades. First, set up a report with the needed parameters for the function which will include Subsidiary, Fiscal Year, Period, Period Range, and Account in Review (1210 - Inventory Raw Component Stock). Below these parameter cells, you will want to incldue a spot for Item and Item Name (utilize the function GetListInfo to easily return the Item Name) and Quantity.

1. Start by selecting Finsyte Functions > GLItemQuantity
2. Fill in your arguments, use the F4 key for hardcoded values as needed.
   1. 
3. Select OK to see the first quantity returned. Drag the function down to apply to the other items.
   1.