Showing posts with label Report. Show all posts
Showing posts with label Report. Show all posts

Thursday, May 21, 2015

SSRS report deployment error

A lot of error can pop up when we deploy the report from AX one of them is "User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.", below are some few place that you can check whether it's already being configured properly:
  • Check whether UAC has been properly set up (disable it for the fastest way)
  • Set respective user as administrator in SSRS server.
  • Check whether respective user has access rights to the SSRS folder
The easiest way to resolve this was to add the respective users to the whole SSRS site as "System admin" role on below location at your SSRS report manager

Wednesday, May 6, 2015

Dynamics AX 2012 SSRS changes not reflected after deployment

After we change the report format at Visual Studio and save it; sometimes when we deploy it from AX client it won't reflect the changes. I've spend quite some times to check why it's not reflected. There are few points that you can check :
  • Check whether Visual Studio properly save the report into AX (most cases)
    • Try to close the "Designer" before saving the report
    • Try to "Add to AOT" not only save
  • Deploy the report directly from Visual Studio (fast workaround)
  • Delete all *.auc file at respective users appData folder
You can always "compare" the report to see the changes.

Friday, May 9, 2014

A currency to convert from is required to retrieve exchange rate information error

An error regarding currency information sometimes very hard to get a hint where is the missing part, below is one of the error for currency when you execute the "Order line not invoiced" report in Microsoft Dynamics AX 2012 R2.
I have had check in the transaction all of them using base currency but still hit this error.

A currency to convert from is required to retrieve exchange rate information.
(S)\Classes\xInfo\add
(S)\Classes\Info\add - line 94
(S)\Classes\Global\error - line 3
(S)\Classes\ExchangeRateHelper\handleError - line 23
(S)\Classes\ExchangeRateHelper\validateFromCurrency - line 6
(S)\Classes\ExchangeRateHelper\getExchangeRate1 - line 24
(S)\Classes\CurrencyExchangeHelper\calculate - line 42
(S)\Classes\CurrencyExchangeHelper\calculateTransactionToAccounting - line 21
(S)\Data Dictionary\Tables\Currency\Methods\mstAmount - line 20
(S)\Classes\Tax\amountExclTax - line 187
(S)\Classes\Tax\baseAmountExclTax - line 132
(S)\Data Dictionary\Maps\SalesPurchLine\Methods\amountExclTax - line 100
(S)\Data Dictionary\Tables\SalesLine\Methods\amountExclTax - line 3
(S)\Data Dictionary\Maps\SalesPurchLine\Methods\lineAmountExclTax - line 25
(S)\Data Dictionary\Tables\SalesLine\Methods\lineAmountExclTax - line 3
(S)\Classes\SalesNotInvoicedDP\getFromSalesLine - line 12
(S)\Classes\SalesNotInvoicedDP\processReport - line 21
(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 59

The reason of this error is because of the AX system can't find the exchange rate within the date of transaction.
You can fix this by filled in the currency exchange rates within the range of the transaction date (for each of the currency exchange rate)