How well does the app work with a large number of Items in SAP Business One?

[thuth]

By the time of this writing, the largest known number of Item Master Data entries which a COBI.wms user has is about 150 000.

How well the app works with several hundred thousand items depends on a number of factors:

1. Will you always scan barcodes to identify items, or will you sometimes have to open the item list and enter a search term?

If you always scan barcodes, then the number of items doesn’t matter much during daily operation, because the app will run a query every time to find the item with the scanned code.

However, if you open the item list to find items, then the number of items can become a problem. See next part.

2. Is it possible to establish a direct database connection to the SAP Business One server, or will the app have to rely purely on Service Layer?

In on-premises and private-cloud deployments, it’s usually possible to open a direct connection to run custom SQL queries. In that case, the app should be able to handle up to a few hundred thousand items, although loading the item list for the first time every time the app is restarted may take up to about 20 seconds per 100 000 items. After the item list is queried once, it will be cached so long as the app is still running, so it will open immediately when you open it again.

In partner-hosted or SAP-hosted public-cloud deployments, the app usually has to do all communication over Service Layer. Sadly, this significantly degrades the performance when transmitting large amounts of data, so the app may not be able to load the item list at all. Scanning barcodes will still work the same.