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 / Finance | Project Operations, Human Resources, ... / Exporting vendor trans...
Finance | Project Operations, Human Resources, ...
Answered

Exporting vendor transactions with financial dimensions using electronic reporting

(0) ShareShare
ReportReport
Posted on by Mika Hartio 105

I have been trying to generate a report that displays vendor transactions including the ledger accounts and financial dimensions used for posting. I am using the electronic reporting framework.

However, I am facing trouble when trying to find the correct tables/paths to display the financial dimensions for the transactions.

I need to find the tables to show the ledger account + dimensions for the main account and offset account used for posting. The starting point is VendTrans table.


I've been trying different paths to reach GeneralJournalAccountEntry table but so far the output is either not a desired one or there is an error when executing the format.

pastedimage1604630799632v2.png

If someone could point me to a right direction regarding what table path I should use to find the correct dimensions it would be greatly helpful.

(I am aware of the existing following thread: https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/399996/export-financial-dimensions-through-electronic-reporting/1083348#1083348 , however, it did not solve my issue)

Best regards,

Mika

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

    Hi Mika,

    When you record a vendor transaction -  for example for an expense invoice - then you usually debit expense accounts and credit the vendor account.

    Are you interested in the financial dimensions that are used with the expense accounts or those that are used with the vendor account?

    Do you make use of split postings, meaning that you post multiple expense account lines for a single invoice?

    Can you also provide us with some more details what your report should include and look like?

    Many thanks and best regards,

    Ludwig

  • Mika Hartio Profile Picture
    Mika Hartio 105 on at

    Hi Ludwig,

    I would like to capture both; the dimensions used for the vendor account and the ones used for the expense account(s).

    I make use of split postings as well.

    Please see the example below for a draft of what the report should look like.

    Basically I need a transaction list per vendor transaction voucher.

    pastedimage1604645704070v1.png

  • Verified answer
    Mika Hartio Profile Picture
    Mika Hartio 105 on at

    The problem was solved by nesting a filtered generaljournalentry table inside the vendtrans table.

    The filtering was done by comparing the voucher number and DataAreaId fields of each table (FILTER() function was used).

    This way I could also get the correct dimension values from generaljournalaccountentry table. 

    Thank you for your time.

    Best regards,

    Mika

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans