Skip to Content

UDF link to system object, field value question

Hi, I created a UDF that links purchase order to sales order. I was able to do so, however, I’d like to be able to show the docnum of the purchase order. With the UDF, it shows the row number and not the docnum. Can you pls give me suggestions on how to make this possible? I’m guessing creating another UDF (formatted search) to populate the PO docnum from the linked UDF. Am I correct?

using sap b1 9.2

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 16 at 05:47 AM

    Hi Pia,

    The available fields depend on the chosen table. A document is always registered in two tables, one contains the header data, like DocNum, and the other contains the row data, like LineNum.

    So you need to connect the UDF, or a new UDF, to the table that contains the DocNum field. You can turn on System information from the View menu, and hover the mouse arrow over the DocNum field, to find out which table you need (it will be displayed in the information field at the bottom of the left of the B1 client).

    Regards,

    Johan

    Add comment
    10|10000 characters needed characters exceeded

    • That worked Johan! Exactly what I was looking for, it also eliminated creating additional UDF's. Thank you so much! I appreciate the helpful tips as well. Will mark this solved and closed.

      Cheers!

      Pia