SQL – Page 2 – NetSuite Professionals

Question Tag: SQL

All Questions

Filter by

Questions Per Page:

Need an Item Search where Pricing level ID = X is NULL
Trying to to return a list of items where Shopify Product (custom field) = T and Shopify Price (Price Level) …
formula

item group

items

Saved Search

SQL

roboriccio Rookie Asked on August 2, 2022 in Items.
- 2K views
- 1 answers
- 0 votes
SQL ODBC query to find a last word in memo text
I am using SuiteAnalytics ODBC driver to select data from Netsuite with SQL statements. I need to extract the last …
SQL

Michael Shparber Rookie Asked on June 8, 2022 in SuiteAnalytics.
- 988 views
- 2 answers
- 0 votes
SuiteAnalytics Data Duplication
Trying to figure out a way to remove duplicates. I need to pull all invoices and then show how they …
data

SQL

pmall12 Rookie Asked on December 9, 2021 in SuiteAnalytics.
- 3K views
- 1 answers
- 0 votes
Where do I find Sales Order quantity, units, and rate?
Hi, I need to create an open sales order report and am using the SuiteAnalytics ODBC connection. Can anyone tell …
sales order

SQL

D3 Rookie Asked on October 5, 2021 in SuiteAnalytics Connect.
- 1K views
- 1 answers
- 0 votes
Help with CASE WHEN date is >= 90
I am trying to do a CASE WHEN (first time) and I am having the error field not found. This …
Cases

formula

Saved Search

SQL

ChasePounders Rookie Asked on August 9, 2021 in Saved Searches.
- 2K views
- 1 answers
- 0 votes
Audit of Time Sheet Entry changes ?
Hello, I am trying to create a saved search on “Time” sheet entries to audit if the hours of an …
audit

Saved Search

SQL

suiteQL

timesheet

manik Rookie Asked on May 28, 2021 in Saved Searches.
- 1K views
- 0 answers
- 0 votes
SO remaining amount calculation – ODBC SQL
Hello friends, I want to calculate the remaining amount in SO using SQL queries via ODBC. Total SO amount less …
SQL

Michael Shparber Rookie Asked on May 7, 2021 in Accounting.
- 1K views
- 0 answers
- 0 votes
Manipulating a Formula from Saved Search to Analytics Workbook
Hoping t o find Analytics wizard to help me think of a solution to an issue I am having in …
analytics

formula

Saved Search

SQL

AP_Consulting Rookie Asked on July 30, 2020 in SuiteAnalytics.
- 2K views
- 1 answers
- 0 votes
Filter or Query itemFulfillment using REST API
How do I request the set of related itemFulfillments for a given SalesOrder using the REST API? I know I …
API

filter

itemfulfillment

Query

SQL

Rookie Josiah Rookie Asked on May 15, 2020 in Order Management.
- 4K views
- 2 answers
- 0 votes
Setting up a custom entity: Target date minus 16 weeks
Hello! We give our customers a contract readiness date {custentity1}. In order to meet this date we need to order …
Projects

SQL

Soloflex Rookie Asked on September 25, 2019 in Projects.
- 2K views
- 1 answers
- 0 votes