cancel
Showing results for 
Search instead for 
Did you mean: 

Handling Large Sales Orders

Former Member
0 Kudos

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?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Thanks,

Gordon

Former Member
0 Kudos

Hi,

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

Thanks,

Joseph

Former Member
0 Kudos

That's how I do it actually, I add the sales order using DTW.

From pick list menu: when clicking on the delivery button to add the delivery document is where it freezes.

Former Member
0 Kudos

Hi Ryan,

If you have SBO installed on the server, process this transaction from the server. Your server migh be off good spec, the client could be issue.

Regards,

Rakesh N

Former Member
0 Kudos

I processed the order on the server itself.. it doesn't help.

Here are the specs of the server:

OS Name Microsoft® Windows Server® 2008 Standard

Version 6.0.6002 Service Pack 2 Build 6002

OS Manufacturer Microsoft Corporation

System Manufacturer Xen

System Model HVM domU

System Type X86-based PC

Processor Intel(R) Xeon(R) CPU E5430 @ 2.66GHz, 2887 Mhz, 1 Core(s), 1 Logical Processor(s)

Processor Intel(R) Xeon(R) CPU E5430 @ 2.66GHz, 2869 Mhz, 1 Core(s), 1 Logical Processor(s)

SMBIOS Version 2.4

Windows Directory C:Windows

System Directory C:Windowssystem32

Boot Device DeviceHarddiskVolume1

Hardware Abstraction Layer Version = "6.0.6002.18005"

Time Zone Eastern Standard Time

Installed Physical Memory (RAM) 3.42 GB

Total Physical Memory 3.42 GB

Available Physical Memory 806 MB

Total Virtual Memory 7.09 GB

Available Virtual Memory 4.79 GB

Page File Space 3.71 GB

Page File C:pagefile.sys

Former Member
0 Kudos

Your server's RAM is too low. Unless your have very small DB (unlikely), it need much more.

Former Member
0 Kudos

Hi Ryan,

Try increasing your RAM on the server atleast to 8GB, What is the RAM specification on the client machine then ?

Regards,

Rakesh N

Former Member
0 Kudos

You haven't said what version / patch you have. There have been performance enhancements made in 8.8, and some in 2007A SP01, so an upgrade may also help your cause.

Former Member
0 Kudos

It's on the latest patch SAP 8.8 SP00 PL 18

We use Citrix XenApp(2 servers) which we use as the client workstation and each server has 4GB RAM... same processors as the server specs I posted before.

Former Member
0 Kudos

How big is your database?

Former Member
0 Kudos

20814.31 MB

Former Member
0 Kudos

If possible, data archiving will help your system performance.

Former Member
0 Kudos

I would look into the data archiving... however, we only implemented SAP last year so there's only 1 year of data which needs to be in the same database

Adding RAM to the server would be a lost cause as SAP B1 is a 32 bit application so it would not utilize more than 4GB of RAM.

SAP is working on it and I'm waiting on to hear back from them.

I'm just surprised no one is has complained about this before? We can't be the only company that has more than 1000+ line items in a sales order.

Former Member
0 Kudos

In your case, the problem is just starting. I don't think many B1 customers have the same requirements as you do.

Just in one year, you db is much more than a typical 4 year customer. Some business process has to be changed in order to use the system.

Former Member
0 Kudos

I have a similar problem

My SAP B1 2007A is on VM on very fast server... proc and ram is never used over 50% and HDD configuration is on a raid 5 sas 15k with perc 1 gig

When I'm dealing with SO with over 100 line, i have slow performance.

Example, the user trying to update quantity on an order of 94 line, its 12 sec of update time... directly on the server

Does SAPB1 is able to handle large document?

Former Member
0 Kudos

We are just in "go live" for about three weeks now. When I installed and decided on what SQL program to use (MS 2008 free vs. full pkg.), I recall some documentation from SAP in their setup guide where they talk about SQL database file size limitations depending on which version you use.

Another issue I have seen is that when you import using the Admin/Data Import functionality (we imported customized pricelists, just like in the documentation), the SAP B-1 system would run out of memory and freeze (dump and quit). This happened when I ran more than one file import in a single session. After this happened twice, I ran task manager on one screen while running the import on my main screen and discovered that as the import was running, the program size of B-1 would increase rapidly as the import was running. The import files were minimal in size (1192 items, so a total of 4768 fields in text mode). The SAP file would be running at around 274,004 K with all the add-ons running after initial log on. While the import was running, the SAP file would increase to 987,072 K. This would not decrease after the import was finished (purging the temp files). So the only solution was to log off and log back on after each import.

I would have to say there is some sort of programming glitch in the importing functionality, whether it be the built-in import in the Admin or using DTW. There should be a temp file dump after an import, whether it be automatic or a selection.

Former Member
0 Kudos

I'm running SAP on SQL 2005 standard on 2003R2 32 bit

Does the memory limitation of 2003 32 bit could affect?

I will check you comment on temp file because sometime, i could have similar problem when i import with DTW and Inventory pro import tool.

thanks

Former Member
0 Kudos

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.