Skip to main content

Notifications

Business Central forum
Suggested answer

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

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.

Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,612 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,423 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,217 Moderator 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,217 Moderator 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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans