How to upload Default Bin Location to Item Master in V9 PL05

[Former Member]

Hi - I have set up my Bin Location Master Data and imported all my Inventory Item Master Data via DTW in to SAP. Now I want to import the information telling SAP what bin location each Item is in but can't find which template to use as it doesn't appear on OITM.

Any suggestions?

Thanks

[Former Member]

ok thank you anyway

[Former Member]

After 1 hour I solved my own problem!

In DTW Generate Templates for Item Master Data

Select OITW ItenWarehouseInfo

Input stock code as Parent Key

Enter System Number in Default Bin Column

Select Y or N to enforce Default Bin

In DTW select Master Data

Update Existing Data

Inventory, Item Master Data, Item Warehouse Info

Hey Presto - It works!

[Former Member]

Hi tom

can you give your example file?

i've an item master date with many warehouses and only some of theme are with location

what do you suggest?

thank you

[Former Member]

Hey dude, question is answered now. Thanks anyway

[Former Member]

Hi Tim,

Regarding this solution, what if I will only set a default bin location for a certain warehouse?

Coz I tried uploading the template that you suggested, but the error always says "The entry already exists.."

Did I miss out on something?

Hope to hear from you. Thanks!

[nikunjmehta2290]

Hii,,

I also want set items with default bin location and upload via DTW. But , I am not able to find out Default Bin Column column and enforce Default Bin column into OITW template.

Please help me on that.

[kothandaraman_nagarajan]

Hi Tim Guest,

As of 9.0 version, the there is no template for bin location template.

Not sure in which version they added.

Please refer SAP note 1833098 - Bin Location template in DTW and overview SAP note for 9.0 PL04

1796099 - Overview Note for SAP Business One 9.0 PL04

Thanks & Regards,

Nagarajan