Number of lines in SAP B1 2007A
We have a client that use SAP B1 2007A on a SQL server 2005. The sometimes make very big sales quotations which exists of maybe 3000 rows. To my understanding, there is documentation saying there is no limitations on amount of rows it only affects performance. What would be the acceptable performance (measured in time) when adding line number 3001 on a sales quotation?
For our install, we wait maybe 20 seconds for adding the item and then we wait maybe 1 minute when updating the sales quotation. We are running on a machine with 4 processors and 4GB RAM.
Does anyone have some other experiences on this field?
Best regards, Runar Wigestrand.
Gordon Du replied
A 3000 line quote is too much for B1 to handle. The scenario you mentioned if not the worst in that amount of data. Although it is no limitations on amount of rows, the performance is the LIMIT.
Even if your client upgrade their hardware to double the performance, it will still be painful.
Better if they can change their current business process. I think the number of line can be trimmed if they set up item correctly.