Skip to main content

We come from a version update to 2023R2, and in tables like the original acumatica PREmployeeDeduct, when updating it the following error appears, which did not happen in the previous version 2021R1, for the migration we logically made 2 jumps, the database is in sql server 2017, please have any clue

 

PD. I've checked other posts, but I can't find any clues.

Hello @gparrales50 ,

I know you checked other posts, but which posts did you try?

 

The following post answered by Naveen has a solution that worked for other people.  Please confirm whether you added the  ConvertZeroDateTime=True in the web.config → Connection String as recommended by @Naveen Boga :

https://community.acumatica.com/develop%2Dcustomizations%2D288/error%2Din%2Dtstamp%2Dfield%2Dwhen%2Dsaving%2Drecords%2D16939

 

(The previous post is MySQL:  Naveen or another clever developer will need to help us figure out whether the same answer could apply to SQL Server.)

Laura


gparrales50,

Not my area of expertise.  Looking at similar issues, things to try.

  • Make sure the description is not empty.
  • Make sure Year is populated and correct

If those fail, recommend you open a case with Support.


Hello @gparrales50 ,

I know you checked other posts, but which posts did you try?

 

The following post answered by Naveen has a solution that worked for other people.  Please confirm whether you added the  ConvertZeroDateTime=True in the web.config → Connection String as recommended by @Naveen Boga :

https://community.acumatica.com/develop%2Dcustomizations%2D288/error%2Din%2Dtstamp%2Dfield%2Dwhen%2Dsaving%2Drecords%2D16939

 

(The previous post is MySQL:  Naveen or another clever developer will need to help us figure out whether the same answer could apply to SQL Server.)

Laura

Hi Laura,
I'm using Sql Server, the recommendation is for MySql.
Thank you for the suggestion.


gparrales50,

Not my area of expertise.  Looking at similar issues, things to try.

  • Make sure the description is not empty.
  • Make sure Year is populated and correct

If those fail, recommend you open a case with Support.

Hi Sonia,

I have indeed opened the case, although I still have no response.
Thank you for the suggestion.


Reply