add a new field to Worflow text

Question

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

Israel Braunfeld · Answer

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

Sage X3

add a new field to Worflow text

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING