Error - 94 Invalid use of null Can't add notes to specific account [00164174]
Customers may import jobs/notes, error during submission, or enter invalid characters during submission causing and invalid use of Null. This will in turn display an error similar to this one.
The following query can be ran within the SedonaOffice Client UI using the SQL command window with valid permissions to fix Notes with Null values.
//Update note set Edit_UserCode = Isnull(UserCode, '')
FROM SV_Service_Ticket_Notes note
Where Edit_UserCode is null
//Update nt set Notes = isnull(notes, ''), UserName = ISNULL(UserName, ''), Edit_UserCode = ISNULL(edit_usercode, '')
from AR_Customer_Notes nt
where Notes is null or username is null or Edit_UserCode is null
