Some of our clients started complaining about this. They have like 6M records. I have no idea what is this actually. AFAIK, postgres can handle 100M records just fine, I guess OracleDB should be able to do more.

It is another way of making money for NS, they do throttle processes. One of my past client (freelance) had get suitecloud plus licenses since they had over 20M orders. https://suiteanswers.custhelp.com/app/answers/detail/a_id/70281

So such services don't exist, right? For example, in a shipping company, the middleware could save all the data of shipments, but push to NS only the journals that the finance team cares about.

if you want to use NS as GL only then it is possible - use best of breed platform like Coupa or SAP Ariba for procure to pay, concur or expensify for expense management, Tipalti for payable and for order 2 cash some order processing system. In theory it does work but you will end up with too many disparate systems thus issues and headache. In other word you are defeating purpose of an ERP, if you are just looking for GL then Quickbook would work, Netsuite would be an overkill. Look into the open source ERP called Oddo https://www.odoo.com/

Thanks, I will share that with my team. 🙏

Glad to help you, feel free to ask, if can help (if know the stuff) will help obviously. That's why we started this group 6 years ago and the sister site 3 years ago.

From what I heard they base service tiers on # of users, # of transaction lines and file cabinet storage We ran over the users limit before the transaction lines limit. So we had to upgrade to the next tier

@AI1 So if I just copied the fields of a record into another record, and instead of having two records, we would have one with more fields, that would count as just one, right? I mean, does Oracle care about the number of fields?

From what I understand it has nothing to do with number of record or fields It just goes off # of transaction lines

Just to be sure... We are talking about rows, not reading (queries) and writing (inserts), right?

It’s the # of transaction lines created within a month. It doesn’t matter how many queries you make just how many lines (rows) are created/added to transaction in a month

And it doesn't matter if I created the row and deleted it right away, correct?

Oh I’m not sure about that. I don’t know how they handle deleted lines. I haven’t found any documentation about when the # of lines is calculated

hmm, thank you very much, I will search more about that. 🙏