cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
1,794

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

ok thank you anyway

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

Hey dude, question is answered now. Thanks anyway

Former Member
0 Kudos

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
Participant
0 Kudos

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
Active Contributor
0 Kudos

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