I want 5 warehouses to be added while creating item master in SAP B1 SQL

[Abhishek_Patil]

I want 5 warehouses to be added while creating item master in SAP B1 SQL

This contains the selective list of warehouses that should be added in item master while creating new master

[Johan_H]

Reposted as answer

Hi,

You can automatically add ALL warehouses to an item. (Administration > System Initialization > General Settings > Inventory > Items > Auto. Add All Warehouses to New and Existing Items)

You cannot add only a selection of warehouses this way.

To add only a selection of warehouses, you can use the DTW.

Regards,

Johan

[LoHa]

Hi

it is NOT allowed to do update/insert/delete queries in the B1 context in sql.

You have to use the dtw/import function in the client to add the items

regards Lothar

[Johan_H]

Hi,

You can automatically add ALL warehouses to an item. (Administration > System Initialization > General Settings > Inventory > Items > Auto. Add All Warehouses to New and Existing Items)

You cannot add only a selection of warehouses this way.

To add only a selection of warehouses, you can use the DTW.

Regards,

Johan

[Abdul]

Unfortunately, you cannot achieve it without having a small add-on or custom program.

A workaround could be to use FMS to lock unwanted warehousees. 

[Johan_H]

Double posted due to weird platform behavior.

Hi,

You can automatically add ALL warehouses to an item. (Administration > System Initialization > General Settings > Inventory > Items > Auto. Add All Warehouses to New and Existing Items)

You cannot add only a selection of warehouses this way.

To add only a selection of warehouses, you can use the DTW.

Regards,

Johan