Skip to main content

Notifications

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

How do I update field External Document No on Cust. Ledger Entry in Business Central Al language

Posted on by 30

Hi All,

In the Pic I add the field External Document No in (Posted Sales Inv. - Update) After that, the external document no field Appeared in the posted Sales invoice.

After that when I go to Cust Ledger Entry Table the field (External Document No) Modification does no appear.

And to be used on a customer statement report.

How to update on the code al language?

Kindly assist,

Update-Posted-Sales-Invoice.PNG

6560.CustLedgerEntry.PNG

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 72,941 Super User 2024 Season 2 on at
    RE: How do I update field External Document No on Cust. Ledger Entry in Business Central Al language

    Hi, I'm not sure how you added this field, there is some code needed after adding the field.

    More details: How to extend the Posted Document Update page (A solution for editing Posted Document)

    https://yzhums.com/24923/

    Also, I am not sure if the External Document No field will update the Customer Ledger Entry table, you need to test it in detail.

    Hope this can give you some hints.

    Thanks.
    ZHU

  • Suggested answer
    Nitin Verma Profile Picture
    Nitin Verma 21,091 Super User 2024 Season 1 on at
    RE: How do I update field External Document No on Cust. Ledger Entry in Business Central Al language

    Hi,

    I dont think the functionality you ran it will update the customer ledger as well, you need to customize the solution to update all related customer ledger entries of your posted invoices.

    Thanks.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: How do I update field External Document No on Cust. Ledger Entry in Business Central Al language

    You should use this integration event and write code for updating the Customer ledger entry there:

      [IntegrationEvent(false, false)]

       local procedure OnAfterRecordChanged(var SalesInvoiceHeader: Record "Sales Invoice Header"; xSalesInvoiceHeader: Record "Sales Invoice Header"; var IsChanged: Boolean)

       begin

       end;

    The integration event is in page 1355.

    Remember to give your code unit permission to modify the customer ledger entry.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans