DB Connection between LedgerJournalTrans and associated GeneralJournalAccountEntry records

DB Connection between LedgerJournalTrans and associated GeneralJournalAccountEntry records

This question is answered

I am producing a report for an auditor looking at posted transactions for a specific voucher. I can get the voucher from LedgerJournalTrans, and I can link the journal from LedgerJournalTable to GeneralJournalEntry.

 

My question is, can I link a specific line in the LedgerJournalTrans table to the specific lines in the GeneralJournalAccountEntry table to get the posted transactions for that line?

 

I have looked at the fields in the tables, and it so far appears that only the text of the line is common, not a great join condition. Or am I going about this wrong, is there another way to find this information. Doing it in the application by looking up a transaction is not an option, as I need to look at almost all entries for 3 years.

 

Thanks for any help

Verified Answer
  • Hi, not directly, since can not find a direct link. But since what I mainly wanted was the Voucher Nbr that applied to the individual lines posted, I was able to bring in the table SUBLEDGERVOUCHERGENERALJOURNALENTRY and join it to the GENERALJOURNALENTRY table to get the vouchers for each line. This worked out for what I wanted. Hope that helps

All Replies
  • Hi, Did you find any solution to this? I have the similar situation.

    Thanks,

  • Hi, not directly, since can not find a direct link. But since what I mainly wanted was the Voucher Nbr that applied to the individual lines posted, I was able to bring in the table SUBLEDGERVOUCHERGENERALJOURNALENTRY and join it to the GENERALJOURNALENTRY table to get the vouchers for each line. This worked out for what I wanted. Hope that helps

  • I also need to link GeneralJournalAccountEntry (or GeneralJournalVoucherView) to specific LedgerJournalTrans records. Is this possible???