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.
Found the issue. There was a LedgerID in CuryAcct that did not exist in the Ledger table.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,558
Super User 2024 Season 2
#2
Martin Dráb
228,647
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (