Notifications
Announcements
No record found.
Hi there, we got an requirement to develop and customized data entity based on CustTrans Table. As a part of requirement, we need to fetch LedgerAccount details from GeneralJournalAccountEntry table. When i try to join based on voucher with GeneralJouranlEntry table and based on GeneralJournalEntry with GJAE table, i didn't able to fetch the exact records. Please suggest how i can join the tables so that i can get the Ledgeraccount details from GJAE table. Thanks in advance.
Hi Perm,
You can evaluate to use voucher as key:
GENERALJOURNALACCOUNTENTRY.GENERALJOURNALENTRY = GENERALJOURNALENTRY.RecId
GENERALJOURNALENTRY.SubLedgerVoucher == CustTransTrans Voucher
Hi Prem,
Can you share what you have done to build the query and tell what is the current wrong behavior with some examples?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 451 Most Valuable Professional
André Arnaud de Cal... 428 Super User 2025 Season 2
BillurSamdancioglu 239 Most Valuable Professional
