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

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

(5) Share

Report

Posted on by NP-26051046-0

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,

Sales Line fields...

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (5)

Answers (0)

Sort by

André Arnaud de Cal... 304,711 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Moved the question from the Dynamics 365 General to the Business Central forum.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 100,212 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

This is a bit strange, have you tried resetting all the default integration tables? I remember having it in the action bar.

PS: Dynamics 365 Sales and Business Central integration setup (Set up a connection to Dataverse and Set up a connection to Dynamics 365 Sales)

https://yzhums.com/8566/

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,510 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Namaste @NP-26051046-0 ,

Sales Line Table in Business cnetral has "Document Type , Document Number , Line Number" as Primary key . As per above error its little confusing which table are you referring for . Sales Line Feilds i have gone through the excel . Is it some other integration table . If yes then u have to sync from CRM table to middle dataverse table .

Hope below links help to solve , Old community threads.

https://docs.microsoft.com/en-us/dynamics365/business-central/marketing-integrate-dynamicscrm?tabs=current-experience#handling-sales-order-data

https://community.dynamics.com/forums/thread/details/?threadid=a0403818-2d44-483a-be4e-42a87ee16033

https://www.youtube.com/watch?v=-PaLA_Jl8Gw - Youtube link

If you feel helped , please verify the answer

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Nimsara Jayathilaka. 5,001 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!

Hi

It is key mapping Error Occuring So It is compulsory to add the Sales Line primary keys to your Excel file and try again.

Thanks

Nimsara

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Rishabh Kanaskar 6,225 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi,

This error occurs because the integration mapping for Sales Line is not set correctly. The Sales Line table has a composite primary key (Document Type, Document No., Line No.), but Dataverse integration only supports a single-field integer key.

To fix:
Remove Sales Line from your integration table mappings, or
Create a custom integration table with a single-field integer primary key that mirrors Sales Lines and use that table for synchronization.
Direct synchronization of Sales Line with Dataverse is not supported out of the box.

Thanks

Rishabh

Was this reply helpful? Yes No