Dynamics Community Forum Thread Details

SL 7, SP3 AP Chk Register error 515

Client is running SL 7.0, SP3. They have at least 13 years of data in AP. I don't know if they ever ran Delete Detail in the past, but they don't believe they've done so in a long time. The AP Check Register report is standard, un-customized. Same with the Pre-process stored procedure - standard, un-customized.

If client tries to run a Check Register that includes the years 1999 or 2000, they get the SQL error message below. If the beginning period is in 2001 or later, there's no error.

--------------------------------------------------

SQL Server Message 515

Cannot insert the value NULL into column ‘Vendor_Name’, table APPDBNAME.dbo.AP03630MC_Wrk’; column does not allow nulls. Insert fails.

Debugging info: dbsqlexec,SqlCompile – ExecuteDbproc 2

Cursor(DefaultCreated) AP03630_pre33

Optional info: AP03630_pre33

--------------------------------------------------

I'm trying to figure out how to resolve this, wondering if anybody has seen this before and might have any ideas?

THanks,

John

Quick Links

Leaderboard