Hi @Rokas_Jurkenas I have spent the last two years building out an ERP for a production company on Coda. You will most likely need to split each of the major functions you want to accomplish into several docs so that they remain snappy enough that the users will enjoy using them.
My architecture is to have one single source of truth (SSOT) doc with all of the main Tables, and then create satelite docs to perform the various ERP functions, each draw and syncronizing the information from the Tables doc.
The biggest limitation right now is that you will be working in the satelites and need to cross-doc the information back to Tables, and while this works, it isn’t real time and detracts somewhat from the user experience.
Even with this broken up architecture, you will probably run into performance issues if you are adding 100 rows per day. There are ways to mitigate this with archiving information via cross doc AND Coda is continually making performance improvements, but its something to consider.