-
amountunbilled in sales order form
Hi, I see that in the database for the transaction table of a sales order there's the amountunbilled field. I would like to utilize it in the standard form but i cannot find it to be added. is this field available?
-
NSC | NetSuite2.com: Show Transaction Full Status Instead of Letters
By default, the transaction table shows the status field as internal IDs in the form of letters. However, they are not descriptive, and users would constantly need to check their equivalent if used as-is. The query below shows how users can retrieve the status field of transactions that show their complete text. SELECT id…
-
How can I set the SuiteAnalytics odbc query timeout
I'm using SuiteAnalytics odbc to query data from Netsuite. I'm getting this error. Exception calling "ExecuteReader" with "0" argument(s): "ERROR [HYT00] [NetSuite][ODBC 64bit driver][OpenAccess SDK SQL Engine]Query Timeout expired[10246]" This article suggests that I could set a timeout parameter. How do I do that? Or…
-
ODBC Netsuite2.com "Created from Allocation" - table / field
What field value and in which table identify a transaction as a "Created from Allocation"? Note: I don't want to rely on memo field. Thank you
-
ODBC SQL bug? nextline filter is not filtering
I work with Netsuite2.com ODBC Suite Analytics Connect I run the following SQL Query select ptll.linktype, ptll.nextdoc, ptll.nextline, ptll.previousdoc, ptll.previousline from PreviousTransactionLineLink ptll where nexttype = 'VendPymt' and linktype = 'Payment' and previoustype = 'VendBill' and ptll.nextline >1 But it…
-
NSC | NetSuite2.com: How to Get the List of Deleted Records via ODBC/JDBC
Some might not be aware that it is possible to check the list of deleted records in NetSuite, which can be done using SuiteAnalytics Connect or SuiteQL Query. This is important when auditing the changes in your NetSuite Account. The sample below shows a list of deleted custom records in a test account: SELECT * FROM…
-
NSC | Resolve Error: UNEXPECTED_ERROR When Running Test Connect on ODBC Driver
UNEXPECTED_ERROR messages are quite common as they can be triggered by a variety of factors. However, when it comes to SuiteAnalytics Connect, Two-Factor Authentication (2FA) is a possible culprit. Two-Factor Authentication is an important security feature that adds an extra layer of protection to your NetSuite account.…
-
NSC | NetSuite2.com: Unable to Access Location-Related Tables
Some users find that their ODBC connection does not have state, province, and country tables listed and encounter the error: Base table: state not found. To resolve this, the permission named “Set Up Company” must be added to the integration role being used. This can be done by following these steps: Go to Setup >…
-
NSC | SuiteQL: Using Outer Join to Get the Assigned Employee’s Full Name in the Task Table
Here is a sample query that retrieves the task records columns from the task table and sources the employee’s full name by concatenating the firstname and lastname fields from the employee table using outer join to display the assigned employee’s full name instead of their internal ID. SELECT task.title, employee.firstname…
-
ODBC Connection Freezes Excel
We are curious if anyone has any experience with connecting to NetSuite data/tables through Excel. We have attempted the ODBC connection with some success, however the connection freezes Excel (all open Excel documents are not responsive) and can be slower to update. Are there any other tools that we can use to connect to…