Small and medium business | Business Central, N...

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

(2) Share

Report

Posted on by MA-09010215-0

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)

All responses (3)

Answers (0)

Sort by

Suggested answer

Khushbu Rajvi. 22,818 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hope this helps: https://community.dynamics.com/forums/thread/details/?threadid=c161c2db-be8a-4cfc-8564-747cb5016ed3

https://www.linkedin.com/pulse/following-sql-error-unexpected-invalid-column-name-id-bech-andersen

Was this reply helpful? Yes No
Suggested answer

Alexander Drogin 262 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 101,995 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If you are an end user, please contact your partner.

And hope the following can give you some hints.

https://forum.mibuso.com/discussion/60930/quot-invalid-column-name-quot-when-migrating-to-nav2013-r2

https://community.dynamics.com/forums/thread/details/?threadid=ea272eb4-1c76-452f-a737-9dfffe1c9a7f

https://community.dynamics.com/forums/thread/details/?threadid=2c8c7bc1-061d-4f13-a897-fa25507e3dee

Thanks.

ZHU

Was this reply helpful? Yes No

Join the conversation

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

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

Featured topics

Product updates

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the May Top 10 Community Leaders

Subscribe to this forum!

Select categories

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

Featured topics

Product updates