5
Hello, I need to filter for vouchers beginning with CIV, WO, etc with the ledger account beginning with 113120. To my understanding this requires bringing the ledger account over to the custtrans table. I am a little confused as there is a generaljournalentry and other tables. What is the relationship needed to accomplish this? thanks
Hi
Use custtrans voucher to connect genenraljournalentry table through subledgervoucher
And from generaljournalentry you will find a connection to generaljournalaccountentry by using recid
Something like this,
Share
Report
All responses (
Answers (
Public static void voucher(Args _args)
{
CustTrans custTrans;
GeneralJournalEntry generalJournalEntry;
GeneralJournalAccountEntry generalJournalAccountEntry;
select custTrans
where custTrans.Voucher == "Yourvoucher"
join generalJournalEntry
where generalJournalEntry.SubledgerVoucher == custTrans.Voucher
join generalJournalAccountEntry
where generalJournalAccountEntry.GeneralJournalEntry == generalJournalEntry.RecId
{
info(strFmt("generalJournalAccountEntry %1", generalJournalAccountEntry.TransactionCurrencyAmount));
}
}
Uday
#1
André Arnaud de Cal...
294,430
Super User 2025 Season 1
#2
Martin Dráb
233,043
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
