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
Hi, Did you find any solution to this? I have the similar situation.
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???