Limitations on Data in GP
I found this article on another GP Blog by Victoria Yudin, http://victoriayudin.com/, and wanted to share it with all of you. Also since I am using this blog post by Victoria I thought I should promote another great GP Blog that you could set-up a RSS Feed to.
One of the benefits of Dynamics GP being on Microsoft SQL Server is that there are virtually no limitations on the number of entries of a particular type. But the question does come up a lot. What’s the maximum number of customers or customer addresses, or sales transactions, or line items can I have in GP ? Victoria found a nice table of all SQL Server maximum capacity specifications showing that for the most part what will be limiting your data is hardware, not GP or SQL Server. SQL Server 2008 maximum capacity specifications are slightly different and even more impressive.