web
You’re offline. This is a read only version of the page.
close
Skip to main content
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 101

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)
  • Verified answer
    Mika Hartio Profile Picture
    Mika Hartio 101 on at
    RE: Exporting vendor transactions with financial dimensions using electronic reporting

    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

  • Mika Hartio Profile Picture
    Mika Hartio 101 on at
    RE: Exporting vendor transactions with financial dimensions using electronic reporting

    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

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard 33 Microsoft Employee on at
    RE: Exporting vendor transactions with financial dimensions using electronic reporting

    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

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans