Skip to main content

Notifications

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

The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

(0) ShareShare
ReportReport
Posted on by 40

Hello Experts, I am trying to do integration Between Business Central and D365 Sales using Standard Method provided by Microsoft. I am able to Integrate Sales Invoice Header Data but i am facing issue in Sales Invoice Line. Here Below is the description of error. 

Case : First create new order in Sales then sync Sales Order in Business Central then Invoice this order then posted Sales Invoice Sync in CRM so Invoice is created with Header Level but not Line level data sync and gave below error, If Sales Order create in Business Central(Not sync from Sales) then create invoice and this invoice sync in Sales so work fine and create Invoice in Sales side with Header and Line Level data. But issue create when sales order come from Sales. 

Error: The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 74,036 Super User 2024 Season 2 on at
    RE: The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

    Hi, Although not recommended, you can give Configuration Package a try.

    Clear the Validate Field option of CRM, and then re-import.

    This should delete the association and maybe can post it in BC.

    pastedimage1671149822818v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

    The only thing that I can say is that you cannot post the sales order or sales invoice and then create sales invoice lines.  That may not be what you were trying to explain....

    I agree with Marco, work with your partner.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

    hi

    look this

    community.dynamics.com/.../the-record-cannot-be-deleted-because-it-is-associated-with-another-record

    DAniele

  • RE: The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

    Hello Daniele its not dirty data

    Thanks for reply

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

    hi

    maybe you have dirty data

    DAniele

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: The Sales Invoice Line record cannot be updated because it is coupled to a deleted record.

    Hello,

    Best probably is to ask your partner to assist you with this and / or raise a question to Microsoft support. It will be very hard to troubleshoot this in an efficient way via forum support without seeing the data.

    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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans