Sage 100

Cannot get some UDF's to work. The UDF's are just not there in the ODBC connection from Crystal. Have deleted and re-entered the UDF's, same result. Is there a way to manually add them? I'm thinking no, but worth a shot. Sage 100 Standard, V 4.50.07 running Point of Sale Pro.

I seem to remember Alnoor or someone at Sage telling me about renaming the Links folder while working with the UDFS in order to get them to show up, then renaming Links back. I have some vague notes on it - I had this happening at a client and finally could only get it to work in MAS90 mode (they were MAs200).

Did you do a ""Verify Database"" in Crystal?

Yes Doug. That is where it tells me that it cannot find the UDF. Recent conversion. All seemed well, but for SO Printing on a highly customized form. When I add a new UDF it performs the same way as the missing existing UDF's.

From an old KB article..... Possible Workarounds: If a backup is available from prior to the Custom Office installation, restore the following files to the ..\Mas90\Mas_System folder:: CM_UDF.M4T CM_Entity.M4T CM_UDFIOList.M4T. If no backup is available, reinstall all modules that have a Product Key. Recreate every UDF for all modules except General Ledger. (The General Ledger UDF's should still be intact.) Note: The UDFs must be recreated in the same order as they existed on the prior version.? If the UDF's are not listed alphabetically, then each UDF will have to be updated before adding the next one. The UDFIOList has to be the same order as the UDF's so that it points to the correct field in the UDF file. If the data has just been migrated from a prior version: Install Sage MAS 90 4.0 to a new location and migrate the files to that installation. Note: Do not delete the existing installation. Copy all five CM_*.M4T files from the new ..\Mas90\MAS_System folder to the existing installation. Note:? The new installation can be deleted once this procedure is performed.

Thanks. will be giving it a try.

Well the backup / restore did not work. I will be working on an alternate location install...and followup with results. Thanks.

Annette have you verified that the last version of Sage you used is the upgrade from which you're looking for the UDFS? Doesn't Sage automatically flip the ODBC to point to the last version of Sage started on your machine? Just a thought.