I'd be careful with downloading any chrome extensions which could gain full access to NetSuite.com domain. The extension could potentially see the NetSuite login-cookies that could pose a massive security issue. (Also the user who just posted this has literally created their reddit account today. )
You need to setup your DKIM and SPF because your customer's email server is blocking email from you because it looks like spam. NS sends email using your domain but it comes from NS's IP addresses, so that is spoofing and it gets flagged as spam. DKIM and SPF tell the world that it is okay if email is using your domain in the return address but it's actually being sent from netsuite.com servers.
This is likely why FiveTran stopped working in early November, but existing users should have been grandfathered to be able to continue using the old netsuite.com data source, so FiveTran should have only broken for brand new SuiteAnalytics Connect users who added Connect module after 11/8/2021. There is still the roadmap issue of what is FiveTran's plan to switch their pipe over to using netsuite2 data source (and then all the tables are different so users will have to re-write all their queries)
​
>Important As of November 8, 2021, new Connect users can access the Connect Service using the NetSuite2.com data source only. If you gained access to the Connect Service before this date, you can still access the NetSuite.com data source to ensure a smooth transition to NetSuite2.com.
Note that the NetSuite.com data source is no longer being updated with newly exposed tables and columns, and support for this data source will end in a future release. The use of the NetSuite.com data source is no longer considered a best practice, and all Connect users are encouraged to use the NetSuite2.com data source. For more information about this change, see New Accounts and Access to the Connect Data Source.
using netsuite.com I can see both TRANSACTIONS and TRANSACTION_LINES tables. In netsuite2.com, can see none of them.
Is TRANSACTION also a joined table?
Try connecting to netsuite.com datasource and see if you see it with OA_TABLES in that old data source with the same credential. If no, then it's permission issue. If yes, then it's what I said that you can't see the joined tables.
Can't use netsuite.com data source as its been deprecated - don't want to set myself up with something that might not work a year from now.
Tried all those other things but to no avail. You can view the notes just fine on the record, which further adds to my confusion...
We don't query it directly so speed isn't so much of an issue, we pull all tables and all data down to a data warehouse and query against that.
Defects ... where do you want to start?
- There are missing fields in netsuite2.com that are available in SuiteQL (they 'should' be identical, that's the whole point of NS forcing the change so everything is aligned)
- Missing fields that are in the older netsuite.com schema
- Primary key columns with null values (so you can't set the PK and do deltas)
- Tables that completely timeout with no response
- Tables that don't return results in a timely manner (some response times are a few seconds, some can be minutes ... even small tables so row count is not the issue)
- No admin access so you have to use the new DWI account (for full access without setting role permissions) which has a joke of a TBA implementation. Not a defect as such, just a PITA when you want full read access to everything
Other than that its perfect! :)
First, thank you VERY much for talking to me about this. I feel like very few people are dealing with this.
Is it just me or is it far, far slower for even simple queries?
What other defects have you found?
Using various software I can probably figure out the changes myself. At this point that's a real pain in the butt, but it's not unassailable. What is deeply concerning right now is - and NetSuite has admitted as much to one of my coworkers - it is considerably, considerably slower. I had to be creative and thoughtful with some of my bigger queries just to get them to run in the 10 minute timeout window we have. Now that that ten minute means a damned sight less than it used to...I don't know, I don't see how it's even remotely possible to migrate. But they're saying they're going to cut the old NetSuite.com service off, so what is there to do?
I actually switched back to NetSuite.com for development because NetSuite2.com will prevent admins from making queries. Sometimes you just want to query without switching roles.
Thanks. I can query the Accounts table using NetSuite.com instead of NetSuite2.com I'll check out DBeaver when I have a chance.
Now I'm encountering another issue. I ran SELECT * FROM ACCOUNTS and it returned 0 row even though there are accounts. I connect to a different environment, ran the same query and I can see the data in the table.
Any help is appreciated.
Hmm. This code returns true.
<script> const urlParams = new URLSearchParams("https://netsuite.com/?Id=12345&e=T"); alert(urlParams.has('e')); </script>
But this returns false
alert(urlParams.has('e'));
open chrome, go to netsuite.com, login, realize you cannot use the scanner this way.
You need a warehouse management system to use mobile computers/scanners. Either a 3rd party provider like rfsmart, or netsuite's addon, WMS. It is not exactly cheap. If you go with netsuite's WMS, I strongly advise to NOT use netsuite to do the integration
I'll have them look at that. This would be so much easier to troubleshoot if I had some level of developer/admin access. I always thought the netsuite.com email address was assigned 1:1 for a queue, but I've been told numerous times that if the original "to" address doesn't match what Netsuite is looking for it won't route properly. Which, just makes no logical sense to me.
Thank you for the information. Do you know what the initial type of saved search this would be based off to get to the order items area? From the url netsuite.com/app/accounting/transactions/orderitems.nl?whence= I thought it should fall under a transaction type but there is nothing for orderitems. What am I missing to target that area with the saved search?
I find it on TuneIn, iHeart, and Sports Day. The only one not doing it is usav.it as long as you pay $24/mo. I'm in Oregon, so that's all I have to listen. My kryptonite isn't Jamie but the netsuite.com spots. Frikkin' thing is incessant and it's on every break.