Welcome to the Sage VIP Classic and Sage VIP Premier Support Group on Community Hub! Available 24/7, the forums are a great place to ask and answer product questions, as well as share tips and tricks with peers, partners, and pros.
After increasing length of DES Data Type to 250 and Validating. After I close X3 and re-open I cannot get into any function. I receive these errors: Function not defined for the value given
The correct syntax for the selection criteria for a Sage X3 date field is: [DD/MM/YYYY]
Classified as follows "DD=Day", "MM=Month" and "YYYY=Year"
Example :
Criteria using CREDAT in table for records with a CREDAT less than March 12th, 2020. …
Cause :
There is failure to communicate with MSSQL server.
Fix
1. Ensure SQL services are running
2. Ensure the servers can communicate if the system a multi tier.
3. Check firewall settings
Cause:
There are various possibilities including a corrupt ACLASSE table or an outstanding folder validation
Fix.
1. Try to validate the ACLASSE table through Development > Data and Parameters > tables
2. Test
if the above fix fails, perform…