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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Detail Trial Balance i...
Microsoft Dynamics GP (Archived)

Detail Trial Balance in Converted Currency

(0) ShareShare
ReportReport
Posted on by kjjson

I have a client that is looking for a detailed trial a balance in the converted currency. Using Management Reporter, we can set that up somewhat using the "transaction" level, but where the account isn't listed on every row, there is no good way to filter/pivot/review the information without doing quite a bit of cleanup after exporting to excel. Has anyone ever seen a way to do this? Does Jet reports give this functionality, and how does Jet do with Currency conversion in general? (I believe you need the professional version to do currency?)

I am debating just writing my own sql view that does the conversion based on date/exchange rate table lookup, but really don't want to re-invent the wheel if someone has seen something else or had any ideas.

Thanks,

Kevin

*This post is locked for comments

I have the same question (0)
  • Greg Byer Profile Picture
    Greg Byer 2,588 on at

    Hi Kevin,

    MR will show you the converted amount at the transaction level, but you have to drill down to it.  If you export that to Excel, you'll have a tab with the transaction detail on it.  One tab with financial, another with account detail and another with transaction detail.  

    If you were to list each account on a line of its own in the row definition, you'd still need to drill down to the transaction detail level of the report to see each transaction in its functional and converted currency.  There's not a way to show transaction information at the top level of the report.  With each account on its own line, you'd see the account detail at the top level, but not the transactions that make up that account balance.  

  • kjjson Profile Picture
    kjjson on at

    Greg,

    Thanks for the reply. Yes, I understand all of that, the issue has been the client isn't happy with the -T report as it has the account at the beginning, but not on each individual line and there are blanks, and groupings by period, etc rather than a listing of transactions with the account number that you could just pivot off of, search, etc).

  • Greg Byer Profile Picture
    Greg Byer 2,588 on at

    Unfortunately, we cannot change much on the transaction level of the report.  The way MR formats it with the account number and then the transactions on individual lines, is hard coded.  There are some minor changes you can make to the detail levels if you go to Settings | Other | Account & Transaction Details, in the report definition.  But I don't know that these will make the changes you are looking for.  

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans