crystal: linking invoice to s/o UDF

[cudaboy71]

We're in MAS90 4.1

I just added an S/O UDF field. Now,I need to display its contents on printed invoices.

looking at the current crystal invoice, it is using SO_23CRWInvoiceDetail to link to SO_21LineItemExtDescription and SO_26CRWInvoiceDataHeader. these are the only references to S/O as it runs now.

what is the most efficient link to pull the data I need from SO_90_UDF_SalesOrder?

I tried leftouter joins (individually, not at the same time) on both SO_23.SalesOrderNumber and SO_21.SalesOrderNumber to SO_90.SalesOrderNumber but get a 'column not found' error when querying the SO_90.NEWUDF.

any advice?

thanks.

 

[BigLouie]

Well first in v4.10 Sales Order no longer used a separate UDF table such as SO_90. Second you would NOT add the table but instead would add the field to the works table using Custom Office. Search in Help for the term "MAP".

Plus you should be posting on the new Sage Community.