Skip to Content
0
Dec 26, 2011 at 03:21 PM

Adding Warehouses to existing Items. Using DTW.

143 Views

Dear Experts !

I'm trying to Add Warehouses to existing Items Using DTW.

I'll describe the problem I'm facing and the steps I've performs so far.

Problem : When trying to enter a LineNum>MaxLines(Itemcode) I'm getting an error as follows :

Enter a vaild code (OITW.WhsCode),'1-999-973' Application defined or object defined error 65171

if I choose anything lower than MaxLines(Itemcode) I assume it just tried to update that LineNum on my Itemcode.

Using the DTW I've choose Master Data, and Update feature.

I've created 2 files as follows

items file oitems.csv :

RecordKey ItemCode

RecordKey ItemCode

1 1-999-973

whsupdate.csv file :

RecordKey LineNum WarehouseCode

<-- -Do not fill this row ----->

1 12 45

I ran the query Gordon provided on one of the posts I came across

SELECT COUNT(ItemCode) FROM OITW T0 WHERE T0.ItemCode = [%0]

and made sure that my LineNum>MaxLines(ItemCode)

Any Help would be much appreciated.

-NC