Community mailing list archives

community@mail.odoo.com

Trying to understand Exchange Rates with Stock Valuations and Price Variance with 9.0 Enterprise

by
Ty Muscat
- 07/29/2016 09:46:55
Hi,

I hope you can help me understand how Odoo handles Exchange Rates with 
Stock Valuations and Price Variance.  The journal entries that are being 
created are unexpected.  Hopefully someone more familiar with Odoo can 
let me know if I have a configuration issue or if this is a bug.

Steps to recreate issue:

1. Start with a clean database loaded with demo data and the following
modules: accounting, inventory, sales, purchasing. Default 
Database/Company Currency set to CAD.

2. Create a Product Category with the following attributes:

Account Properties

Price Difference Account 1234567 price variance
Income Account 411000 Inside Sales
Expense Account 511100 Inside Purchases

Account Stock Properties
Stock Input Account 217100 Stock Received But Not Billed
Stock Output Account 114500 Stock Delivered But Not Billed
Stock Valuation Account 114100 Stock In Hand
Stock Journal Stock Journal (CAD)

Inventory Valuation
Costing Method Standard Price
Inventory Valuation Perpetual (automated)

3. Create a product. Cost Price 1.00 Sales Price 2.00 Set internal
category to category created above.

4. Setup vendor as a USD vendor.

5. Create a Purchase order for qty 1 of the about product at price 1.00.

6. Save, confirm, receive product, register payment for product all in USD.


Journal Entries that are create are below:

STJ/2016/0008

Journal Stock Journal (CAD)

Partner ASUSTeK

Date 07/29/2016

Reference WH/IN/00014


JOURNAL ITEMS

Partner Account Label Amount currency Currency Debit Credit

ASUSTeK 217100 Stock Received But Not Billed Test 0.00 0.00 $ 1.00 $

ASUSTeK 114100 Stock In Hand Test 0.00 1.00 $ 0.00 $

1.00 1.00


Based on my understanding I expected the journal entries to be created 
as follows:

JOURNAL ITEMS

Partner Account Label Amount currency Currency Debit Credit

ASUSTeK 217100 Stock Received But Not Billed Test 1.00 USD 0.00 $ 1.32 $

ASUSTeK 114100 Stock In Hand Test 1.00 USD 1.32 $ 0.00 $

1.32 1.32


The next Journal Entries have some additional issues with Price Variance
Account:

BILL/2016/0010

Journal Vendor Bills (CAD)

Partner ASUSTeK Date 07/29/2016 Reference


JOURNAL ITEMS

Partner Account Label Amount currency Currency Debit Credit

ASUSTeK 211100 Vendors Account / $ -1.00 USD 0.00 $ 1.32 $

ASUSTeK 1234567 price variance Test $ 0.24 USD 0.32 $ 0.00 $

ASUSTeK 217100 Stock Received But Not Billed Test $ 0.76 USD 1.00 $ 0.00 $

1.32 1.32

Is it correct to assume that Price Variance should not be needed if the 
Stock in Hand and Stock Received But Not billed entires were created at 
1.32 CAD instead of 1.00
CAD?

Thank you,

Ty Muscat