Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 19, 2017 at 06:59 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 19, 2017 at 06:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded