Utility Functions

Utility functions help make it easier for Finsyte users to return needed information dynamically based on parameters.

The utility function list includes:

• GetListInfo: The GetListInfo function makes it easy to return any needed list information based on a list's name, number, or identifying field.
• GetParentListInfo: The GetParentListInfo function allows users to return list information, similar to the GetListInfo function, one level above the current result. For example, this function can be used to show parent subsidiaries using the subsidiary name as an input.
• LastDataRefresh: The LastDataRefresh function makes it easy to see when information was last returned from NetSuite. This includes Cached and NetSuite data.
• Range Functions: The Range Functions help return a dynamic array of values either vertically or horizontally based on the input parameters. The dynamic array returned is a native Excel feature and any Excel function that works on a dynamic array can consume the values returned by these functions.
  • Accounts Range
  • Classes Range
  • Departments Range
  • Entities Range
    • Companies Range
    • Contacts Range
    • Customers Range
    • Employees Range
    • Generic Resources Range
    • Groups Range
    • Other Names Range
    • Partners Range
    • Projects Range
    • Project Templates Range
    • Vendors Range
  • Items Range
  • Locations Range
  • Subsidiaries Range
• SubHasAccess: The SubHasAccess function is one that is utilized inside of the GL Accounts List that can be returned by selecting From List > GL Accounts. This function makes it easy to select a Subsidiary and identify if a list item, like GL Account Number, is accessible under that subsidiary in NetSuite. Please review the Subsidiary Has Access section for more information about utilizing this feature in the GL Accounts list.
• SavedSearch: The SavedSearch function makes it easy to load data from NetSuite through existing saved searches. Data is returned as a dynamic array, which makes it seamless to integrate with Power Query for more advanced data modeling.
• Dataset: The Dataset function makes it easy to load data from NetSuite datasets. Data is returned as a dynamic array, which makes it seamless to integrate with Power Query for more advanced data modeling.
• Query: The Query function makes it easy to run ad-hoc SuiteQL queries against NetSuite. Data is returned as a dynamic array, which makes it seamless to integrate with Power Query for more advanced data modeling.