Sage 100

2014 Premium. I can create a SO_SalesOrderDetail UDF, but when I look at the table in SQL, the field isn't created. When I access UDF maintenance, the attached error appears, but when I click OK, I can continue to create the UDF. I am not sure if this message is related to the field not being created in SQL.

Maybe have everyone out of the system, then delete and re-create the UDF?

I tried that about 10 times with the same result. The field looks fine in custom office, but doesn't get created in the database table.

Is bar code active? Reboot the server?

@JeffSchwenk Yes. They have bar code. I checked the date on the bc_commonimport.pvc file and it has a 1/12/2018 date on it. They are in the process of implementing warehouse automation / bar coding, so it may be related to the implementation. I see the original bc_commonimport.pvc file from v2014 has a date of 5/19/2014.

I rebooted the server and getting the same error message. I don't see a ""bc_rejections"" file anywhere.

Can you check if your SQL has replication setup?

Double check to make sure new orders are being written to the SO Detail table. I had this happen the other day, and the tables SQL flag was removed. There was an SO_SalesOrderDetail.m4t file in the MAS_xxx folder. PIA to correct, but if the same thing is happening to you, the new UDF would be in the M4T file, not SQL.

This issue has been resolved. The error message was unrelated to the UDF fields not being created in the SQL table SO_SalesOrderDetail. The error message was resolved by running the Bar Code Setuo, Convert Bar Code program. @MichelleForsey gets a gold star for calling this one. There was a SO_SalesOrderDetail table in the MAS_XXX\SOXXX folder with today's date on it (suspicious). The solution is to locate the SALESORDERDETAIL record in the providex.ddf (data dictionary) file, and change the SQLCreateTable=0 to SQLCreateTable=1.

Thank you for all of the suggestions!

credit should actually go to @NicoleRonchetti who identified it on my system!

Thanks @NicoleRonchetti !