REALLY COULD USE SOME ASSISTANCE WITH THIS
Deanne asked 7 years ago
The INSERT statement conflicted with the CHECK constraint ‘CK_PA10001_PATE_47AE9581”. The conflict occurred in database “ARFUS”, table ‘dbo.PA10001”, column ‘PATE’. The statement has been terminated.
The map has Create timesheet and Add line item
This map is not referencing PATE anywhere – why do we get this error?
The map has Create timesheet and Add line item
This map is not referencing PATE anywhere – why do we get this error?
Answers
Lorren Zemke Staff answered 7 years ago
Deanne,
If you change the map destination to Dynamics GP – File, does it show a value or node in the XML for the PATE column? If there is a value, does it have a date of 1/1/1900, which Dynamics GP requires for Time fields.
If there is no value, then you will probably need to check with Microsoft on why the taPATimeSheetLineInsert eConnect procedure is throwing that error. Another option would be to set a default PATE value in the map or int the taPATimeSheetLineInsertPre procedure.
Lorren
If you change the map destination to Dynamics GP – File, does it show a value or node in the XML for the PATE column? If there is a value, does it have a date of 1/1/1900, which Dynamics GP requires for Time fields.
If there is no value, then you will probably need to check with Microsoft on why the taPATimeSheetLineInsert eConnect procedure is throwing that error. Another option would be to set a default PATE value in the map or int the taPATimeSheetLineInsertPre procedure.
Lorren