How to Update exchage rate automatically in SAP Business by design

[pvsbprasad]

     Hi,

I want to update exchange rates automatically,is there any possibility by using WSDL file.

if yes,please provide me the suggestion ...

Regards,

Prasad

[Former Member]

Prasad,

There IS a ManageExchangeRateIn Web Service that can be used for this purpose. The WSDL can be found in the Service Explorer.

You'll also need a source of data that can automatically provide exchange rate data.

Provided you have one, you need a way of either pushing data to ByDesign automatically through an external application, or alternately, you can build the integration as a ByDesign customization (though in this case it's a bit strange as it ends up sending web service requests to itself...)

[pvsbprasad]

Hi Dan,

Thank you for the reply...!

I had already seen the ManageExchangeRatein web service ..Can u please guide me how to call the external web service with external exchange rate service(ex:internet URL),and how to update specifc exchange rate.

Regards,

Prasad

[Former Member]

Hi Prasad,

Did you find a solution to the above?  If yes, can you please share here as I am looking to implement exactly the same solution?

If anybody else has found any solution, please update here.

Thanks,

Krishna

[Former Member]

Hi all,

We have written a small webservice (hosted on Google Compute engine), that pulls exchange rates from one of the available web sources, transforms the data into the appropriate format, and loads it into ByD using the ManageExchangeRateIn Web Service.

We have this running daily - works like a charm. This was fairly trivial to build for one of our developers.

Right now, it only does the "mid" rate (sufficient for our purposes), but enabling bid/mid/ask would not be complicated.

We also calculate the exchange rates between various currencies based on the exchange rate to/from the US$ (or the Euro, I forget which right now), which allows us to use free sources of exchange rates. If you need the exact rates, you may require a paid-for source of exchange rate data.

If interested, contact me directly.

Regards,

Eelco

[pvsbprasad]

Hi,

I did not find any solution.

Regards,

Prasad

[Former Member]

Hi Eelco,

Thanks for your reply, we are already having the paid-for source of exchange rate data and would be very interested in your solution.  Do you sell this solution or please advise what is involved in installing this solution in our ByD?

Thanks,

Krishna Manjunath

[Former Member]

Hi Deepthi,

Can you drop me an email at eelco_at_itpreneurs_dot_com?

(Replace "_at_" and "_dot_" appropriately).

Best regards,

Eelco

[Jacques-Antoine]

Hello Dan,

I want to call ByD itself for the Exchange Rates, but I am not able to do it.

I set up an external web service integration that uses the WSDL of the Standard Inbound web service and I set an Arrangement with both services (the Standard Inbound and the Custom Outbound).

However, If I am able to test it through SOAP UI, I am not able to test it with the SDK, I always get the error AP-RC-BDS-WS.

If you have any clue on this it would be very appreciated.

Thank you for your attention.

Best regards.

Jacques-Antoine Ollier

[Former Member]

Jacques-Antoine,

Make sure you're using the correct authentication (e.g. if it's username/password then it's the same username/password for both inbound and outbound)

Also make sure your endpoint is correct in the outbound arrangement.

Make sure you've included all the correct data elements in your ABSL code to generate the request.

Lastly, check the web service communication monitor to see if it's even receiving the request (if so, they will show up in the log, and provide at least some level of detail as to what the error is)

-Dan

[Jacques-Antoine]

Hello Dan,

Thank you for your asnwer.

I really don't know why, but actually it was working in my ABSL when I fixed how i sent the Exchange Rate data.

However, I still get the error when I try to test it through Right Click -­­> Test service operation.

Else, do you have any advice on how to push such a solution in Production (calling a standard web service through an external integration in the SDK) as it is my first.

Do I need to do specific things or recreating the Communicatoin Arragement as it was, is the only thing to do?

Thank you for your attetnion.

Best regards.

Jacques-Antoine Ollier

[former_member186648]

Hi Jacques-Antoine Ollier,

Right click -> Test service has some limitation , so you could directly use it in ABSL and if it works here , then it should be fine.

Thanks, Pradeep.

[Former Member]

Jacques,

Sorry for the long delay, this had slipped off my radar. In case you haven't tried it, yes, that's really the only thing you need to do - re-create the Communication Arrangement and it should work. If you didn't do so yet in the SDK, it's easiest to include both the standard Inbound and custom Outbound services within the same custom communication arrangement (which makes it one less to manage).

-Dan

[Former Member]

Same issue here, the only solution I found is using an addOn.

Exchange Rates - The Basic - YouTube

[pvsbprasad]

Hi Rosa,

the viedo is about updating exchange rates in SAP Business one.

i need to update in SAP Business by Design

Regards,

Prasad