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
-
Hi @Francesca Nicole Mendoza-Oracle Please read the original post - I explain that this field is NULL for the Journal Entries with status "APPROVED FOR POSTING CREATED FROM AMORTIZATION SCHEDULE" I do see values there for the original bill that creates the amortization schedule, but the values are NULL for the monthly…
-
https://community.oracle.com/netsuite/english/discussion/comment/16790007#Comment_16790007 Hello Gurus. This Post is 3 years old, still, the amortizationshedule for Journal Entries lines is not exposed in ODBC…. Who can make this happen? It is soooo easy - the values are there already. Please help us!
-
Thanks, @Patrick Fresnosa-Oracle ! Exactly what I needed!
-
Hi @Nicole Mendoza-Oracle The Netsuite representative has reached out to me. We are discussing this matter. Thank you for your help Michael
-
Thank you. No one has reached me yet. Maybe they do have a problem with the form submission?
-
The form just thinks for more than a minute after the submission. Then - nothing happens. No notification that "we've got your form", no email .... The site just returns to previous "partners" page. So, I wonder if they've received the form or not...
-
@Nicole Mendoza-Oracle Thanks, Nicole, I've contacted the Partners program and filled out the form. But no one got in touch with me yet. I also didn't received any confirmation that a form was received - neither via email nor via site after the submission.... It was about a week ago. I'll wait a bit longer
-
@Nicole Mendoza-Oracle I don't have an Account Manager. I don't have Netsuite. I have built many BI solutions for my customers but my question was about something else. My question is about getting a license for demo account for teaching BI based on Netsuite demo database. Please help me get in touch with a Partners /…
-
The issue has been solved. Thanks
-
Yes, it appears to be some outage with SuiteAnalytics Connect:
-
Just to update - we've opened a ticket and this was classified as a defect # 739031 We got update that engineering team is working on it.
-
@Richard James Uri-Oracle Hi Richard. I am confused. Is my original issue (sourcerevenueplan disappeared) solved? You are addressing the @User_RQLP5 issue. Maybe it's better @User_RQLP5 to open a separate post, since I don't see how it is connected (unless it is) I would really appreciate help with sourcerevenueplan gone…
-
I did. Support Case #: 5371114. Defect 737292: ODBC/JDBC > StatisticalJournalEntryLine table > sourcerevenueplan column > null results
-
@Richard James Uri-Oracle Hi Richard. I am confused. Do you think the @User_RQLP5 problem is related to my original one? Because all I want is to see again the source revenue plans for each transaction line. I want this SQL to work again: select * from StatisticalJournalEntryLine where sourcerevenueplan is not null I have…
-
@User_RQLP5 Not sure if these are related. For me, the following used to work fine for a long period: select * from StatisticalJournalEntryLine where sourcerevenueplan is not null And then suddenly stopped working.
-
Maybe I am not explaining myself: I know the Revenue Plan table. I wasn't talking about this. What I am looking for is where do I see the Source Revenue Plan for the specific Journal Entries Lines . In the first screenshot you've pasted - you are showing the revenue recognition Journal Entry Lines. This information is kept…
-
They sent an email today saying that they are researching the issue. Waiting for an update. By the way, why do I see the sourcerevenueplan field only in the StatisticalJourneyEntryLine table? Shouldn't it be in the transactionline table? In the UI screen you've provided above, where you see "1" under Source Recognition…
-
In your screenshot the sourcerevenueplan field is null. Thant’s exactly is the problem. Several days ago you would see there the revenue plan id Something stopped working in Netsuite.
-
@Richard James Uri-Oracle So are you saying that you do see this transaction you created together with sourcerevenueplan number in the StatisticalJournalEntryLine table? (the support are still checking my case)
-
Not sure what do you mean by "a screenshot of the Statistical Journal Line record" Here is a snapshot of my RevRec JE. It has a "Source Revenue Plan" field which is populated. If I select this JE transaction id from the StatisticalJournalEntryLine table - I get no results. select sje.sourcerevenueplan , sje.* from…
-
Thank you, @Richard James Uri-Oracle I've opened a ticket, but it is still under review. Since I experience this across all of my clients, I assume it is a system bug, that's why I've reached out for this forum as well. If you have some demo account with Revenue Plans and Revenue recognition schedule running based on them…
-
Anyone? All of my BI reports stopped working because of this... Maybe something simple changed and I am missing it? Or maybe it's a bug? Please help
-
Thanks, @Richard James Uri-Oracle
-
Thanks, @Richard James Uri-Oracle As you can see in my post, I've arrived to the similar results but using PreviousTransactionLineLink table. What confused me is the FOREIGNamount field name (you have the same field in the NextTransactionLineLink table). At first, I expected to see there an amount in terms of Primary Book…
-
@Joahnna Given Uy-Oracle BUILTIN.DF !! That is so AWESOME!!! It makes life much easier! Thanks!
-
@Joahnna Given Uy-Oracle Sorry, Joahnna, I am not sure I've got the aswer. Are you familiar with ODBC? Why do you mention "article". My question is straightforward - what TABLE in the ODBC Netsuite2.com has these codes and descriptions? Thanks
-
Yes, but is there an ODBC TABLE with these codes and their descriptions?
-
Never mind, I think I've found: But is there a TABLE for these codes?
-
@Richard James Uri-Oracle Thanks, Richard. I somehow missed it under the Lists. It is working now. Thanks again!
-
@Kristoffer Viray-Oracle Any update? Thanks!