Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
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, 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
Hi, Did you find any solution to this? I have the similar situation.
I also need to link GeneralJournalAccountEntry (or GeneralJournalVoucherView) to specific LedgerJournalTrans records. Is this possible???
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics