-
SuiteQL error : Record 'companyaddressbook' was not found.
I'm using this SQL query select ab.internalid as address_book_id, ab.label address_book_label, a.addrtext as address_text from companyaddressbook ab join entityaddress a on a.nkey = ab.addressbookaddress where ab.entity = {cust_id} order by ab.defaultshipping desc, ab.label which was working fine previously. But after the…
-
NSC | How to find available joins for tables in NetSuite2.com Schema using Records Catalog
Scenario The user has to query several tables related to the transaction table and would like to know how he can find the relationships of these tables. Solution 1. Login to NetSuite using an Administrator role or any custom role with Records Catalog permission. 2. Go to Setup > Records Catalog. 3. On the Selection Pane at…
-
NSC | Find out what permission is required to access tables in SuiteAnalytics Connect and SuiteQL
Many users often encounter the error “XXX table not found” or something similar when they run a query, or they cannot find the table they need despite seeing it in SuiteAnswers or Records Catalog. Most of the time, this is simply caused by a missing permission. But did you know that you can check what permissions are…
-
NSC | Find Related Records in SuiteAnalytics Connect and SuiteQL
One common question among our customers is “How do we find the related transaction in ODBC/JDBC/SuiteQL?”. In this article, you can learn more about ODBC connectivity in NetSuite as we delve into querying 'Related Records' using the NetSuite2.com Data-source. There are two tables in the NetSuite2.com schema that you can…
-
What is the Query equivalent for search.lookupFields in SuiteScript?
Hi, I am trying find the best alternative for search.lookUpFields using N/query, as the former only uses one unit of governance but using query.run() will consume 10 units which will be a big drawback for bulk operations. Please suggest
-
SuiteScript - query.runSuiteQLPaged() problem
Hello! I stumbled across a strange problem while using the method runSuiteQLPaged(). When I have an "ORDER BY" clause in my SQL, I get data ONLY in the last page. All previous pages do not return data. When I do not use an "ORDER BY" clause everything is fine and data is returned in all pages. Have for example this simple…