-
July 27, 2026 | Pop Quiz
How well do you know NetSuite? Take on today’s pop quiz and share your best answer below! TRUE OR FALSE The Company record is an exposed table in NetSuite2.com schema.
-
Netsuite2.com SuiteAnalytics CompanyAddressBook duplicate records
I'm seeing duplicate records by internalid when selecting from CompanyAddressBook using the Netsuite2.com source for SuiteAnalytics connect. select * from "Buster and Punch Limited"."Data Warehouse Integrator".CompanyAddressbook where internalid in ( select internalid from "Buster and Punch Limited"."Data Warehouse…
-
NS2 SuiteQL query fails instantly when removing filters — not a timeout
I'm putting the final touches on migrating queries from the "NetSuite.com" data source to "NetSuite2.com", and hitting a weird error where the query fails instantly when removing specific filters but not altering the query in any other way. It doesn't try to run and timeout, it errors instantly. If either specific filter…
-
SuiteAnalytics schema: netsuite2.com equivalent to netsuite.com events1
I'm migrating our SuiteAnalytics connect reporting from the netsuite.com schema to the netsuite2.com schema. I'm having problems finding the equivalent of the EVENTS1 table in the netsuite2.com schema. The NS_TO_NS2.xls doc quite clearly says it's CalendarEvent However this table doesn't have the same records at all, and…
-
Identify any all scripts that may use the 'netsuite.com' data source w/o opening each script
Thank you. I did find this topic "How to find out which data source is being used? I understand the differences between the 2 data sources. We have updated our ODBC connection to use the netsuite2.com data source. How can I identify any all scripts & analytics report that may use the 'netsuite.com' data source without…
-
Missing Field In NetSuite2.com
Hi We are migration our suiteanalytic connect from netsuite.com and netsuite2.com but there are some fields that found in netsuite.com which I can't find any matching field in netsuite2.com 1. Amount (Gross) and Amount (Tax) These field is not available in Netsuite2.com transactionline record, which field should I refer to…
-
Help Finding Vendor Prepayment Object in SuiteAnalytics (netsuite2.com)
Hi, In SuiteAnalytics on NetSuite.com, the Vendor Prepayment object used to be available under the Transaction table, and I was able to report on it without any issues. However, after switching to netsuite2.com, I’m no longer able to locate this object or any associated fields in the new data source. I've searched through…
-
Action Required: Transition to the NetSuite2.com Data Source
NetSuite has identified some accounts are still using the NetSuite.com data source for SuiteAnalytics Connect. You must take the Required Actions to transition to the NetSuite2.com data source as soon as possible. Note: If you are using Connect through a partner solution, you should contact your provider to complete the…
-
NSC | SuiteAnalytics Connect: NetSuite.com to NetSuite2.com Schema > How to get Opportunity Records
The NetSuite.com data source is no longer supported in 2025.1 and will be removed in 2026.1. You should use the NetSuite2.com data source when working with SuiteAnalytics Connect to avoid any disruptions. For more information, see SuiteAnalytics Connect NetSuite.com Data Source End of Support. On NetSuite.com Schema:…
-
Query transactionTaxDetail
I understand the NetSuite.com data source is being retired. I have been able transition all but 1 of my queries to NetSuite2.com. I have not been able to determine the permission(s) needed to read from object "transactionTaxDetail" in NetSuite2.com which is "TRANSACTION_TAX_DETAIL" in NetSuite.com. I have granted just…