The capability of SAP B1 to handle 10,000 invoices per day.

[onanongj]

Hi Experts.  There are rumors among SAP B1 competitors that SAP B1 can handle only about 2500 invoices per day.  My question is “From a technical standpoint, can SAP B1 handle loading up to 10,000 invoices per day, where each invoice contains an average of 10 inventory items (i.e., around 100,000 records per day), given that the database is SQL Server and invoices are loaded via API in daily time intervals?”

[frank_wang6]

10000 invoice with 10 rows is a lot, but B1 should be able to handle without issue, although you do need a relatively powerful server to do so, and fast SSD. 

To be honest, adding Invoice is not the real issue but applying payments to those invoices could slow things down though, especially you would use one payment to cover many invoices (thousands or more). So if you do use one payment to cover many invoices, it would be better to design some automation and help to automatically apply the payment in the night time when system load is low.

I did this for amazon sales reconciliation before, it is one payment to cover over 100,000 invoices.

[luiz-aragao19]

Hi!

I already saw B1 working without issues in a retailer store in Brazil, working with a number of invoices close to what you have, including the generation of fiscal documents with the government. In the end it all relates to how much do you have available for you environment itself.

Additionaly, I would say that it would be better to have it running on HANA instead of SQL Server, but you should be aware that it increases the investment needed on hardware so you can take full profit over HANA capabilities.

As Johan also said, it is best to first get demonstrations from your partner so you can get the best resource for your needs.

Cheers,

Luiz.

[Johan_Hakkesteegt]

Please note that the benefit of HANA is on the reading side of the system (looking up data, running reports, etc.)

[Johan_Hakkesteegt]

Hi,

Competitors will always claim that their system is better and faster, but writing 100,000 records per day is a lot for any database / ERP system in the SMB space.

Whether it is SAP Business One, or any other system, I recommend that you require a load test on a test system, and a demonstration of how usable that test system is, both while invoices are being written at that rate, and considering that the database will grow very large very fast, I also recommend that you require a demonstration of a (test) system with a database size of at least 500 GB.

In short, don't take anyone's word for it, except mine of course 😉

Regards,

Johan