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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156