topic Re: OPDN in Application Development and Automation Discussions

OPDN

Former Member — Wed, 18 Apr 2012 15:34:24 GMT

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?

Re: OPDN

JL23 — Wed, 18 Apr 2012 17:53:10 GMT

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

Re: OPDN

Former Member — Thu, 19 Apr 2012 07:03:24 GMT

This not solve my problem

Re: OPDN

Former Member — Fri, 20 Apr 2012 15:45:21 GMT

I solved my problem by writing all the template fields for PDN1 and leaving blank the unnecessary ones.