Announcements
No record found.
Hi there, we have created an Data entity based on GeneralJournalEntry and GeneralJournalAccountEntry Tables. As per the requirement, we need to fetch the TaxTrans.Taxcode in relation with our data entity based on voucher. Is there any relation to join TaxTrans.recid with any of the 2 mentioned tables. Thanks in advance.
Hi Perm,
You can use voucher as key between GENERALJOURNALENTRY and TaxTrans.
GENERALJOURNALENTRY.SubLedgerVoucher == TaxTrans Voucher
GENERALJOURNALACCOUNTENTRY.GENERALJOURNALENTRY = GENERALJOURNALENTRY.RecId
Hi Alireza, I had tried with the way you suggested but am getting the duplicate records. I have to call the TaxTrans based on Recid only to get the required output. Please find the screenshot attached for reference.
Case 1 : Query executing GENERALJOURNALACCOUNTENTRY table alone.
Case 2 : Query as u suggested. It was returning 500 records which is not as expected. I need to fetch as many records there in GENERALJOURNALACCOUNTENTRY table for which i need to fetch TaxTrans.Taxcode for the particular voucher
Hi Prem,
Yes.
You can check LedgerJournalTrans.
TaxTrans.SourceRecId == LedgerJournalTransRecId
TaxTrans.SourceTableId == LedgerJournalTrans.TableId
Hi ALireza, i had already checked that Table LedgerJournalTrans but i still cant able to establish an relation as per my requirement. Pls suggest the necessary
To better understand your requirement. Does standard report "Posted sales tax" work for you? Or do you need TaxCode on voucher transactions level?
Hi ALireza, i need to capture Sales Tax Code on Vocuher transaction Level
I have tried to establish an relation based on Journal Number. Please go through the query attached and suggest the needful
Query :
SELECT * FROM GENERALJOURNALENTRY LEFT JOIN TAXTRANS ON
GENERALJOURNALENTRY.SUBLEDGERVOUCHER = TAXTRANS.VOUCHER
AND GENERALJOURNALENTRY.JOURNALNUMBER = TAXTRANS.JOURNALNUM
AND GENERALJOURNALENTRY.ACCOUNTINGDATE = TAXTRANS.TRANSDATE
There is a table in between the GeneralJournalAccountEntry and the TaxTrans table. The name of this table is TaxTransGeneralJournalAccountEntry. It has a reference to both the account entry and the tax transaction. This should be the missing link in your requirement.
Hi Andre, How I can join these 3 tables as when I tried to join I can't able to see the required outcome.
Query : SELECT * FROM GENERALJOURNALACCOUNTENTRY LEFT JOIN TAXTRANSGENERALJOURNALACCOUNTENTRY ON GJAE.RECID = TTGJAE.GENERALJOURNALACCOUNTENTRY
LEFT JOIN TAXTRANS ON
TTGJAE.TAXTRANS = TAXTRANS.RECID
please suggest the needful in the query
What is the current outcome and what exactly are you looking for?
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!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 698
André Arnaud de Cal... 567 Super User 2026 Season 1
