MASS UPDATE INVOICES/JEs TEXT FIELDS (UDF, REF 2, etc)

[Former Member]

Is there a possibility to mass update UDF or System Fields (ref fields, remarks, etc) to specific invoices or journal entries through excel or any add-ons or any other way?

I have multiple User Defined Fields for different purposes, for more details. Hence the requirement by invoice, je.

Thanks

Sajid

[JerushaLala]

Hi Sajid

Have you tried using the Data Transfer Workbench.

You will need to reference your invoices by the DocEntry and just add the UDF's to the excel template, eg U_UDF1 | U_UDF2.

I would suggest do do a test in a test DB and see if it works for you.

Regards,

[Johan_H]

Hi Sajid,

UDFs you can update by direct query. None volatile system fields like for example Comments and NumAtCard, you could also update by query, but you have to really know what you are doing, or you may compromise your SAP support.

Using the DI API you could build yourself a small windows application with only a few lines of code to perform mass updates.

Regards,

Johan