Skip to main content

Notifications

Business Central forum
Unanswered

Get invoices of payment using AL

editSubscribe (1) ShareShare
ReportReport
Posted on by 4
Hi Community, 
 
I creating a page extension in Bank Ledger entries where i created a action button. the button supposed to get the invoices applied to the selected line and will use the info of the invoice/s to add a line in a custom table. the problem is, the code i did manage to capture the information of the invoice only if there is only one invoice applied to the transaction. if the transaction has more than 1 invoices applied to it, for some reason the code only read one of the invoice. How can i capture the information of all the invoices applied.
 
 
this is the code of the function that im currently using for testing:
 
     var
        VLE: Record /Vendor Ledger Entry/;
        DVLE: Record /Detailed Vendor Ledg. Entry/;
        Comment: text;
     begin
        VLE.Get(Rec./Entry No./ + 1);
        DVLE.SetFilter(/Applied Vend. Ledger Entry No./, '%1', VLE./Entry No./);
        DVLE.SetFilter(/Vendor Ledger Entry No./, '<>%1', VLE./Entry No./);
        if (DVLE.FindSet()) then
            repeat
                message('Doc No: %1', DVLE./Document No./);
            until DVLE.Next() = 0;
     end;
The function supposed to supposed to popup several message showing the document no of the of the invoices depending by the number of invoice applied to it. but this only showed 1 invoice eventhough there supposed to be more than 1. Please Assist
  • gdrenteria Profile Picture
    gdrenteria 3,092 Super User on at
    Get invoices of payment using AL
    Hi
    This report is likely to give you some ideas.
    BR
    GR

Helpful resources

Quick Links

Take the Community feedback survey!

Answer this brief 15-question survey about your Community experience…

Demystifying Copilot: Service Edition with Sundar Raghavan

Sundar answers more questions about Copilot for Service...

Dynamics 365 Business Central vs Finance and SCM

Take a look at the key differences between Business Central and…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,373 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,212 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,140

Featured topics

Product updates

Dynamics 365 release plans