Having read through many of the online resources and guides, it's obvious that BC can handle currencies and exchange rates in a fairly straightforward manner. The issue we are running into is that our business model is such that the currency of a sales invoice is dependent upon the ITEM being sold, regardless of the location of the customer or our company.
For example, we may send an invoice to a customer in the US (who would normally be set up for USD) in GBP., or a customer in the Netherlands may receive an invoice in USD. I've been able to set things up on the vendor side no problem, but what happens when I try to process a sales invoice is that the item price (that should be in say Euros) defaults to local currency (CDN) and the exchange rate goes in reverse.
What should happen: $2,995 EURO price (x1.6957 exchange rate) = $5,078.62 CDN
What is happening: $2,995 CDN price (same exchange rate) = 1,766.23 EURO
The piece I'm missing is how to make that item price in EURO. What's happening is that every item price is set to local currency and then the exchange rate is making it a lower amount of a different currency when the reverse should be happening.
The other alternative I have considered is that I have set the currency exchange rates up incorrectly, however they work just fine when we purchase from vendors so I'm not sure.
Hopefully I've explained this clearly.
Thanks and have a great day!
