Question Status

Suggested Answer
Ricky Scott asked a question on 9 May 2012 10:19 AM

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\

 

Reply
Zach Henry responded on 9 May 2012 10:51 AM

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?

Reply
Suggested Answer
Fernando Pires responded on 22 May 2012 1:38 AM

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

Reply
STDN responded on 23 Oct 2012 2:08 PM

Hi Mate,

I was able to resolve this issue by deleting records from 'Denomination Currency' Table.

Reply
Robert Leach responded on 23 Oct 2012 3:01 PM

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

System Administration->Setup->System Parameters

Reply
STDN responded on 23 Oct 2012 8:55 PM

Yes, I have defined system currency under system parameters.

Reply
Francesco responded on 19 Feb 2013 6:21 AM

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?

Reply
Stephen Schaefer responded on 5 Mar 2013 6:25 PM

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.  

Reply
Fadi Ghrawi responded on 25 Mar 2014 9:17 PM

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

Reply
RobinK responded on 1 Dec 2014 7:59 AM

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
Reply
Fadi Ghrawi responded on 1 Dec 2014 8:16 AM

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

Reply
RobinK responded on 1 Dec 2014 8:39 AM

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

Regards

Reply
Suggested Answer
Fernando Pires responded on 22 May 2012 1:38 AM

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

Reply