Current behavior
When created a Purchase Order in foreign currency (USD). If the currency rate is different between the creation date of PO and receipt date (Validate Receipt) then
- The product cost is calculated based on the currency rate of creation date of PO
- The Stock Journal Entry, posted when validate receipt, is calculated based on the receipt date
Configuration
+ Enable multi currency
+ Configure Average costing method and Automated Inventory Valuation
- Inventory > Configuration > Product Categories
- Select a category (Raw Material)
+ Set currency rate for USD at a specific date. Example: 08/05/2019 with rate is 0.68
+ Set currency rate for USD for today. Example: 0.5
+ Raise a Purchase Order with a product
belongs to above category (Raw Material) at a 08/05/2019
+ Receive product
+ Watch the product and journal entry in accounting. The cost of product based on the rate at 8/5/2019: 0.68. The journal entry based on the rate today: 0.5
Expected result
Both product and journal entry in accounting should pick up the currency conversion as on received date.
Is there a configuration in ODOO to achieve this?