55
I currently have a simple issue .I need to be able to invoice more than 40 000 lines on a single invoice .
Is there any restrictions on this .I am currently using ver 9
*This post is locked for comments
Just my two cents.. I would agree. While 40K in line items should be possible, I think it would be a bear to manage. We have one client that tops out at around 2K of line items and it is a bear to track down any dollar rounding differences on the integration from their billing system. But it should work though.
While there is no actual limit coded into the system. The Line Item Sequence is a long integer field which does have an upper limit. I just checked and 40,000 lines increment by 16384 is 655,376,384 which is within the 2,147,483,647 limit for the datatype.
So yes, you could technically do this.
But, I think that it would be extremely unwise to create an invoice with this many lines. I think you will have major performance issues when it recalculates totals, taxes, commissions, discounts etc.
I also think that scrolling through that many lines on a transaction would be unmanageable.
One has to ask...... why do you need that many lines on one invoice?
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics
mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP
Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (