I have products, that my business purchases from different suppliers using different currencies.
For example, the business purchases a cream, measured in liters, from different suppliers at different prices:
- Supplier 1: 10 USD per liter.
- Supplier 2: 8 EUR per liter.
- Supplier 3: 3500 AMD per liter.
So, to calculate the average cost of the product we should have these prices saved in the product properties. The main currency of the accounting is AMD.
Odoo allows adding new custom fields to the products with the Monetary type. But in the field settings, I can't choose another currency, only the "Cost currency" and "Currency" options are available in the "Currency" field dropdown.
So, the question is: how to configure the custom Monetary field to store price in a currency, different from the main currency? And how to calculate the cost of products, using the chosen custom field?