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 :
Supply chain | Supply Chain Management, Commerce
Answered

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'XXX'.

(2) ShareShare
ReportReport
Posted on by 139
Error message:
 
Operation canceled: Picking list
Posting - An error occurred during updateFix issues
 
UPDATE SALESTABLE SET DOCUMENTSTATUS=?,RECVERSION=?,MODIFIEDDATETIME=?,MODIFIEDBY=?,MODIFIEDTRANSACTIONID=? WHERE ((RECID=?) AND (RECVERSION=?))
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'RFQ_CUSTOM'.
Object Server Azure:
PostingPosting Sales order: SO-023757 Cannot edit a record in Sales orders (SalesTable). Sales order: SO-023757, Soule Company Corporate. The SQL database has issued an error.

Background: I created a custom field with in the sales table and deleted the field. Later, this issue is primarily impacts the sales table. Currently users are unable to create or modify sales order, as well as posting. All processes related to sales orders are being affected. 
 
Please help me to fix the issue.
 
Thank you
Categories:
I have the same question (0)
  • Verified answer
    Mohamed Amine Mahmoudi Profile Picture
    26,801 Super User 2026 Season 1 on at
    Hi @MSAEI,
     
    You need to build and synchronize DB.
     
    Best regards,
    Mohamed Amine MAHMOUDI
  • Suggested answer
    Komi Siabi Profile Picture
    13,208 Most Valuable Professional on at
    If this is happening on Production, you would have to Sync just like Mohammed mentioned, promote your changes to UAT then Production.
     
    You can always make sure that you Finance and Operations project in Visual studio always synchronize on build to avoid such occurrence.
  • Yamini Upputuri Profile Picture
    139 on at
    Thank you.

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 March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
Mallesh Deshapaga Profile Picture

Mallesh Deshapaga 287

#2
Laurens vd Tang Profile Picture

Laurens vd Tang 212 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 145 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans