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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Synchronise Remaining ...
Small and medium business | Business Central, N...
Suggested Answer

Synchronise Remaining Amount field in Posted Sales Invoice from BC to CRM

(1) ShareShare
ReportReport
Posted on by Nina_01 17
Hi all,
 
how can I get Remaining Amount from Posted Sales Invoice to sync to CRM?
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Pradeep Rai Profile Picture
    Pradeep Rai 5,489 Moderator on at
    You can try with Power Automate and we below BC connector.
    https://learn.microsoft.com/en-us/connectors/dynamicssmbsaas/

    Once you get the data then you can put this value into dynamic CRM dataverse using dataverse connector.
  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,794 Moderator on at
    Hi,
    Since its a calculated field so you need to indentify when you want to sync to crm and so that you can use below event to indentify your field both side.
     
    [EventSubscriber(ObjectType::Codeunit, Codeunit::"CDS Setup Defaults", 'OnAfterResetCustomerAccountMapping', '', true, true)]
    Thanks
    Nitin
     
     
  • Suggested answer
    HVGEEL Profile Picture
    HVGEEL 310 on at
    Apart from the technical answers... let's look at it from a functional point of view.
     
    There is no such thing as THE Remaining Amount on T113 Posted Sales Invoice. Go find it., and drill down.
    It would not make sense, since the remaining amount is kept in the Customer Ledger Entries (CLE)
     
    Depending on your localization
    - you have either 1 CLE referring to your Invoice
    - you have payment installments (for example Italy): hence multiple CLE's for 1 Posted Sales Invoice
     
    You will not need to find the remaining amount in the Posted Sales Invoices, but in the Customer Ledger Entries... that have the document Number of your Posted Sales Invoice.
     
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,717 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 995 Super User 2026 Season 1

#3
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 628 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans