I am trying to create a chart using XL connect that would show our quotes and orders each week in Canadian values.
I brought in the quote - summary by date opened table; but realized that the values are in Doc currency.
Is there a way for me to grab their exchange rate or grab CAD value from XL connect for these quotes?
I have the same question, did you ever get a resolution to this issue?
Unfortunately no, i not through XL connect.
We made the excel we use XL connect also grab data from Web API. So we have to refresh XL connect and refresh data from API to get correct values at the moment.
Hope this helps,
OK, that’s what we are currently doing too, thanks for the response!