web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Journal Voucher Transa...
Microsoft Dynamics AX (Archived)

Journal Voucher Transactions

(0) ShareShare
ReportReport
Posted on by ScorpioDax 333

Hey Guys,

I am stuck and need some help.  I am trying to build a view that will have all the fields that are in the Journal Voucher, i am having a hard time getting the Offset Account to show.  

I am using the LedgerJournalTrans table in a view and then add a child data source to that from DimensionAttributeValueCombination table since the LedgerJournalTrans.OffsetLedgerDimension is related to that table.  I am only getting the AccountNum on both ends as you can see on the pics.  

2018_2D00_05_2D00_04_5F00_8_2D00_57_2D00_37.jpg

Any help would be greatly appreciate!

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi ScorpioDax,

    Why do you need to create this view?

    Have you tested the "dimension statement" standard report, which allows you selecting transactions including the offset account.

    Probably have a look at how this report is setup.

    Best regards,

    Ludwig

  • ScorpioDax Profile Picture
    ScorpioDax 333 on at

    Hi Ludwig,  

    That report actually does provide some detail that i am looking for but i am trying to create the view so we can export that into excel and create a data model off that so we can create some pivots.  

    I am basically looking to take the voucher transactions and add vendor detail and GL account to it so we can analyze our payables.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hello ScorpioDax,

    Please have a look at the standard cubes and views/tables that you can analyze through Excel out of the box. Not sure whether such an adjustment is required.

    Best regards,

    Ludwig

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 301,141 Super User 2025 Season 2 on at

    Hi ScorpioDax,

    Why are you using the LedgerJournalTrans as base for voucher transactions? It is possible to clean up this table; then your report is not working anymore. You have to report based on the tables GeneralJournalEntry and GeneralJournalAccountEntry if you need to have posted transactions. 

  • ScorpioDax Profile Picture
    ScorpioDax 333 on at

    Hi Andre, yess i am looking for posted transactions and trying to get all vendor detail with the voucher and Journal entries.

  • ScorpioDax Profile Picture
    ScorpioDax 333 on at

    Hi Ludwig,

    Actually yes it looks like it does have allot of the detail i am looking for with the exel add in.  How do you pull in vendor detail and join the two General Journal entries with the Vendor detail?

  • ScorpioDax Profile Picture
    ScorpioDax 333 on at

    HI Andre,

    Thank you for the direction that helped me.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans