c2c-oerpscenario team mailing list archive

[jlinkels <856751@xxxxxxxxxxxxxxxxxx>]

The company currency is USD.

The price types are EUR
The Sales price list is EUR
The Purchase price list is EUR

I don't have more price lists. Purchases are done using the Purchase
price list in EUR. The sales are done using the Sales price list in EUR

I expect that all account entries are converted to USD. This is what you say as well.
However Expense acct and Stock Output acct entries are in the EUR amount.

Have a look at the screenshot as attached. 
The Purchase price of the product is EUR 1.00
The Sales price is EUR 1.50
The exchange rate EUR/USD = 1.283

When  I sell 4 products, the Sales price is 7.70
This is correct: 4 x 1.50 x echange rate = 4 x 1.50 x 1.283 = 7.70

However, the Stock Output account is debited for 4.00
This is 4 x 1.00. This is incorrect, the booking should be 4 x 1.00 x 1.283 = 5.13

When I purchase 10 products, the journal entries show correctly the cost of 12.83
This is 10 x 1.00 x exchange rate.
Unfortunately the entry for Stock Input accout IN/00001 is incorrect, only 1 product is calculated.
But that is due to a known bug. (#740964)
It shows clearly that the purchase price is 1.28, not 1.00. That is correct.

This indicates that the price lists are correct.

Please see the attachments. 
Inkoop = Purchase

jlinkels

jlinkels

** Attachment added: "screenshots.zip"
   https://bugs.launchpad.net/openobject-addons/+bug/856751/+attachment/2447033/+files/screenshots.zip

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/856751

Title:
  Wrong currency recorded from Sales Journal to Expense Acct

Status in OpenERP Addons (modules):
  Incomplete

Bug description:
  This is OpenERP server version 6.0. It was installed from the Debian
  Package 6.0. Client version is 6.0.3. Platform Debian Stable.

  I have a company which is in USD. I use the Anglo-Saxon stock
  accouting.

  All price lists and price types are in EUR. In the pricing nowhere USD
  appears anywhere.

  All product pricing is consequently in EUROs.

  When I sell products, the invoice is in EUROs, but income is recorded
  in USD. This is correct. It means I sell goods for 10.00 EUR, and the
  Income Acct is credited for 12.83 EUR.

  However, both the Expense Acct and Stock Output Acct are debited and
  credited in EUROs. This is definitely wrong. It means that the cost of
  good is EUR 5.00 and the Expense Acct is debited for 5.00. But the
  Expense Acct is defined in USD. The Expense and Stock Output Acct
  should have been booked in USD as well.

  I don't know what combinations of price lists and company currency
  will induce this error, but I am sure that it results in some almost
  impossible to track down discrepancies in accounting whenever
  different currencies are involved.

  jlinkels

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/856751/+subscriptions