My Stuff
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Intelligent Payment Automation version 1.0.3 is now available in the SuiteApp Marketplace. The SuiteApp, powered by BILL, lets you automate payments, manage vendor details, and bank account information within NetSuite. Learn more
No Limits. Just possibilities.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Celebrate Your 2025 Community Recap & Achievements!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
We’re excited to announce that the 2025 Community Recap is now available! This special recap highlights the amazing contributions and achievements of our members over the year and celebrates the collective success of our community.
Check your personalized recap to see the impact you made in 2025 and how your efforts helped shape our community’s growth and success.
View Your 2025 Community Recap
Thank you to everyone for your passion, collaboration, and support. Here’s to building an even stronger community together in the year ahead!
Staying Connected During the Holidays
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Season’s greetings to you and yours! As we head into the holidays (December 24 – January 4), we want to take a moment to celebrate the incredible strength and collaboration within our community. Even during the break, you can continue to benefit from connecting with peers, searching related threads, posting your questions, and marking helpful replies as “Accepted” in the Support Community.
Please note our dedicated team will be on reduced coverage during this time, and regular responsiveness will resume on January 5. Wishing you a joyful and restful holiday season!
-The NetSuite Support Community Team
Comments
-
I discovered what was causing this issue, the primary table used in the subquery did not satisfy the test case where a customer had multiple managers. Left joining the customer table to salesInvoiced showed all customer data that I though was missing from the back-end.
-
Still looking for a solution
-
Hello, It isn't possible to edit the field IDs in the Records Catalog or editing field IDs is not supported on NetSuite?
-
Hello, The Records Catalog is extremely helpful, is it possible to make edits to the field ID there?
-
Also, we can't match or find the field names that we see in the front using SQL. Another word, I presume the field names on the frontend GUI should be the same as in the SQL queries? How can find the same field names as shown on the frontend? Please advise.
-
Hello, We've added the permissions to the role, but still the table is either empty (or isn't showing in Dbeaver). It is difficult to track if the permissions we're adding to the role is making a change.
-
Hi, Please see attached screenshot. Please advise.
-
Hi Nicole, Here's the screenshots for my role and permission. I see the permissions you have many don't seem to apply for what we're doing. Anything missing from mine that you think could cause my issue?
-
I am using a JDBC connection to connect with Dbeaver. I wasn't able to open the connection configuration (I am already connected), so I pasted the JDBC url below. JDBC Url:…
-
I searched up "transaction", "transactionline", "transactionaccountingline", and "entity" in the navigator and could not find the table that contains the data I'm looking for. I went to the records catalog and found a record of "transactions", this might be what I'm looking for, but I do not see an instance of…
-
I understand that pulling pre-made reports from ODBC/JDBC connection isn't possible, but in order to write a query, I need to know the name of the table that contains sales data. So there isn't a default name for the table that contains all sales data?
-
I've copied the permissions from the role I need to view sales reports, but I still can't seem to find the table. I'm assuming there isn't a default name for the table that contains sales reports? I ditched using Excel and connected to NetSuite via DBeaver, so I am now using a JDBC driver, does that change anything…
-
I followed @Nicole Mendoza-Oracle instructions, it gave me access to tables that weren't viewable - but finding the relevant table is still a struggle. Is there a default name for all sales data?