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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 514 Super User 2026 Season 1
Giorgio Bonacorsi 390
Adis 266 Super User 2026 Season 1
