provide some suggestion about items max volumn

[Former Member]

Hi experts

I would like to know the max items number for B1.

My customer have about 20,000 items, and every item have about 35 WH.

Is this volumn OK for B1?

could you provide some suggestion about items max volumn?

Glen

[former_member186095 · Accepted solution]

Hi,

there is a MS. Excel file whose file name is database size estimator. The file is used to calculate the database size, growth per year and also it is useful to use before buy server and its component, I mean before installation.

I use the file before implementing SAP B1 in a certain company that have 150,000 items and 30 whses. It is okay until present and the database still run smooth

Rgds,

[Former Member]

Hi Glen,

There is no hard limit to number of items. The only concern is performance. In you case, 20,000 is pretty normal. However, for 35 WH, that is a bigger issue. You have to limit item creation in all WH. Otherwise, you will end up with 20,000 X 35 records in OITW.

Thanks,

Gordon

[former_member204969]

I do not know a maximum number of items, but your data is manageable.