Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Greg Byer Profile Picture
    Greg Byer 2,586 on at
    RE: Detail Trial Balance in Converted Currency

    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.  

  • kjjson Profile Picture
    kjjson on at
    RE: Detail Trial Balance in Converted Currency

    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,586 on at
    RE: Detail Trial Balance in Converted Currency

    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.  

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans