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:
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/
- 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?
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:
- How to find the line number of an item on a Microsoft Dynamics GP document - Part 2
- How to find the line number of an item on a Microsoft Dynamics GP document - Part 1
- Microsoft Dynamics GP Scrolling Windows and Line Sequence Numbers
Until next post!
MG.-
Mariano Gomez, MIS, MCP, MVP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com/
Comments
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
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