Finance | Project Operations, Human Resources, ...

How to join CustTrans Table with GJAE table

(0) Share

Report

Posted on by PK69

177

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.

All responses (2)

Answers (0)

André Arnaud de Cal... 293,278 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to join CustTrans Table with GJAE table

Hi Prem,

Can you share what you have done to build the query and tell what is the current wrong behavior with some examples?
Suggested answer

Alireza Eshaghzadeh 13,585 Super User 2025 Season 1 on at

Like (0)

Report

RE: How to join CustTrans Table with GJAE table

Hi Perm,

You can evaluate to use voucher as key:

GENERALJOURNALACCOUNTENTRY.GENERALJOURNALENTRY = GENERALJOURNALENTRY.RecId

GENERALJOURNALENTRY.SubLedgerVoucher == CustTransTrans Voucher