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
-
Just to clarify, I loaded a budget into NetSuite for 2022. All i want to do is query the budget data that I loaded through excel ODBC using NetSuite2.com as my datasource. The budget was loaded by location, by account, by month. In order for me to pull this data, i need to "have installed the Expense Commitments and Budget…
-
thanks , i will take a look
-
also, the way the query is written in the article you referenced only gives you the activity, not balances, for balance sheet accounts.
-
what is the equivalent of this table/field in NetSuite2 data source? 'posting_account_activity post'
-
grouping is not the issue. What is happening is: for each account, the balance total = current balance * # of individual transactions for that account; so if Account # AAAAA has a current balance of 20 and there are 10 transactions in May, it is calculating the balance as 200...if there are 5 transactions in June, balance…
-
SELECT transaction_0.postingperiod, Account_0.acctnumber, Account_0.fullname, Account_0.balance FROM Account Account_0, transaction transaction_0, TransactionAccountingLine TransactionAccountingLine_0, transactionLine transactionLine_0 WHERE TransactionAccountingLine_0.transaction = transactionLine_0.transaction AND…
-
fyi,...i am using the NetSuite2.com data source
-
so my joins between transactionline and TransactionAccountingLines should be transactionline.transaction = TransactionAccountingLine.transaction and transactionline.id = TransactionAccountingLines.transactionline , correct?
-
If a transaction has multiple lines with different accounting for each line (ie. supplies + shipping expense), wouldn't transactionline.id need to be joined with TransactionAccountingLine.transaction to pull respective totals for each GL account?
-
pardon my ignorance, what exactly are solution providers and how can I reach out? I am very new to NetSuite. I've only worked with BPC and Hyperion Essbase in my previous roles.
-
If I wanted to pull in the following data directly into excel via SuiteAnalytics Connect... This is a variation of the Transaction Detail report under Reports->Financial->Transaction Detail