SQL – NetSuite Professionals

Question Tag: SQL

All Questions

Filter by

Questions Per Page:

Netsuite SuiteQL query to get access token created before 2800 days ago
I am trying to get access tokens with below condisions, inactive is false, token creation date is before 2800 days …
DateTime

netsuite

SQL

suiteQL

suitescript

Maira S Beginner Asked on March 22, 2025 in SuiteScript.
- 685 views
- 1 answers
- 0 votes
Can I use subquery in SuiteQL?
Hi, I want to create a custom report using SuiteQL. I need to sum up the rows that I gathered …
reports

search

SQL

suiteQL

suitescript

faizbyp Rookie Asked on March 12, 2025 in SuiteCloud.
- 1K views
- 1 answers
- 0 votes
Error: “[NetSuite][ODBC 64bit driver[OpenAccess SDK SQL Engine]check your login credentials
I was able to access Excel with this ODBC connection until last week. Does anyone know what might have changed? …
Errors

excel

SQL

Milton_Ramos Rookie Asked on January 20, 2025 in SuiteAnalytics Connect.
- 1K views
- 1 answers
- 0 votes
Debit – Credit SQL Formula
I am trying to write what I thought would be a pretty simple formula for a transaction search {debitamount}-{creditamount} It …
Saved Search

SQL

laurieann26 Rookie Asked on July 25, 2023 in SuiteAnalytics.
- 3K views
- 7 answers
- 0 votes
SQL Linked Server Query Performance Issue
We’re using SuiteAnalytics Connect to create a linked SQL Server to perform queries for our custom code faster than SuiteTalk …
SQL

West Bennett Rookie Asked on May 23, 2023 in SuiteAnalytics Connect.
- 1K views
- 0 answers
- 0 votes
Running Total formula in Netsuite Saved Search is duplicating each row
I am using the SUM OVER PARTITION formula in Netsuite transaction saved search to get the running total of item …
formula

Saved Search

SQL

bzahid Rookie Asked on April 27, 2023 in Saved Searches.
- 3K views
- 1 answers
- 0 votes
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.
- 2K 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.
- 930 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.
- 1K views
- 1 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.
- 3K views
- 1 answers
- 0 votes