Update UDO's using DTW cause additional row added

[former_member419030]

Dear Experts,

Im having below issue, realted to UDO.

I have created one UDO, and for the first time, i uploaded all the data using DTW and successful.

Now, im trying to update some row details inside this UDO, however, instead of update the row, the system add the details as a new row.

Below is the UDO Details :

Parent Table : BP Code, Field 1

Child Table : Code, Field 2, Field 3, Field 4, Field 5

Then, when I create DTW template, i get below template :

Parent Template : CODE, Name , Field 1

Child Template : Parent Key, LineNum, CODE, Field 2, Field 3, Field 4, Field 5

I believe, CODE, and Parent key should be the same value, which is BP Code, and lineNum can be either start with 0, or 1.

I had no idea why the end result is a new row instead of just only update the row.

Thank you in advance.

[ANKIT_CHAUHAN]

Hi MD Amall,

Your issue relates to SAP Note 2212871.

You need to select the options 'Keep Existing Lines and Add Source Lines' and 'Delete Existing Lines and Add Source Lines' carefully while trying to update UDO Data using DTW.

Hope it helps!

Kind regards,

ANKIT CHAUHAN

SAP Business One Support