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

(2) Share

Report

Posted on by MSAEI

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:

Dynamics 365 Commerce

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MSAEI,

You need to build and synchronize DB.

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,093 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
MSAEI 92 on at

Like (0)

Report

Thank you.

Was this reply helpful? Yes No