SuiteQL Query Library

106 SuiteQL queries are currently available.

• Account Subsidiary Map

  Returns a list of general ledger accounts and the subsidiaries that they are mapped to.

• Accounting Periods

  Returns basic information about accounting periods.

• Accounts Payable: Aging Details

  Returns detailed Accounts Payable information based on a specific vendor.

• Accounts Payable: Aging Summary

  Returns summarized Accounts Payable information based on a specific vendor.

• Accounts Receivable: Aging Details

  Returns detailed Accounts Receivable information based on a specific customer.

• Accounts Receivable: Aging Summary

  Returns summarized Accounts Receivable information based on a specific customer.

• Assembly Item With Components

  Returns an Assembly Item and its components.

• Bins: By Location

  Returns a list of bins in a specified warehouse (location).

• Bins: Content

  Returns the contents of a specified bin.

• Bins: Empty

  Returns a list of empty warehouse bins.

• BUILTIN.RELATIVE_RANGES Examples

  Returns the start and end values for all relative date ranges that the BUILTIN.RELATIVE_RANGES function currently supports.

• Company Contacts

  Returns contacts associated with a specified company, including contact names and roles.

• Company Features

  Returns a list of NetSuite features that are avaialble and/or enabled in the account.

• Countries

  Returns a list of countries that NetSuite supports.

• Currencies

  Returns a list of currencies, with symbols, latest exchange rates, etc.

• Currency Rates

  Returns historical currency exchange rates.

• Custom Fields

  Returns all custom fields in the account.

• Custom Lists

  Returns all custom lists in the account.

• Custom Record Types

  Returns all custom record types in the account.

• Custom Segments

  Returns all custom segments, including the names of the tables in which the segment values are stored.

• Customer Deposits

  Returns all deposits received from a specific customer.

• Customer Invoices: By Date Range

  Returns all customer (accounts receivable) invoices for a given date range, with totals and statuses.

• Customer Payments: Application Details

  Returns the invoices to which a customer payment was applied, including sales order numbers, customer PO numbers, and the amounts applied.

• Customers: Billing Addresses

  Returns a list of customers and their default billto addresses.

• Customers: Transaction Ledgers

  Used for generatin a transaction ledger for a specified customer.

• Customers: With Overdue Balances

  Returns customers that have overdue balances.

• Dates and Times: Creation Examples

  Shows how you can create dates and timestamps based on strings.

• Dates and Times: Format Models

  Returns examples of datetime format elements.

• Deleted Records

  Returns information about records that have been deleted.

• Employees: Emergency Contacts

  Returns emergency contact information for employees.

• Employees: Last Logins

  Returns all employees that have NetSuite access, and the date/time that they last logged in.

• Employees: No Recent Logins

  Returns employees that have not logged in recently.

• Employees: Roles and Permissions

  Returns all employees, their assigned roles, and the permissions granted.

• Employees: With Edit, View, Email URLs

  Returns all employees, with edit, view, and email URLs in the results.

• Entities: Types

  Returns all entity types, with BUILTIN.DF and BUILTIN.CF values.

• File Cabinet: Files By Name

  Returns information about a file stored in the File Cabinet, based on a specified file name.

• File Cabinet: Top Level Folders

  Returns a list of folders in the root of the File Cabinet.

• General Ledger Impact by Transaction Type

  Returns all transaction types and the general ledger accounts that they post to.

• General Ledger Transactions by Account and Date Range

  Returns all of the transactions that were posted to a specified general ledger account in a specified date range.

• Hello World

  An obligatory "Hello World" query in SuiteQL fashion.

• HTTP Requests - Outbound

  Returns information about outbound HTTP requests being made.

• Item Fulfillments: for Specified Sales Order

  Returns all item fulfillments for a specified Sales Order ID.

• Items: Aggregate Information by Location

  Returns location-specific inventory information for a specified item.

• Items: Customer Upsells

  Returns a list of potential upsell items and item categories for a specific customer.

• Items: Customers That Purchased A Specific Item

  Returns a list of customers that purchased a specified item.

• Items: Expired or Expiring Soon

  Returns items that have expired, or are about to expire within a certain number of days.

• Items: Frequently Sold Together

  Returns a list of items that are frequently sold along with a specified item. This can be used to implement the "cross-selling" sales technique.

• Items: Inventory Impact Transactions

  Returns transactions that impacted an item's inventory level.

• Items: In Alternate Warehouse Bins

  Returns items that are in stock and stored in bins that are not the item's primary bin.

• Items: Inventory Analysis

  Designed for inventory analysis, this query returns active items, various quantities (on hand, committed, available, reorder point, preferred stock level), the preferred vendor, the average resale price and purchase cost, quantities sold (in the last 30 days, 90 days, year, and lifetime), and more.

• Items: Item Group Members

  Returns members of an Item Group, including their list prices.

• Items: Item Group Prices

  Returns the price for a specified Item Group.

• Items: Item Groups

  Returns a list of items that are setup as Item Groups.

• Items: Item Information

  Returns detailed information about items that have been created or updated in the past 7 days. Item information includes the preferred vendor. Used in project involving development of a custom Product Information Manager (PIM).

• Items: Pricing

  Returns price information, including price levels, for a given item.

• Items: Item Types and Counts

  Returns a list of the types of items that are setup, and the count for each item type.

• Items: Returned Items by Date Range

  Returns a list of items that were returned the most frequently in the previous year.

• Items: Quantity Available Has Changed

  Returns a list of items whose quantity available has changed since a specified date.

• Items: Running Inventory Balance

  Returns the running inventory balance for a specified item.

• Items: Standalone Items

  Returns a list of items that exist entirely on their own, independent of a parent or child item.

• Items: Summarized by Type

  Returns the number of active items group by item type.

• Items: Vendors

  Returns a list of vendors that can provide a specified item.

• Items: With Expiration Dates

  Returns items that have expiration dates.

• Items: Without Preferred Bins

  Returns items that do not have a preferred bin.

• Journal Entries: In Date Range

  Returns journal entry transactions in a given date range.

• Journal Entries: With Details

  Returns journal entry transactions in a given date range, with line level details.

• Leads: For A Specific Sales Rep

  Returns leads assigned to a specified sales rep.

• Leads: Summarized by Sales Rep

  Returns a summarized list of sales reps and the number of leads that they've been assigned.

• Locations

  Returns a list of locations, including the main address.

• Matrix Items: Child Items by Parent

  Returns all child items for a specified parent item.

• Matrix Items: Child Items

  Returns a child item and its parent item.

• Matrix Items: Parent Items

  Returns all parent items.

• Packages: Pacejet Package Information

  Returns information about item fulfillments and related Pacejet packages.

• Pagination and Record Count Example

  Returns paginated results that includes the total number of rows found.

• Payment Methods

  Returns a list of active payment methods.

• Phone Calls

  Returns calls related to a specific company, contact, etc.

• Purchase Orders: Summarized by Status

  Returns the various statuses of purchase orders, with the number of orders in each status, and the total amounts.

• Purchase Orders: Item Receipts

  Returns items that have been received against POs in a given date range.

• Purchase Orders: Related Transactions

  Returns a list of a purchase order's related transactions, including prepayments, item receipts, vendor bills, and more.

• Returns Authorizations: In Date Range

  Returns a list of Return Authorizations (RAs / RMAs) that have been issued in a specified date range.

• Returns Authorizations: Summarized by Customer

  Returns a list of Return Authorizations (RAs / RMAs) that have been issued in a specified date range, summarized by customer.

• Returns Authorizations: Summarized by Item

  Returns a list of Return Authorizations (RAs / RMAs) that have been issued in a specified date range, summarized by item.

• Roles: Active Roles Not Used Recently

  Returns the active roles that haven't been used in the past 90 days.

• Roles: Active Roles And The Date Last Used

  Returns all active roles, and includes the date that each role was most recently used.

• ROLLUP: Oracle Command Example

  Used to append a summary row to the result set.

• Sales Order: With Sales Tax

  Returns header-level values for a specified Sales Order, including the Tax Total value sourced from the related TransactionLine records.

• Sales Orders: Shipped

  Returns sales orders that shipped in a specified date range.

• Sales Orders: Summarized by Status

  Returns the various statuses of sales orders, with the number of orders in each status, and the total amounts.

• Sales Orders: Top Orders for the Current Day

  Returns the top sales orders of the day, based on the estimated gross profit.

• Sales Pipeline

  Returns a list of sales orders that are scheduled to ship in a specified date range.

• Sales Terms

  Returns a list of sales terms (also referred to as "Terms of Payment") that are setup in the instance.

• Shipments: Details

  Returns detailed shipment information based on date criteria. Includes the customer, sales order, customer po, the warehouse, that it shipped from, carrier / method, total weight, number of items shipped, tracking number(s), and the items / quantities that shipped.

• Shipments: Inbound

  Returns all inbound shipments, including expected and actual ship dates, expected delivery dates, and more.

• Shipments: Outbound

  Returns all shipments (item fulfillments) made within a specified date range. Includes tracking numbers, package information (ship from and to addresses, weight, shipping / handles charges), and more.

• States

  Returns a list of states that NetSuite supports.

• Support Cases: Closed: Summarized by Assignee

  Returns closed support cases summarized by the employee that they are assigned to.

• Support Cases: Open: Detailed

  Returns details about open support cases.

• Support Cases: Open: Summarized by Assignee

  Returns open support cases summarized by the employee that they are assigned to.

• Support Cases: Open: Summarized by Status

  Returns open support cases summarized by status.

• Taxes - AvaTax Transaction Logs

  Returns information about the AvaTax API calls that were made for a specified transaction.

• Transaction Line Usage

  Returns the number of Transaction Lines generated in the last 6 months, grouped by transaction type.

• Transaction Counts: By Type and Status

  Returns the total number of transactions in each type / status combination.

• Transactions: GL Impact

  Returns the GL impact for a specified transaction.

• Transactions: GL Impact: Revisited

  Returns the GL impact for a specified transaction.

• Transactions: Statuses

  Returns a list status codes for all transaction types.

• Vendors: Vendor Information

  Returns detailed information about vendors that have been created or updated in the past 7 days. Used in project involving development of a custom Product Information Manager (PIM).