ITCWST: Arithmetic overflow error converting numeric to data type numeric. – General Discussion – Sage X3

For some reason, TIH data type was customized to Supervisor (should be Common Data), Length is 4 (should be 4.4), and Adonix format is 4.5# (should be 4.4#). No activity code can be found on the TIH data type.

Readjusting the value to Common Data, Length to 4.5 instead, and Adonix format keep resolved the VALDICO error.

However, the error in SQL Server can still reoccur if following the CAST method.

There is no issue if run without the CAST to catch the SQL data type size issue.