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
I had a simmilar issue when creting a query and for me the solution was to add the field CurrencyCode to the SalesTable datasource.
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 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.
am hitting the same error, but my scenario is different.
am creating a sales order, and then am doing a direct delivery, which will ask me to create a PO.
the PO is created successfully, and it can be confirmed and i can register the quantity to be received.
but when i try to post the product receipt i hit this error "
A currency to convert from is required to retrieve exchange rate information"
just to highlight that am able to create a normal PO and register and Post the product receipt, invoice it and everything is going very well.
even thought when i create a PO from SO also it works fine, this error only accrue when i do direct delivery.
so i guess it have something to do with updating the SO status and posting.
if the direct delivery PO is received and the product receipt is posted, then the main SO status should be updated to received automatically, and here goes the error.
I test all other scenarios and all are working fine.