Error while opening Bank Account List in Dynamics NAV 2016

srinivas_dynamics

Hi all,

Below error is getting when opening Bank Account List in Dynamics NAV 2016.

Error:

Microsoft Dynamics NAV

---

Hint 'noexpand' on object 'Test.dbo.24 Mantra$Bank Account Ledger Entry$VSIFT$1' is invalid.
Statement(s) could not be prepared.

Page Edit - Bank Account must close.

---

OK

---

Thanks in advance,
Srinivas.

AlexeyShamin

Hello!

version SQL and NAV?

First: try rebild all swift keys on table Bank Account Ledger Entry.

Second: Try to set parameter ON on SQL Server:
ANSI_NULLS
ANSI_PADDING
ANSI_WARNINGS
CONCAT_NULL_YIELDS_NULL
QUOTED_IDENTIFIER