Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012
Upgrading to Microsoft Dynamics AX 2012
Data Import, Export, and Migration
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
SSRS and SSAS Integration
I'm running the AR > Order Lines Not Invoiced report in AX 2012 and getting the following error:
"A currency to convert from is required to retrieve exchange rate information."
I'll paste the stack trace below but it appears to be failing in the area of Sales Tax. We're only using USD, no foreign currency. I cannot find any empty or incorrect currency field values. Any suggestions?
A currency to convert from is required to retrieve exchange rate information.
(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 36
(S)\Classes\CurrencyExchangeHelper\calculateTransactionToAccounting - line 21
(S)\Data Dictionary\Tables\Currency\Methods\mstAmount - line 20
(S)\Classes\Tax\amountExclTax - line 188
(S)\Classes\Tax\baseAmountExclTax - line 122
(S)\Data Dictionary\Maps\SalesPurchLine\Methods\amountExclTax - line 67
(S)\Data Dictionary\Tables\SalesLine\Methods\amountExclTax - line 3
(S)\Data Dictionary\Maps\SalesPurchLine\Methods\lineAmountExclTax - line 11
(S)\Data Dictionary\Tables\SalesLine\Methods\lineAmountExclTax - line 3
(S)\Classes\SalesNotInvoicedDP\getFromSalesLine - line 11
(S)\Classes\SalesNotInvoicedDP\processReport - line 21
(S)\Classes\SrsReportProviderQueryBuilder\initialize - line 57
This doesn't really answer you question. But I was able to run the report and it executed fine. So that would eliminate it being an AX bug in general. Not being extremely knowledgable with the front end of AX about the only thing that I can come up with to ask. Is the cusotmer currency USD? Are you doing this with just one transaction?
I had a simmilar issue when creting a query and for me the solution was to add the field CurrencyCode to the SalesTable datasource.
I was able to resolve this issue by deleting records from 'Denomination Currency' Table.
Can you confirm that you've specified the system currency in:
System Administration->Setup->System Parameters
Yes, I have defined system currency under system parameters.
I'm running into the same issue in one of our administrations. Nothing stands out on the currency set up (compared to our other administrations).
Did you ever get this resolved?
I was getting this same error message when opening the Settle Open Transactions for a specific customer. I was able to eliminate this error by opening the Currency field in the Sales Demographics fast-tab of the Customer Master. Click on the Recent tab and then click on the Clear Recent button at the bottom.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics