GLItemUnit Function

Description

The GLItemUnit function returns the item's unit of measure based on a set of parameters. Items have a default unit of measure assigned to them, but in transactions, they can utilize smaller or larger units which could result in the returned unit from this function differing from the unit seen on the Item List.

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

Example

Let's say you want to analyze the GLItemUnit for a series of items in Inventory now. 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), Quantity (if desired) and Item Unit.

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

Note: As mentioned in the description, all Items also have a default unit outlined in the Items List. Utilize the GetListInfo function to return the unit name if you want to compare units of an item at the argument's level vs the list level.