Tag: query

Difference between N/search and N/query

The N/search and N/query modules in SuiteScript provide different methods for retrieving data from NetSuite records, each with its own set of features and use cases. Here’s a comparison of the two: N/search: Search-Based Retrieval: The N/search module allows developers to construct and execute saved searches, which are predefined queries saved within the NetSuite environment.… Continue reading Difference between N/search and N/query

conditions in suiteql query (case when)

SELECT   DISTINCT NTLL.foreignamount as lineinvoicepaidamount,   NT.foreignpaymentamountunused as amountunapplied,   NT.ID AS upstreamid,   NT.TranDate,   NT.Type,   NT.otherrefnum AS checkNumber,   transaction.id AS lineTransactionId,   transaction.tranid AS invoicenumber,   NT.tranid AS paymentReferenceNumber,   BUILTIN.DF(NT.paymentmethod.name) AS paymentMethod,   ‘dd/MM/yyyy’ AS dateFormat,   customer.entitytitle AS businessPartnerId,   customer.companyname AS companyId,   BUILTIN.DF(NT.currency) AS currency,   CASE WHEN (NT.Type = ‘CustPymt’) THEN (NT.foreigntotal) ELSE ABS(NT.foreigntotal) END AS receiptamount,   NT.exchangerate,   NT.trandate AS… Continue reading conditions in suiteql query (case when)

Suite talk Rest API setup

Importing the Postman Collection To import the Postman collection: Download the REST web services Postman collection of sample requests from the SuiteTalk tools download page at https://<accountID>.app.netsuite.com/app/external/integration/integrationDownloadPage.nl. To access this page, you must substitute your account ID, and the REST web services permission must be assigned to your role. Unzip the archive. Click Import in… Continue reading Suite talk Rest API setup