How Many Lines can a Transaction have? and more Dynamics GP blogs


David MeegoThe blogsphere continues to be a source of great information for the entire Microsoft Dynamics GP community.


The Dynamics GP Blogster, Mariano Gomez, has tackled the age old question of Is there a maximum number of lines that can be inserted in any given scrolling window? He explains that the answer of “Unlimited” is not correct as there are limits, but they are larger than anyone would ever enter manually.


That said, I have heard of sites attempting to import single transactions (using eConnect in this case) with a enormous number of lines (over 5,000). Usually this transactions would end up causing performance problems and time out issues.  Something to think about is that depending on some settings, when you add a line, GP might have to recalculate the tax, commissions, trade discounts, or distributions for the entire document.  As the number of lines grows the processing required grows exponentially.


For example, if we assume it takes 1 second to process one line and that the document is recalculated as each line is added.



  • 1 Line transaction = 1 second

  • 2 Line transaction = 1 + 2 = 3 seconds

  • 3 Line transactions = 1 + 2 + 3 = 6 seconds

  • 4 Line transaction = 1 + 2 + 3 + 4 = 10 seconds….. and so on.

As you can see the limiting factor normally ends up being performance as the limits caused by data types and storage space are higher than you would ever really need.



Changing subject now. I have added two more blogs to the Microsoft Dynamics GP Blogs page and to the links on the left hand side. Please check them out:



Matt Landis at the Dynamics Small Business Blog.


Constance Gilleland at the Q Factor’s Blog


I have known Constance for many years since we met at the first Great Plains Technical Conference I attended in Fargo, it is great to see her starting a blog to share her knowledge and experience.


David

Comments (1)

  1. The blogsphere continues to be a source of great information for the entire Microsoft Dynamics GP community

Skip to main content