c2c-oerpscenario team mailing list archive
-
c2c-oerpscenario team
-
Mailing list archive
-
Message #34247
[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