Keep an inventory in a currency different from the Company currency

Hello,
I have a case in which the main company has currency of Costa Rica Colón (¢), however, in one of the warehouses the inventory is purchased in US$, kept in a warehouse in US$ and sold in US$ (actually is a cero inventory warehouse as the product is software that is purchased online and activation keys downloaded immediately upon sale and delivered as soon as the keys are available or shortly there after), that means that the purchase price and specially the sale price ideally should be kept in US$ and Proposals and invoices are in US$ and only in very rare occasions in local currency, but the main company´s currency by law has to be the local currency.

Before I consider resorting to coding does anyone have a suggestion on how to establish especifically the sale price of a product in a currency different from the one in the main company without doing the back and forth conversions that are regularly performed by the multi-currency module?

  • It does not seem possible to establish a warehouse in a different currency from the main currency, I even tried to establish the warehouse location in the USA to see if that would allow US currency but no result
  • The product prices as far as I can see are always stored in local conversion by converting from foreign currency to local currency

Regards