web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / SQL error when modifyi...
Small and medium business | Business Central, N...
Unanswered

SQL error when modifying a value in a table

(0) ShareShare
ReportReport
Posted on by Dietmar Wehinger 67

My customer is a foodbank and they have the CERES Addon in their 2016 NAV .  They have  posted entries for an Item with wrong value to the Item Ledger Report View table # 14012332. 

I created a processing report to modify one of the fields values but I'm getting an SQL error message (See attached). Looking at the properties of that table I see the Linked Property flagged as YES.

Any ideas how to resolve this issue?

Thank you

SQLError.png

I have the same question (0)
  • Gearoid Profile Picture
    Gearoid Microsoft Employee on at

    Hi,

    The problem is that the NAV table (Item Ledger Report View) is not a real table. Instead it is built on a SQL Server View. These SQL Views are build on SQL Server SELECT statements and return data in a tabular format which can look like a table for read only operations. However, there are strict rules about how you can update a view and it seems that in this scenario the view cannot be updated like a normal table for one of the reasons suggested by the error message you shared. 

    To resolve this you will need to understand the SQL View which the Item Ledger Report View table is based on. When you understand the View you can figure out how to UPDATE the underlying data which forms the view. For example, it may be that a single row returned by the View is an aggregation of several records from one or more underlying table(s). It may therefore be necessary to apply the data fix to all of the underlying records in whatever table the View is based on. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,086 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,290 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,218

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans