When we tried to upload the file to the Document Detail tab under the sales order entry window, it only uploaded up to 1000 items. So is that the maximum line item we can enter in any single sales order entry? And do we have any alternatives that we can exceed 1000 line item in one single order? Sometimes we have a large order that might have thousand and thousand of BOM (Bill of Material).. In addition, we experienced tremendous of slowness when the sales order has reached about 1000 line items. For example, it might take us 3 minutes to update the pricing for one single line item or just change the characters of the stock item description.. it really create a bottleneck for our operation efficiency.
Maximum Sales Order Line in one single sales order entry
HI
Yes, 1000 is about what I have always found to be the max and once you do get that many records, it slows down the load of the system unfortunately. It is a great amount of lines as you are aware.
I recently found that Firefox handles large SOs better than chrome.
I recently found that Firefox handles large SOs better than chrome.
Interesting. Does it slow down the load of the screen?
Check your Lines per transaction on the License Monitoring Console (SM604000) and see if 1000 is the limit.
Check your Lines per transaction on the License Monitoring Console (SM604000) and see if 1000 is the limit.
Good reminder of this
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/7009ae39-b1e2-4610-896b-ec0d167ade29.png)
Thank you
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e3378f25-56fe-49b1-8c76-116482fbea36.png)
I wish I had an answer but maybe someone on the dev or product support side will chime in. Did your site get restarted after applying the license? Maybe it really only takes affect after IIS is restarted.
I regularly work with orders in excess of 1000 lines. Our license allows 2000 line per transaction but we do have some orders in excess of 2000 SOLines.
Using an import scenario might be a workaround while you investigate this further.
One thing I will note is that the Sales Order entry has significant performance issues when group/document discounts are involved. It seems to recalculate the discounts each time an SOLine is added/modified. Our workaround for this was changing the customers who regularly order these large orders to line discounts - this was a huge performance boost. Another option to explore is using the “Disable Automatic Discount Update” option on the Order Type. This helped with our customer orders with group/document discounts performance, but it broke our line discounts.
I would echo Neil’s suggestion of using an import scenario.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.