Dynamics Community Forum Thread Details

GP Attempting to Insert Row into FA User Data instead of Updating Row.

We have configured 5 fields in the Fixed Asset User Data (FA19900) table to contain key information. However, when our Fixed Asset Accountant attempts to update the data, she gets an error "This record has been changed since you opened this window." If she deletes the row and reenters it, she can then go back and update that data.

We've verified that the length of the data does not exceed the length of the field, and have performed all the steps in http://support.microsoft.com/kb/2581263.

When looking at the SQL Logs, the following statement fails a primary key constraint on FA19900.

BEGIN INSERT INTO GPWP.dbo.FA19900 (ASSETINDEX, USRFIELD1, USRFIELD2, USRFIELD3, USRFIELD4, USRFIELD5, USRFIELD6, USRFIELD7, USRFIELD8, USRFIELD9, USRFIELD10, USRFIELD11, USRFIELD12, USRFIELD13, USRFIELD14, USRFIELD15, NOTEINDX, LASTMNTDDATE, LASTMNTDTIME, LASTMNTDUSERID) VALUES ( 4338, '', '', '18', 'EVEHAR', 'Raleigh', 'Wake', 'NC', '', '', '', 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 34711.00000, '2015.03.23', '11:35:57', 'Axxxxxx') ; SELECT @@IDENTITY ; END

Has anyone ever had this happen before?

Quick Links

Leaderboard