Stack Overflow
Stack Overflow

Questions tagged [suiteql]

40 questions
3
votes
1 answer

How to Select value By SuiteQL That I can filter Multiple Select Field

I had one simple table ItemMapping, 2 Field, one Field is single Item List Field SingleSelectField With value "A", Other for Multiple Item List Field MultiSelectField with Value ("B", "C", "D"). I Wanna get This mapping relationship By "B", I tried…
Tyrion Huang
  • 71
  • 1
  • 12
2
votes
3 answers

NetSuite: How can I get a list of custom fields using suitesql or REST?

Using the REST suiteql query endpoint or the records endpoints, is there a way to query NetSuite to get a list of custom fields?
Mike Sickler
  • 33,662
  • 21
  • 64
  • 90
1
vote
1 answer

Problems querying items using lastmodifed in SuiteQL

I am having strange issues querying NetSuite using SuiteQL. I am using a query based on TO_DATE: where lastmodifieddate > TO_DATE( '2023-03-01 05:24:25', 'YYYY-MM-DD HH:MI:SS' ) order by lastmodifieddate for some reason NetSuite SuiteQL is only…
André
  • 750
  • 11
  • 24
1
vote
1 answer

SQL statement to SUM values in one column by distinct values in another column while grouping by a third column?

I am trying to write a SQL statement to report the total amount an agent has sold and a count of the products they have sold from another table. I'm having difficulty getting the SUM data to come out right. There is a parent File record that has…
Matthew Carter
  • 23
  • 3
1
vote
1 answer

How to use BUILTIN.PERIOD

I want to query the last seven day's worth of invoices. This is my best attempt: SELECT T.* FROM Transaction AS T WHERE T.type IN('CustInvc') AND trandate IN(BUILTIN.PERIOD('SDLW', 'START', 'ALL', '>')) I've read the documentation, but I'm…
Minimistro
  • 73
  • 7
1
vote
0 answers

Why is autoreorderpoint not available in SuiteQL?

NetSuite shows in their Analytics Browser that autoreorderpoint is available in SuiteScript and in workbooks; however, a simple select top 10 autoreorderpoint from item query returns an error, and the field is not available when creating a dataset.…
splemp
  • 63
  • 7
1
vote
0 answers

How to use suiteQL to query Image field?

I had one image field with the id 'custitem_test_img' on the Item record, Item internal id is '1234', I made one SuiteQL like the below: SELECT Item.custitem_test_img FROM Item WHERE Item.id = 1234 And I got one error back with a message: Error:…
Tyrion Huang
  • 71
  • 1
  • 12
1
vote
2 answers

Netsuite suiteql how to get all available tables to query?

I am using Postman and Netsuite's SuiteQL to query some tables. I would like to write two queries. One is to return all items (fulfillment items) for a given sales order. Two is to return all sales orders that contain a given item. I am not sure…
Mule
  • 748
  • 1
  • 9
  • 24
1
vote
0 answers

Can I use Suitescript SuiteQl to get the pnrefnum on a Cash Sale?

I am trying to use SuiteQL to get the pnrefenum on a Cash Sale. It is not coming back when I query the Transaction, and while I suspect that it is possible to retrieve it with a join, and have seen joined records in the Records Browser such as…
astr
  • 473
  • 1
  • 3
  • 13
1
vote
1 answer

Is there a way to use SuiteQL to create a saved search?

The subject is pretty much my entire question. I've got a SuiteQL query that I'd like to have sent to me each day. I've confirmed that the query runs as a POST via the REST API without error. Is there a way to take this query and create a saved…
CatPhish
  • 39
  • 6
1
vote
0 answers

How to pass variables to SuiteQL

I am trying to pass parameters from the current record to an embedded Suitelet though cannot find the right syntax to do this anywhere My starting point was using the Suitelet code here:…
Vernita
  • 93
  • 3
  • 15
1
vote
1 answer

Suitescript SuiteQL Error with IN operator

SuiteQL SELECT * FROM transactionline WHERE ( transactionline.department, transactionline.cseg_grant ) IN (( '11', '1' )) The above query when run using suiteQL, It returns the below error Error: Search error occurred: Invalid…
Hrusikesh Bunu
  • 71
  • 2
  • 10
0
votes
0 answers

How to return the full date/time object in SuiteQL?

I am using the Rest API to run SuiteQL, something like the following: --header 'Authorization: Bearer <> \ --header 'Prefer: transient' \ --header 'Content-Type: application/json' \ --header 'Cookie: NS_ROUTING_VERSION=LAGGING' \ --data-raw '{ …
Jack Duan
  • 3
  • 2
0
votes
0 answers

In NetSuite's SuiteQL how can I get all related itemfulfillment ids from a salesorder in one record as csv?

I can get all item fulfillment ids but on multiple records using this query: { "q": "SELECT DISTINCT t.ID,t.TranID FROM NextTransactionLineLink AS ntll INNER JOIN Transaction AS t ON ( t.ID = ntll.NextDoc ) WHERE t.type='ItemShip' AND (…
Dario Perez
  • 31
  • 5
0
votes
0 answers

If we want to fetch linelevel details of invoice which is connected to sales order using suiteQL

Actually I am getting invoice details through the sales order but not getting details of linelevel data of invoice then my question is how to fetch this details using suiteql. SELECT DISTINCT NTo.tranid AS 'invoice tranid' , FROM…
Pratiksha
  • 1
  • 1
1
2 3