This error comes up when using the consolidate joblines function. Select one of the options to consolidate by, then click update and the error appears.
This issue is related to the compatibility level of the SQL database.
- Log into SQL, go to the database in question, right click and select Properties.
- Go to Options - what is showing in the field Compatibility Level?
- Click on the dropdown box and select the highest level and then OK.
- Click on the Refresh button for the database, log off SAP Business One.
- Restart and test.