Skip to Content
0

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

Apr 18, 2017 at 01:10 PM

94

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Jerusha Lala Apr 19, 2017 at 06:59 AM
1

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,

Share
10 |10000 characters needed characters left characters exceeded
Johan Hakkesteegt Apr 19, 2017 at 06:28 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded