Sage 100

To what table in Custom Office do you add UDFs to have them show up on this screen? I've done AR_Invoice Wrk, AR Invoice History Wrk and SO Invoice Wrk - am missing it or is it not avail? Ver. 4.50 (yes I'm upgrading them soon, 3rd party stuff holds it up)

I think you just need to go to so_invoiceheader or ar_invoiceheader and map to history to make them show here.

Thanks @NancyHanson I'll give that a try.

No, had the UDF already on those two files. Any other ideas?

Is it mapped to history ar_invhistoryheader?

Yes it is. Have it updating from SO Journal Update. It's the customer Sort Field, from the Customer Master as a UDF, they use the field a lot in reporting.

I added to these tables, in order: SO_InvoiceHeader, SO_SalesJournalWrk, SO_InvoiceHistoryLink, AR_TransactionPosting, AR_InvoiceHistoryHeader, and AR_InvoiceHistoryWrk and it shows up. (I called it SORT.)

In general it is Wrk table UDFs that show up in the report selections screens.

The forms have worktables, whereas item/customer/vendor etc use the main tables.

Checked through @MichelleTaylor1 list of tables and only added to the SO_InvoiceHistoryLink, the UDF existed in all the other tables listed. It still doesn't display as an option, could be 4.50 issue or something else - I'll keep at it and let you know what I find. Thanks everyone for your help.

@MoiraGoggin

Thanks @KellySappington that was already defined - I think it's a version issue at this point.

You might double check the field size and type of each UDF to be sure they are the same. That could interfere with the linking.

After the first field was defined, the rest are links via a business object rather than manual - so there isn't a difference in size or types, but thanks for idea.