Get total debit and credit against voucher in x++
In Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012, it is really difficult to get total debit and credit against voucher of payment journal shown as follows:

Voucher debit and credit fields on the form are not having the permanent table in back-end. Moreover, these fields are using display methods written in the data source. And, these display methods are using LedgerJournalEngine class to get these values. So, I am sharing the following code for all of you:
//Author: Moeen Ahmed Sultan
//Email: moeenahmedsultan@gmail.com
//Tel: +92 321 458 9595
LedgerJournalEngine ledgerJournalEngine;
LedgerJournalTrans ledgerJournalTrans;
LedgerJournalTable ledgerJournalTable;
ledgerJournalTable.clear();
ledgerJournalTrans.clear();
select ledgerJournalTrans
where ledgerJournalTrans.Voucher == "VOUCHER NUMBER"; //Add voucher number in the double quotes against which you want to get total debit and credit.
ledgerJournalEngine = new ledgerJournalEngine();
ledgerJournalTable = ledgerJournalTable::find(ledgerJournalTrans.JournalNum);
ledgerJournalEngine.newJournalActive(ledgerJournalTable,true);
info(strFmt("%1 - %2", ledgerJournalEngine.voucherDebit(ledgerJournalTrans), ledgerJournalEngine.voucherCredit(ledgerJournalTrans)));
In this way you can get voucher debit and voucher credit values using x++. Moreover, if this helps you, please Like, Comment and Share to help other people.
Note: I have tested this code is tested in D365FO but not in AX 2012.
If you found any ambiguity or a better solution, please feel free to ask.
Download code: Click here
Blog: Click here
YouTube: Click here
GitHub: Click here
I have got a dream that’s worth more than my sleep. – Eric Thomas
Pingback:Calculate totals of PO using X++ in D365FO | NevoiTech Blog
Pingback:Calculate totals of RFQ reply using X++ in D365FO | NevoiTech Blog