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