Skip to Content
Former Member
Jan 20, 2012 at 11:22 AM

SAP Business One System Requirement



I have a client who is currently in SAP Business One 8.81 with PL 08.

There are 12 SAP Users and they have three active companies in SAP Business one, Two companies is integrated with Website , one company is using Zedit Ecommerce application and another is using Comgine ecommerce application. These two application create orders\invoice into SAP Business one which were placed through website.

Third company have the add-on which imports the EDI files and post invoices into SAP Business One. Each EDI file contains about 1000 invoices, all the thousand invoices get imports into SAP Business One in AR side as well as AP side (add-on create AP invoice and AR invoice). They also have add-on which create incoming payment for thousand of invoices.

Their current working process is one or two user imports the EDI file, one or two users makes payment other user correct the due date for the invoices or cancel and create new invoice(by creating credit memo) to correct error in invoice. On an average 6 users works at same time.

Company 1 and 2 work fine, but since more users are working on company three and EDI import and cash apply process continously using transaction tables two users always get clash, so sometimes we are receiving the deadlock error from SQL also many transactions are getting failed with different errors from SDK (these errors were related to SQL). I assume transaction getting failed because while one user is trying to create the invoice other user is accessing the same table. I see it always happen when SQL memory get above 70%.

Do any one have suggestion what is the recommended system configuration for this type of environment for both on client and server side? Do i need to host the SQL server in seperate machine and SAP server on different machine?

Client current system configuration is as follows.

SAP Business One 8.81 PL:08

Hardware Configuration of Server:-

Windows Edition : - Windows Server 2008 R2 Standard

Processor: Intel(R) Xenon(R) CPU E5645 @ 2.40 GHZ 2.39 GHz (4 Processors)

RAM : 12 GB

System Type : 64 - Bit Operating System

Your suggestion will be higly appreciated.