← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 856751] Re: Wrong currency recorded from Sales Journal to Expense Acct

 

Hi jlinkels,

sorry, but i feel like there is a little misunderstanding somewhere
because i'm able to get 5.12 as booking entries for cost of good sold.

I'd like to emphasize one what is probably causing the problem on your
side: the standard price and the list price of your products have to be
defined in the company currency (in USD, not in EUR).

So, what i've done to test:
*my company is usd, rate 1
*i set a rate of 0.77918 for the currency EUR (1 / 1.2834)
*i created a product TEST with list price 1.28 and cost price 1.93 (conversion of 1€ and 1.5€, only to suit your example)
*i created a SO with currency EUR and sold 4 of my procucts TEST at the unit price of 1.5€
*i validated the SO and confirmed its invoice: entries booked are as you depicted: $7.70 (6€) and $5.12 (4€) (rounding exceptions excluded)

My revision of addons is 5320. Can you test/tell me what i'm missing
here?

Thanks,
Quentin


** Changed in: openobject-addons
       Status: Fix Committed => Invalid

-- 
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):
  Invalid

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


References