add a new field to Worflow text

SUGGESTED

Hello,

I created a workflow that send invoices to my users.

In the text field of the workflow I would like  to add the email address of the customer with a specific function (KCNTFNC).

I tried to add the CUSTOMER table in the formula wizard (new table/view) but it doesn't seem to work.

Even if it did, I don't know how to filter the result by  KCNTFNC.

Do you have any idea how I should proceed? Is it at least possible?

Thanks in advance

Parents
  • 0
    SUGGESTED

    I created a generic function that would return the email for any BP/site/user... that has the specified function. I call this function from many different places. In the function I filter the table CONTACT for the specified bp and the specified function, the email is in the WEB field.

    I would call my function something like this

    func ZPROCESS.Z_EMAIL_FUNCTION(1,[F:POH]BPSNUM,3)

    in the text of the workflow it is called as follows 

    |func ZPROCESS.Z_EMAIL_FUNCTION(1,[F:POH]BPSNUM,3)|

    The first parameter is to filter CONTACT.BPATYP, in this case 1 = BP, the second param I pass the supplier BP of the PO this is to filter CONTACT.BPANUM, the third param is the CONTACT.CNTFNC field in this case I pass 3 = function sales manager

    If you just need this for one workflow you can add the CONTACT table to your data model and filter on the above three fields

  • 0 in reply to Israel Braunfeld

    Hello thank you for your answer.

    As I am pretty new with the whole sage X3 solution, would you mind telling me if there is a documentation somewhere on how to create such function or data model ?

    Thank you

Reply Children
No Data