Error when opening sales order 'The added or subtracted value results in an unrepresentable date/time

Owned by Beth Blok (Unlicensed)
Last updated: Nov 21, 2022 by Mike SheenVersion comment
1 min read

Problem

This problem occurs when the Sales Order Customer Panel is enabled and the user has entered an invalid number of days in the field 

Solution

Advanced SQL skills are required

Advanced SQL skills are required to complete this task

 

The information for this field is stored in the table SY_UserProfile against each user ID where the IDKey = NumberDays.  Work out the relevant user ID and run the following update query entering the appropriate data.  The user will need to logout and back in again for changes to take effect.

update SY_UserProfile set Contents  = '365' where UserID = '000000001Z000000000I' and IDKey = 'NumberDays'