web

You’re offline. This is a read only version of the page.

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... System message 515 dur...

Finance | Project Operations, Human Resources, ...

Unanswered

System message 515 during Closing for year

(0) Share

Report

Report

Posted on by jjsmithcmh

5

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 Img

All responses (1)

Answers Img

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

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 701 Super User 2025 Season 2

#2

Martin Dráb 588 Most Valuable Professional

#3

Sumit Singh 544

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans