Update UDF in INVOICE with DTW

[ogallegosv]

Hi,

I need to update a udf lines, but nothing. I am using the fields: recordkey, linenum and UDF, which always has a valid value. I have also added AcctCode and ItemCode, but nothing.

Please, help me.

Best regards,

Oscar Gallegos

[former_member187989 · Accepted solution]

hi oscar,

It's not possible to update row level user defined fields except header level UDF's/header level fields(remarks,owner,sales employee,cutomer reference number) in DTW & also thru user interface

after adding a document.

If possible create user defined fields in title level and try to update thru DTW,If you have any

add on's connected,discconnect it,sometimes add on's will cause problem will updating UDF.

Hope this will solve problem

Edited by: Jeyakanthan A on May 14, 2009 10:36 AM

[ogallegosv · Accepted solution]

Hi Jeyakanthan:

Yes, yesterday I reviewed this issue and sees that it is not possible to change the lines, I am trying to do this via SDK but it is likely that SAP objects not let me update this information.

Thank you all for your feedback.

Best regards,

Oscar.

[Former Member]

Make sure test box is unchecked and field maps are correct.

Thanks,

Gordon

[ogallegosv]

Hi Gordon,

Yes, check box "Test" is unchecked.

Fields used in Doc: RecordKey, DocEntry

Fields used in lines: RecordKey, LineNum and <UDF> (Case 1)

Fields used in lines: RecordKey, LineNum,ItemCode and <UDF> (Case 2)

This process update table History (ADOC and ADO1) but not the document (OINV, INV1).

Best regards,

Oscar.

Edited by: Oscar Gallegos on May 13, 2009 4:53 PM

[Former Member]

Hi Oscar,

Does the field exist in B1?

Try mapping the field from your spreadsheet to the UDF in B1

Kiran

[ogallegosv]

Hi Kiran:

Yes, the field exist in B1 and in the file to update for dtw.

The process of update return "update successfull", but the data not update.

Best regards,

Oscar.

[Former Member]

Hi Oscar,

you might want to make sure that the value mappings are correct as well between source (spreadsheet) and the B1 database

Kiran

[former_member583013]

Oscar,

Try this,

In DTW Wizard step 3, Target data tab > select the checkbox 'Add all Items into Schema' and then click Next

Suda

[ogallegosv]

Hi Suda,

Idem, no update....help me please, I kill me ..... now!!!... JEJEJE

Best regards,

Oscar.

[former_member583013]

Did you query the database to check if these UDF's have been updated?

Do you have any formatted searches setup on these field on the actual Invoice form, which might be changing the data when you open the form.

Are these Invoices OPEN / CLOSED?

Which SBO version patch level and DTW version are you using?

I see 3 levels in your previous message on the DTW templates.

Fields used in Doc: RecordKey, DocEntry

Fields used in lines: RecordKey, LineNum and <UDF> (Case 1)

Fields used in lines: RecordKey

You actually need only 2 if you are dealing with HEader and Lines. Is the second line template relate to additional expenses?

YOU MIGHT PROBABLY NOT HAVE THE CORRECT DTW VERSION TO MATCH YOUR PATCH LEVEL

[ogallegosv]

Hi Suda,

I check the DB and not updated.

No, i don't formatted searches in this field.

Yes, somethings is CLOSED others OPEN.

I used PL47 and don't update additional expenses.

Best regards,

Oscar.

[Former Member]

All the closed documents would not be possible to update. Exclude all those data to check again.

[former_member583013]

Oscar,

When you are importing them, all transactions probably get rolled back when it hits an error.

So try to just import one record for a transaction that is not closed and test.

Suda