Hi All,
Currently the invoice header does not have a customer telephone number. How can I create an UDF that grabs the customer's telephone number and add the udf inside of Invoice Header table?
Thanks.
Did you just include your answer in your question? Go to Custom Office, create a UDF to the Invoice Header and the Invoice Works file and make the source the telephone number from the customer master file.
Hi BigLouie, once I give the udf name for invoice header in Custom Office, THe source I select Business Object, I only see SO_invoice_bus for business object and datasource I cannot find phone number.
Also do I need to create 2 different UDF? one for Invoice Header and another for Invoice Works?
Business Object = SO_Invoice_bus
Data Source = CustomerNo
Column = Telephone Number
Do the same for the works table.
ah ok. Do the 2 new UDF that I need to create has to be different names or can be the same
do not have to be the same. can be different but what name would you use instead of "telephone"?
correct, I thought it had to be different like Telephone_Wrks and Telephone_Inv. Thanks!
Hi Louie, for the works table, do I choose "SO Invoice Work"? If I do choose it Business Object has "So_InvoicePrint_rpt and "So_InvoiceHistoryPrinting_rpt" and what datasource and column to select? thanks again.
Hi Louie, for the works table, do I choose "SO Invoice Work"? If I do choose it Business Object has "So_InvoicePrint_rpt and "So_InvoiceHistoryPrinting_rpt" and what datasource and column to select? thanks again.
*Community Hub is the new name for Sage City