Is there a maximum number of lines that can be inserted in any given scrolling window?

Folks, this one can rather come across as a brain teaser or a catchy certification question, but don’t be surprised by how often I get asked during a demo and how often I — and many others — have automatically provided the unequivocal answer “Unlimited!”. The question comes in various flavors, for example:

  • How many distributions can I add to a journal entry?
  • How many line items can I add to a Sales document?
  • How many line items can I add on a Purchase Order?

Unlimited? The truth is, there is a limit to everything, whether the contraints are imposed by physical storage capacity or by a data type definition, the fact is, it’s nonetheless a limit.

So let’s take a look.

The Line Sequence Number field in Dynamics GP is generally defined as an integer value. According to Microsoft SQL Server Books Online, an integer requires 4 bytes of storage, which means it can any number between -2^31 and 2^31 or -2,147,483,647 and 2,147,483,647. Now consider this, the first line sequence number in a scrolling window is generally initialized with a value of 16,384 or 2^14, so mathematically speaking, a user will be able to add 131,072 lines or 2^17 before they hit an error and have to resort to inserting distribution lines in between the previous 131,072 ones.

I don’t know about you, but 131,072 lines in a scrolling window sound like quite a bit of lines — but certainly not unlimited — before you even begin to consider inserting lines in between, but you never know when you will come across that one customer who will push the system to it’s limit.

Related Articles:

Until next post!

MG.-
Mariano Gomez, MIS, MCP, MVP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/

Advertisements

4 Responses to Is there a maximum number of lines that can be inserted in any given scrolling window?

  1. Christina Phillips says:

    Hey Mariano!

    Would this logic hold true for any scrolling window in GP? Payroll Posting Accounts, for example? I have given the off-the-cuff unlimited many times, but have been second-guessing myself as of late.

    Thanks! Christina

  2. Mariano Gomez says:

    Christina,

    Thanks for your query. This logic holds true for all Microsoft Dynamics GP scrolling windows as the premise used to create the sequence numbers in the scrolling window is the same across all modules.

    Hope this helps,

    MG.-
    Mariano Gomez, MVP

  3. PlumDundFum says:

    Oh my god loved reading this post. I submitted your feed to my google reader.

  4. […] series of posts on the subject.Microsoft Dynamics GP Scrolling Windows and Line Sequence NumbersIs there a maximum number of lines that can be inserted in any given scrolling window?How to find the line number of an item on a Microsoft Dynamics GP document – Part 1How to find the […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: