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

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

The primary key in the Sales Line table can contain only one field, and its type must be Integer.

(0) ShareShare
ReportReport
Posted on by 2

I am facing an error after running Full Synchronization in Integration Table Mappings.(Sales Header)

 

Error message:
The data could not be updated because of the following error: The primary key in the Sales Line table can contain only one field, and its type must be Integer.


 

Additionally, in the Sales Line table, the fields Item No. and Document No. are not appearing in Integration Field Mapping.

SALESORDER-LINE

 
SALESORDER-ORDER


I have attached the Excel sheet containing the field list (CRM and Business Central) for your reference.

 

Best regards,

I have the same question (0)

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 225

#2
DAnny3211 Profile Picture

DAnny3211 134

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 129 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans