-
NSC | SuiteQL Query: How to Get the Custom Form ID and Description from the Transaction Table
Scenario: A NetSuite User aims to enhance the verification process by querying Form used in transaction Records and the corresponding form description. This would simplify the task of reviewing and confirming the correct form usage, ensuring a more accurate and streamlined approach. Solution: The query provided below shows…
-
NSC | SuiteQL: Utilizing BUILTIN.CURRENCY_CONVERT for Reports and Data Analytics
BUILTIN.CURRENCY_CONVERT enables accurate financial analysis, reporting, and decision-making in multinational business environments. These queries demonstrate how it can be applied to various real-world scenarios, such as to analyze sales performance across different regions in their local currencies and then convert the…
-
Changed transactions alert/search/query
Hi. We have a saved search that identifies transactions have been created or were modified. but what would also be very helpful is being able to identify the GL impact for those transactions that have been modified. Can we do that in a more automated way?
-
Query does not return data using SuiteTalk REST web service
Hello everyone, I encountered with a issue. I wrote a query to select the data I needed and conducted tests using SuiteApp - SuiteQL Query Tool. As a result, I received the required data: Next, using SuiteTalk REST Web Services, I took this query and tried to to get the same data. The query was sent, but nothing was…
-
SuiteQL: Subsidiaries permission in non-One World accounts
Hi, We have a question about permissions for the “subsidiaries feature not enabled” case in non-One World accounts. The subsidiaries table still exists and it is populated in the background with 1 subsidiary, even though the feature isn’t enabled. We query the subsidiary table in quite a few of our suiteql transfers and…
-
How to resolved an Error When Running Filtered Queries via SuiteAnalytics Connect?
Recently connected to NetSuite2.com using DataGrip and when running queries filtered: select * from transaction where year(trandate) = 2023; I receive an error saying: [S1000][400] [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# lgvvjh4m14hfllw3sn8z5[400] Any…
-
Why does my API Query give different data that the Screen shows?
Here is my simplyfied query: Select T.id as WOId, T.custbody_atlas_assy_desc as assy, From Transaction as T Where BUILTIN.DF(T.Type) = 'Work Order' and BUILTIN.DF(T.TranID) = 'WO7-2217' And here is the query result: [ { "woid": 233891, "assy": "ASSY., SERV, N, 62, 1, 50, 62, 1, 50, 132, 7 (PH4/FORD/DTM/7K/WL)" } ] And here…
-
Querying password expiration date using SuiteQL / SuiteScript
Hi everyone, Is it possible to query the password expiration (per user/role) using SuiteQL / SuiteScript? (Max number of days or the last+next password change date) Since the password expiration might change according to the user's role, and for auditing purposes, we want to review each user/role password expiration dates.…
-
AE:Partial results in SuiteQL query for system notes
Hello everyone, When I am listing the system notes in the UI I get a certain amount of rows, but when I am fetching system notes using SuiteQL query (using REST web services) I only get some of the results back. This isn't a pagination issue, there is no more data to fetch. You help we be greatly appreciated.
-
Unable to use lastmodifieddate in the WHERE clause in netsuite2.com SQL query
I am trying to run a query against netsuite2.com as following: select lastmodifieddate from transaction where lastmodifieddate>'2016-06-16 18:50:50' But this produces an error: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# kybpw8j91333lgz1ovora[400] Please…