SQL – NetSuite Professionals

Question Tag: SQL

All Questions

Filter by

Questions Per Page:

Inventory Activity Detail Report SuiteQL
Hi, I’m using DBeaver and connected via ODBC driver to Netsuite. I want to recreate the Inventory Activity Detail Report …
inventory

inventory detail

SQL

ptl24 Rookie Asked on December 21, 2022 in Reports.
- 106 views
- 1 answers
- 0 votes
Is there a BUILTIN function for Consolidated level currency as we have BUILTIN.CURRENCY_CONVERT() for normal currency conversion.
We are using BUILTIN.CURRENCY_CONVERT() function to get the converted amount. But in the case of consolidated entity level we have …
netsuite

SQL

suitelet

suiteQL

suitescript

aniyanc Rookie Asked on December 18, 2022 in Reports.
- 107 views
- 1 answers
- 0 votes
Record/Table containing SOAP Web Services Log details
Looking for a way to use SQL to pull out the SOAP Web Services Log details for a specific integration. …
Integrations

record

reports

SOAP

SQL

jnola Rookie Asked on October 19, 2022 in Administration.
- 152 views
- 0 answers
- 0 votes
SuiteAnalytics Connect – How to pull dropship/special order PO # from Sales Order or Item Fulfillment
Hi everyone, I’m trying to figure out the join in my SQL query that will pull the CREATEPO or CREATEDPO …
dropship po

Query

SQL

alexander0291 Rookie Asked on August 11, 2022 in SuiteAnalytics Connect.
- 235 views
- 1 answers
- 0 votes
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.
- 244 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

mshparber Rookie Asked on June 8, 2022 in SuiteAnalytics.
- 172 views
- 0 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.
- 509 views
- 0 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.
- 627 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.
- 735 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.
- 539 views
- 0 answers
- 0 votes