Default bin location with DTW

[former_member359894]

Hi,

Is it possible to import or update the default bin location for items via DTW,

Or should i do it manually?

Thx

Rafi

[ANKIT_CHAUHAN]

Hi rafigaon,

It seems that you are trying to update Default Bin Location for Warehouses associated with an Item.

If yes, you can use the template OITW - ItemWarehouseInfo in DTW. It has the column DefaultBin (DftBinAbs) available.

Refer to SAP Note 1328706 which describes how To Add/Update WarehouseInfo to Items.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[simiaofernandes]

Hi everyon,

I've extracted the Item details using the @Amir_Tamboli query.
However I got the error "Data Transfer workbench error: Index was outside the bounds of the array: File: C:\... check for missing columns" when I tried to create the CSV only with ItemCode, LineNum and BinLocation.

So, I created a new CSV with all OITW columns in DTW > Customize template;
And populated onlyt  the Item Code, LineNum, Warehouse and Default Bin Location (AbsEntry).
It worked fine.

bin0.txt

[Amir_Tamboli]

--Try below solution
--Run below query in your database and get data
--To update default bin location for the item by DTW

SELECT
--below three columns are requied in dtw template
T0.ItemCode,
ROW_NUMBER() over (partition by T0.ItemCode order by T0.ItemCode)-1 as "LineNum",
T0.DftBinAbs, 

--below two columns not required in dtw template just for information take here
T0.WhsCode,
T1.Inactive 
FROM OITW T0
INNER JOIN OWHS T1 ON T0.WhsCode = T1.WhsCode
WHERE T1.Inactive = 'N' AND T0.ItemCode = 'FG00010'

--Template is below

[simiaofernandes]

Hi Amir, thanks for your query.

this helped me a lot.