Developer forum

Forum » Integration » Live Integration - BC - There is no Currency Exchange Rate within the filter

Live Integration - BC - There is no Currency Exchange Rate within the filter

E-mail notifications
Jesper Splidsboel
Reply
Posted on 29/11/2022 11:57:11

I Get this error when I request for a price in currency = "DKK" from BC.

"There is no Currency Exchange Rate within the filter"

If I request for price in EUR I get a response with data.

In BC default currency is "DKK" and prices is leaved with "empty" currencies in BC.

Can this setting i BC cause the error ? How can we make requests when this default currency is used in BC ?

Request:

<GetEcomData ExternalUserId="3570" AccessUserCustomerNumber="3570"><tables><Products type="filter"><Product><ProductId>6110869298M</ProductId><ProductVariantId></ProductVariantId><ProductNumber>6110869298M</ProductNumber><ProductUnitId></ProductUnitId><ProductIdentifier>6110869298M..LANG2</ProductIdentifier><CurrencyCode>DKK</CurrencyCode><Quantity>1</Quantity><ProductItemCategoryCode isCustomField="True"></ProductItemCategoryCode><ProductItemDiscGroup isCustomField="True"></ProductItemDiscGroup><ProductCountryOfOrigin isCustomField="True"></ProductCountryOfOrigin><ProductTUN isCustomField="True"></ProductTUN><ProductHScode isCustomField="True"></ProductHScode><ProductERPName isCustomField="True"></ProductERPName><ProductERPDescription2 isCustomField="True"></ProductERPDescription2><ProductERPDescription3 isCustomField="True"></ProductERPDescription3></Product></Products></tables></GetEcomData>


Replies

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 29/11/2022 11:59:38
Reply

Hi Jesper,
can you try with empty currency code in the request (<CurrencyCode></CurrencyCode>)?
BR, Dmitrij

 
Jesper Splidsboel
Posted on 29/11/2022 14:16:26
Reply

If I send empty <CurrencyCode></CurrencyCode> I get prices from default currency (DKK), but seems to use currency from website if my Currency on the logged in user is empty.

How can I remove all currency on my website, so I get prices from "empty" currency ?

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 29/11/2022 14:28:00
Reply

Hi Jesper,
I was checking the similar request with the latest vesion of our codeunit for cloud which is 1.2.0.29 and I can receive the correct response
even if I pass LCY/default BC currency in the request, and if I even pass some wrong currency code in the request I get the price in the default currency.
So maybe you are using a bit old Dynamicwb Plugin unit application.
What is yours version? Is it BC Cloud or OnPrem? Do you have New Prices feature activated in your BC?
BR, Dmitrij

 
Jesper Splidsboel
Posted on 30/11/2022 08:14:37
Reply

Hi Dmitriy,

I testet again, and if I send a CurrencyCode(random string) that not exists, I get prices from default currency. So the only thing I can't send is the CurrencyCode "DKK". The solution I found was to download the LiveIntegration project and change the code where we use Common.Context.Currency.Code and send "" if Currency is "DKK". I'm not happy about this solution, but could not find other solutions to this.

 
Dmitriy Benyuk Dynamicweb Employee
Dmitriy Benyuk
Posted on 30/11/2022 08:42:40
Reply
This post has been marked as an answer

Hi Jesper,
the problem is that you have your default currency DKK in both places: Currencies list/table and in the General Ledger LCY code field.
Usually I have not met this kind of situation, so by default the default/LCY currency is not even present in the Currencies table.
But if it is present then it must have correct values for the Exchgange Rates. Open your currencies table and find your DKK currency there and
set the Exchange rates for that. Or you can consider to remove the DKK from the currencies table as it is a default/LCY currency.

BR, Dmitrij

Votes for this answer: 1
 
Jesper Splidsboel
Posted on 30/11/2022 08:47:49
Reply

Sounds like the right way to fix the problem. I have not access to BC, but I will send this info to our partner and hope this will fix the problem. If not, I will go with my workaround.

 
Jesper Splidsboel
Posted on 30/11/2022 11:16:04
Reply

The currency DKK was deleted from currency-table and the problem is fixed.

 

You must be logged in to post in the forum