Skip to main content
Solved

Maximum Sales Order Line in one single sales order entry


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. 

Best answer by Neil Cantral

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.

 

View original
Did this topic help you find an answer to your question?

11 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2155 replies
  • April 13, 2022

HI @kchan15 

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. 


Forum|alt.badge.img+3
  • Jr Varsity I
  • 61 replies
  • April 13, 2022

I recently found that Firefox handles large SOs better than chrome. 


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2155 replies
  • April 13, 2022
yhartman wrote:

I recently found that Firefox handles large SOs better than chrome. 

Interesting. Does it slow down the load of the screen?


Fred Reiter
Freshman I
  • Freshman I
  • 6 replies
  • April 13, 2022

Check your Lines per transaction on the License Monitoring Console (SM604000) and see if 1000 is the limit.


Kandy Beatty
Captain II
Forum|alt.badge.img+16
  • Captain II
  • 2155 replies
  • April 13, 2022
freiter39 wrote:

Check your Lines per transaction on the License Monitoring Console (SM604000) and see if 1000 is the limit.

Good reminder of this @freiter39 

 


  • Author
  • Freshman III
  • 4 replies
  • April 13, 2022

Thank you @freiter39 . We did move up from 1000 to 1500 on our License Monitoring Console, but still encounter the same issue. So do you have any other suggestion that I can look for the solution? @kbeatty21 I will try to test today by using FireFox for a large transaction.

 

 


Fred Reiter
Freshman I
  • Freshman I
  • 6 replies
  • April 13, 2022

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.


Neil Cantral
Jr Varsity I
Forum|alt.badge.img+3
  • Jr Varsity I
  • 60 replies
  • Answer
  • April 13, 2022

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.

 


  • Author
  • Freshman III
  • 4 replies
  • April 13, 2022

@Neil Cantral  Thank you for the feedback and that is another good tips. We usually don’t use the group/document discount for our Sales Order entry, so I assume our performance issue is not caused by this feature. 


Forum|alt.badge.img+6
  • Captain II
  • 279 replies
  • April 13, 2022

I would echo Neil’s suggestion of using an import scenario.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2620 replies
  • April 26, 2022

 Hi @kchan15 were you able to resolve your issue? Thank you!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings