Report Error: A currency to convert from is required to retrieve exchange rate information.

(0) Share

Report

Posted on by Scott Cap

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?

Stack trace:

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 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

(S)\Jobs\

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Report Error: A currency to convert from is required to retrieve exchange rate information.

[quote user="Fernando Pires"]

I had a simmilar issue when creting a query and for me the solution was to add the field CurrencyCode to the SalesTable datasource.

[/quote]Worked for me

Was this reply helpful? Yes No
Muhammad Yousaf 1,339 on at

Like (0)

Report

RE: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

Hi robin, did you manage to solve this issue

Was this reply helpful? Yes No
RobinK 25 on at

Like (0)

Report

RE: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

Thanks for your replay, that will help at least a little bit.

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

Hi,

If I remember correctly, it have something to do with the currency exchange table.

Nothing technical, pure functional, but my memory can't help any further.

Hope that this can help.

Regards

Was this reply helpful? Yes No
RobinK 25 on at

Like (0)

Report
RE: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

Fadi Ghrawi did you manage to find a solution?

I got this suddenly on the free text invoice.

My callstack:

(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\ExchangeRateHelper\getCrossRate - line 21 (S)\Classes\ExchangeRateHelper\getCrossRate_Static - line 28 (S)\Classes\SalesInvoiceDPBase\getAccountingExchangeRate - line 14 (S)\Classes\SalesInvoiceDPBase\init - line 94 (S)\Classes\FreeTextInvoiceDP\init - line 5 (S)\Classes\SalesInvoiceDPBase\createData - line 15 (S)\Classes\SalesInvoiceDPBase\processReport - line 17 (S)\Classes\FreeTextInvoiceDP\processReport - line 7 (S)\Classes\SrsReportRunRdpPreProcessStrategy\execute - line 27 (S)\Classes\SrsReportRunRdpPreProcessService\executeWithContract - line 82 (S)\Classes\SrsReportProviderQueryBuilder\runPreviewModePreProcessedRdp - line 29 (S)\Classes\SrsReportProviderQueryBuilder\initialize - line 55

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

Hi,

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.

any help?

reagrds

Was this reply helpful? Yes No
Kooper 150 on at

Like (0)

Report

RE: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

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.

Was this reply helpful? Yes No
Francesco 524 on at

Like (0)

Report

Re: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

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?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Re: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

Yes, I have defined system currency under system parameters.

Was this reply helpful? Yes No
Robert Leach 90 on at

Like (1)

Report

Re: AX 2012 Report Error: A currency to convert from is required to retrieve exchange rate information.

Can you confirm that you've specified the system currency in:

System Administration->Setup->System Parameters

Was this reply helpful? Yes No