This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone had experience where growth is pushing the limits for Journal Entries in NS and over a million rows in Excel? With expected growth, we're trying to think ahead before we get any closer to those limits and are curious what really large companies are doing to get around having such large JE's and large Excel files?

If so - you're probably stretching to the point you need to talk to your account manager and see if NetSuite is even still a fit for you.

Honestly, we've been asking the team that very question, why is there so much. One idea was to store detail in a data warehouse and have simple JE's in NS. but it's not just NetSuite, the concern is also the Excel limitations and their files exceeding limits there.

it sounds like Excel is being used as the data exchange platform. maybe there is a better way by bypass excel.

<@U0291EH668H> if you need to continue using Excel build a data model using Power Query. It can easily go beyond the 1M row limit of Excel. It's also ridiculously fast. This is a 6 year old article that explains further.
<https://www.masterdataanalysis.com/ms-excel/analyzing-50-million-records-excel/>

<@U750CHB8F> Thank you for this! Unfortunately I think all our users run Mac and the Power Pivot tool apparently isn't available :disappointed:  Do you know of any Mac tools that could achieve the same result?

<@U0291EH668H> I don't. I also use a Mac and have the same issue. The workaround I use is a Windows Azure VM that I can boot up from my Mac but clearly that's not ideal, especially for multiple users.

<@U0291EH668H> just to give you a quick update - I was on a call with Microsoft and they are planning to have full feature parity with Power Query for Mac, PC, and even Excel online. They recently added some functionality to both the Mac and online where users can refresh their data source. This might help you since one user can build the model on a PC and then others could refresh on Mac or online.

<@U750CHB8F> Thanks Chris! This is good insight. We do use Office 365 Online.