SuiteQL Query Library

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

Returns basic information about accounting periods.

Returns detailed Accounts Payable information based on a specific vendor.

Returns summarized Accounts Payable information based on a specific vendor.

Returns detailed Accounts Receivable information based on a specific customer.

Returns summarized Accounts Receivable information based on a specific customer.

Returns an Assembly Item and its components.

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

Returns the contents of a specified bin.

Returns a list of empty warehouse bins.

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

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

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

Returns a list of countries that NetSuite supports.

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

Returns historical currency exchange rates.

Returns all custom fields in the account.

Returns all custom lists in the account.

Returns all custom record types in the account.

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

Returns all deposits received from a specific customer.

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

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

Returns a list of customers and their default billto addresses.

Used for generatin a transaction ledger for a specified customer.

Returns customers that have overdue balances.

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

Returns examples of datetime format elements.

Returns information about records that have been deleted.

Returns emergency contact information for employees.

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

Returns employees that have not logged in recently.

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

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

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

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

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

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

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

An obligatory "Hello World" query in SuiteQL fashion.

Returns information about outbound HTTP requests being made.

Returns all item fulfillments for a specified Sales Order ID.

Returns location-specific inventory information for a specified item.

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

Returns a list of customers that purchased a specified item.

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

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.

Returns transactions that impacted an item's inventory level.

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

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.

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

Returns the price for a specified Item Group.

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

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).

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

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

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

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

Returns the running inventory balance for a specified item.

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

Returns the number of active items group by item type.

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

Returns items that have expiration dates.

Returns items that do not have a preferred bin.

Returns journal entry transactions in a given date range.

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

Returns leads assigned to a specified sales rep.

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

Returns a list of locations, including the main address.

Returns all child items for a specified parent item.

Returns a child item and its parent item.

Returns all parent items.

Returns information about item fulfillments and related Pacejet packages.

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

Returns a list of active payment methods.

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

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

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

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

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

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

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

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

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

Used to append a summary row to the result set.

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

Returns sales orders that shipped in a specified date range.

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

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

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

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

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.

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

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.

Returns a list of states that NetSuite supports.

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

Returns details about open support cases.

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

Returns open support cases summarized by status.

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

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

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

Returns the GL impact for a specified transaction.

Returns the GL impact for a specified transaction.

Returns a list status codes for all transaction types.

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).