I meant to post this a while ago, but apparently didn’t and have just found the screen shots again. This was reported to me by a client who was trying to run a multicurrency report in Management Reporter.
When columns were flagged with currency translations, this error was produced and shown in the Report Queue Status window:
An internal error occurred in the provider. Additional information is available in the event viewer on the Management Reporter server. Please contact the administrator.
I checked in the event viewer and found this error:
Invalid column name 'TranslationDebitAmount'.
Invalid column name 'TranslationCreditAmount'.
After doing some investigation, I realised that this error is one I have seen before. The issue is that there is a longstanding bug in the legacy connection of Management reporter; if you need to use currency translations, then you need to be using the Management Reporter Data Mart.
What should we write about next?
If there is a topic which fits the typical ones of this site, which you would like to see me write about, please use the form, below, to submit your idea.