UDF in wrk table cannot be used in selection. They are only used for printing.

I added a UDF to the SO Invoice Header and don't see it in the database so I can add it to an invoice. How do I get it to appear? There is another UDF that I would like to add that will be a number that I'd like to use as a multiplier for a formula. Is that possible?

You need to add the UDF to the SO Invoice Work table.

So....through Custom Office? I misspoke when I said that I added it to Invoice Header--it's just SO Header. When I try to add it to SO Invoice Work, that is not available as a data source. Sorry for being so thick, but I was amazed that I got a UDF on the header, and that it did what I wanted it to.

To clarify: we are using Sage 2016. I created a mulit-line UDF on SO Header that will consist of user-entered text. On tab 3 when creating it, I didn't choose any data sources.

So....through Custom Office? I misspoke when I said that I added it to Invoice Header--it's just SO Header. When I try to add it to SO Invoice Work, that is not available as a data source. Sorry for being so thick, but I was amazed that I got a UDF on the header, and that it did what I wanted it to.

To clarify: we are using Sage 2016. I created a mulit-line UDF on SO Header that will consist of user-entered text. On tab 3 when creating it, I didn't choose any data sources.

The next step is to add the same UDF to SO Invoice Header in Custom Office. The UDF settings must match, i.e. the Data Type and Maximum Length (if Numeric). Look at how you setup the UDF on SO Sales Order Header then repeat on SO Invoice Header. When you create the SO Invoice Header UDF you need to click Data Sources, then select SO_Invoice_bus and select SalesOrderNo under Data Source, and then select your UDF under Column. What this will do is pull the UDF value from the SO when you create an invoice from a SO.

The next step is to add the same UDF to SO Invoice Work so that you can add it to your report. Business Object will be SO_InvoicePrinting_rpt, Data Source is SO_InvoiceHeader and Column is your UDF.
Now edit the invoice report in Crystal and add your UDF to the report.

OK, I will try that. I tried to increase the length of the field (from 50 to 80, just to cover my bases), but was told that SO Header was being used somewhere else, although nobody had SO open. If I do manage to increase it on SO Header, I'm guessing that it would need to be increased everywhere else?

Thanks for your guidance. I appreciate it greatly!

I did all that you suggested, but my UDF still wasn't showing up. Then I realized that my form used SO_SalesOrderWork, so I repeated the steps that you told me to add the UDF to the table, and voila! I look like I know what I'm doing. :P Thanks again!

Whoops, my last reply was aimed at myself by mistake, and I can't even delete my own comments! I just want you to know that I hugely appreciate your help.

No problem... job well done ;)