System message 515 during Closing for year

(0) Share

Report

Posted on by jjsmithcmh

Dynamics SL 2018 CU2. We receive the following error when trying to close for the year. This only happens on 1 of 2 application databases. We do not use multi-currency and I cannot find any null values in CuryAcct or AcctHist.

System Message 515: [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot

insert the value NULL into column 'BalanceType', table

'Checksmart.dbo.CuryAcct'; column does not allow nulls.

INSERT fails.

I have the same question (0)

All responses (1)

Answers (0)

jjsmithcmh 5 on at

Like (0)

Report

RE: System message 515 during Closing for year

Found the issue. There was a LedgerID in CuryAcct that did not exist in the Ledger table.

Was this reply helpful? Yes No