04-18-2012 4:34 PM
Hi, I'm trying to import throw DTW the Good Recipient PO with its lines.
I'm using tihis template:
OPDN
RecordKey;DocNum;DocDate;CardCode;NumAtCard;Series;TaxDate;U_IndVettore
RecordKey;DocNum;DocDate;CardCode;NumAtCard;Series;TaxDate;U_IndVettore
1;2128;20120417;F86337;121203;86;20120417;xxx
PDN1
Recordkey;BaseType;ItemCode;Quantity;Price;BaseEntry;BaseLine;LineNum
RecordKey;BaseType;ItemCode;Quantity;Price;BaseEntry;BaseLine;LineNum
1;22;68967;3;2.35;20916;0;0
1;22;137819;1;2.35;20916;1;1
1;22;137835;1;1.45;20916;2;2
1;22;137894;1;1.45;20916;3;3
1;22;143589;2;1.5;20916;4;4
I also tried without the LineNum column but, in any case, it add to the database the new Good Recipient PO but only with the last line (1;22;143589;2;1.5;20916;4;4).
Why?! Anybody can hel me?
04-18-2012 6:53 PM
I do not know DTW (Data Transfer Workbench), as I never worked with a Business One system, but the problem looks similar to what some have with LSMW .
I looks like you create a transaction for any item line (PDN1) And hence the second overwrites the first, the third overwrites what was written with the second, etc, and finally the last record survives.
Maybe this very good video can help you over your issue: http://www.youtube.com/watch?v=2kitUWIzZGM
04-18-2012 6:53 PM
I do not know DTW (Data Transfer Workbench), as I never worked with a Business One system, but the problem looks similar to what some have with LSMW .
I looks like you create a transaction for any item line (PDN1) And hence the second overwrites the first, the third overwrites what was written with the second, etc, and finally the last record survives.
Maybe this very good video can help you over your issue: http://www.youtube.com/watch?v=2kitUWIzZGM
04-19-2012 8:03 AM
04-20-2012 4:45 PM
I solved my problem by writing all the template fields for PDN1 and leaving blank the unnecessary ones.