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... / The following SQL erro...
Small and medium business | Business Central, N...
Suggested Answer

The following SQL error was unexpected; Invalid Column Name "Workflow Step ID"

(2) ShareShare
ReportReport
Posted on by MA-09010215-0 4
Hi All, 
 
Got this error when trying to access the Purchase Invoice Page in Microsoft Dynamics NAV 2018. Kindly need your expertise to solve this issue. Thank you very much.
 
Categories:
Microsoft Dynamics NAV
I have the same question (0)
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at
  • Suggested answer
    Alexander Drogin Profile Picture
    Alexander Drogin 262 on at
    This error means that the NST server built a SQL query with a table column that does not exist in the database, i.e. this is a field which is defined in the NAV table object, but not in the respective SQL table. This can happen if the NAV field is disabled (property enabled = false).
    Error message does not specify the table, so you'll need to search. Try to find any modified tables where the field "Workflow Step ID" is declared, but disabled.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 99,082 Super User 2026 Season 1 on at

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,946 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,177 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 555 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans