Skip to Content
author's profile photo Former Member
Former Member

Handling Large Sales Orders

My problem:

SAP B1 performs very poorly or even crashes when the line-items are more than 100 lines in a sales order document.

The company I work for receive orders that have over 1000 line-items. When I have to divide large into multiple orders, it causes a lot problems when picking and packing.

Is there a way I could help SAP perform better in handling large sales orders? For example, would upgrading the server to higher specs make a difference?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2011 at 03:53 AM


    You may use dtw to import such sales order. You may use the template oOrder.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      I love how SAP or whomever put "assumed answered." for this question. This question isn't answered; SAP still performs very poorly when there's a large number of line-items in the sales order/or any type of document.

      I might be giving too much of the blame to SAP, when it's more the SAP add-ons that hinders the performance but at the same time, I wouldn't need the add-ons if SAP Business One had the functionality in the first place. (but that's another story)

      Below are a few things that you can do to help performance:

      First of all, disable any add-ons that aren't needed to process a sales order/ or PO. You can always reconnect them after you process the sales order.

      Secondly, if you have a formatted search in the sales order, take it off because this will slow down the processing/viewing of the document. You can always add it back after.

      Thirdly, take off any visible table fields in the form settings that aren't needed. I noticed that this helps when you just want to view a large sales order.

      Lastly, if you process the sales order directly from the server, it helps a bit but not by much.

      Having the fastest server would not make a difference.

      If your server has the latest processors and 32gb of ram, it still would not make a difference as the SAP application is a 32bit application and it can only utilize 4 GB of RAM at a time.

      I spoke to the developer in Israel as I created a SAP ticket about this problem (the people who developed the source code and they said they don't have any plans in the near future to bring out a 64bit version.)

      Please Note - I would not go over +2000 line items in a document as you risk crashing the system/causing the dump file and kicking everyone out of the database. (It happened to me already)

      When I did those steps, I reduced the time from 15 minutes to about 5-7minutes to process a large sales order.

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2011 at 02:26 PM

    Upgrading the server to higher specs will make some difference for sure. It depends on CPU & RAM power of both server and clients.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.