With the NetSuite2 connector, did all the table na...
# general
k
With the NetSuite2 connector, did all the table names change from NetSuite?
t
Not all but I think it has impacted line level tables. One of our customer did face this issue where all queries had to be updated because of this issue.
r
It's very nearly all of them. Even ones where they very easily could have kept them the same, ie Customer_*s*_ became Customer, Item_*s*_ became Item, etc. I'm guessing there's some back-end thing where they couldn't have the the table names be the same. The majority of field names within the tables changed too, so if you're heavily using data from the Netsuite.com connector, you have a lot of updating to do. Good luck!
k
😞 thats what I was afraid of...
m
Our programmer is currently working on updating ALL of his queries. Another thing he found recently is that querying the item table gives different results with NS2 vs NS1. Where NS2 includes all types as you'd see in the UI items list but NS1 also included tax items/groups. Currently in a go-around with NS support on that.