Announcements
No record found.
How can I get the relation between projId (from projTable) and the generalJournalEntry or the ledgerJournalTrans?
*This post is locked for comments
Hey Glenn,
There is no direct relation between ProjID and the LedgerJournalTrans and GeneralJournalEntry.
If you want to view all postings related to the a certain ProjID, you can look at the ProjTransPosting table. With a BI solution you can make a many-to-many connection to connect the GeneralJournal(Account)Entry with the ProjTransPosting.
Thanks for Your anwser.
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.
CP04-islander 16
GiacomoRovai 4
Douglas Noel 2