I have a multiple store setup of and each store has a different currency.
How can I bring their sales data into one report and normalize the currency to USD.
Is there a table that has all the currency conversions and update constantly that I can bring in?
It kind of depends if you have multiple currencies or multiple base currencies. In any case, such reporting is best handled by systems outside of Magento. You can use APIs or export your data into your preferred business inteligence system.
Hey! So I'm using Adobe BI already, does it have this functionality built in somewhere?