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
-
Thanks much for your help. Yes I am using the - REST Query Service yes we do have Manage Authentication section > OAuth 2.0 - is checked when I try OAuth 2.0 Client Credentials Setup - and create new client credentials mapping - i found my entity name and role = administrator - but application pull down is blank? Q what do…
-
Hi, you asked : Are you using OAuth 2.0? Q1 - I may be but not sure... can you let me know how to check and also how to move to OAuth 2.0 if I am not yet using it? Q2 - Also - can you point me to how to use use the REST Query Service rather than what I am currently using I think is REST API?
-
Ok thanks for the input.
-
Hi using the REST API I do get tranid so that should be the one that the invoice creator made - correct? Also sometimes I see externalid also - can you describe the difference between them?
-
Thanks - I was told I need access to create the “Detailed AP Aging Report.” (a basic and common accounting report).
-
THANKS SO MUCH!!!!
-
Hi Mikko, you said... Hi @User_U1JVS , you can check the Records Catalog by navigating on Setup -> Records Catalog. Under Transaction, you can check the status field on the tooltip of the column type. A sample for Paid in Full status is on Invoice record. I went where you said - to Transaction ... - but then I had to click…
-
Hi Erick, I did find the field called: linesequencenumber but do not yet see this: transactionline.id Can you help me find it ? Thanks - dave
-
Thanks Erick
-
this would be for REST API table list...
-
BTW: I was looking for tables here - but now gone where is the link for the new tables browser? https://netsuite.custhelp.com/app/answers/detail/a_id/92152/kw/Analytics%20Browser
-
THANKS SO MUCH ERICK!!! I will check it out right now.
-
THANKS SO MUCH ERICK!
-
BTW: if I try the query this way it gets lots of duplicates... Q 1: Is there a better way to write this so I do not get duplicates? { "q": "SELECT * FROM transaction t LEFT JOIN transactionline tl ON t.id = tl.transaction LEFT JOIN transactionaccountingline tal ON t.id = tal.transaction LEFT JOIN account ac ON ac.id =…
-
Thanks so much Erik - I will give this a try!
-
no I have not - can you give me links to try that q: do you have a link to saved search? and how to create a fresh query Q: also I want to get all the fields I need for various tables - how do I choose the fields for the varied tables?
-
Thanks Erik, also this... for rest api... 5 - *** --> So what is the best way to get the GL credit and debits which we need with REST API? we need -transaction date -account number - unique value (like transactionline uniquekey) -credit debit - amount -other related fields now we are trying: transaction - account -…
-
Hi looks like this never got an answer - i am still interested in this Any help is appreciated
-
well my link above was wrong - it's for odbc 4 - So what is the difference between transactionaccountingline and transactionline ? 5 - *** --> So what is the best way to get the GL credit and debits which we need with REST API? So how do I do this with REST API version? I see this now…
-
More... 1 Ask more: the connect browser seems to have changed? 2 The transactionaccountingline is gone ? where is it now? 3 the transactionaccountingline seemed to have the credit and debits which we need? 4 - So what is the difference between transactionaccountingline and transactionline ? 5 - *** --> So what is the best…
-
hi, I have: employee edit > access my Role set as admin permissions > setup i see SuiteAnalytics Connection and "full" on right my config role id says = 3 - is that admin role? NOTE: service datasource says config = netsuite2.com = this fails in windows test connect but netsuite.com = success How can i have success with…
-
Thanks much!
-
Hi Erick, Thanks for the help. Unfortunately I am still confused. If you can would you mind answering Questions #1 and #2 and #3 and #4? On the existing report: https://xxx.app.netsuite.com/app/common/search/search.nl?cu=T&e=T&id=1219 --- #1 Question: how can I figure out the underlying tables that these transaction search…
-
Thanks a lot!
-
Nice thanks!
-
hi am are confused by the various tables: account - subsidiary - customer - vendor etc. Can you shed any light on the differences of these?
-
Yes thanks
-
Hi Thanks - the client is unsure of the correct tables - Is there some way I can find out myself what tables they are using?
-
Hi - Curious if anyone can help with this issue?
-
Sorry for the delay - very helpful!