Question Status

Verified
David Brough asked a question on 19 Feb 2013 10:02 AM

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

Reply
happy D responded on 26 Feb 2013 10:15 AM

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

Thanks,

Reply
Verified Answer
David Brough responded on 26 Feb 2013 11:47 AM

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

Reply
Robert Lipstreu responded on 31 May 2013 7:54 AM

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

Reply
Verified Answer
David Brough responded on 26 Feb 2013 11:47 AM

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

Reply