Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011183Openbravo ERP01. General setuppublic2009-10-30 03:592009-10-31 00:00
Reportervanphuc 
Assigned Torafaroda 
PrioritynormalSeveritycriticalReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS20OS VersionrPath Linux
Product Version2.50MP7 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011183: Currency Exchange Rate
DescriptionI just download Openbravo version 2.5MP7 to test currency exchange rate. The exchange rate like this 1 EUR= 27090 VNĐ. In the currency conversion, i already set up from EUR to VNĐ, multiple 27090 and system calculate divide is 0 automatically. Next step, create one price list product for VNĐ. Then, i created one purchase invoice with product is CO2, quatity 10, unit price is 3500000 VNĐ, i got the grand amount is 37450000, included VAT 7%. Next, i post transaction, system booked entries : Debit 6720 and credit 6000, with amount is blank.
Please find here my attached files with some screened.
It is so import to me, because i live in Viet Nam, so, VNĐ is the local currency transactions with other countries from over the world, like USD or EUR.

Thanks in advance
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of feature request 0011028 closed rafaroda Currency Exchange Rate 
duplicate of defect 00105742.40MP10 closed harikrishnan The converion rate table has to save the rates with more decimals 
Attached Filesdoc Error with Currency Conversion Set Up.doc (553,472) 2009-10-30 03:59
https://issues.openbravo.com/file_download.php?file_id=1898&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-10-30 03:59vanphucNew Issue
2009-10-30 03:59vanphucAssigned To => rafaroda
2009-10-30 03:59vanphucFile Added: Error with Currency Conversion Set Up.doc
2009-10-30 06:01rafarodaRelationship addedduplicate of 0011028
2009-10-30 06:01rafarodaStatusnew => closed
2009-10-30 06:01rafarodaNote Added: 0021480
2009-10-30 06:01rafarodaDuplicate ID0 => 11028
2009-10-30 06:01rafarodaResolutionopen => duplicate
2009-10-30 06:01rafarodaRelationship addedduplicate of 0010574
2009-10-31 00:00anonymoussf_bug_id0 => 2889762

Notes
(0021480)
rafaroda   
2009-10-30 06:01   
Hi,

Your problem comes from "In the currency conversion, i already set up from EUR to VNĐ, multiple 27090 and system calculate divide is 0 automatically".

This issue has just been resolved in issue 0010574. These are the steps to resolve it by yourself:
1) Login as Openbravo (password: openbravo) and select System Administrator role.
2) Go to Application Dictionary || Windows, Tabs, and Fields || Window and select "Conversion Rates" record.
3) Move to Tab "Conversion Rate".
4) Move to field "Multiple Rate by".
5) Navigate to Column "MultiplyRate" by clicking on the link.
6) Change Reference drop-down to value "GeneralQuantity".
7) Go back to Application Dictionary || Windows, Tabs, and Fields || Window >> Tab >> Field
8) Select field "Divide Rate by".
9) Navigate to Column "DivideRate" by clicking on the link.
10) Change Reference drop-down to value "GeneralQuantity".
11) Compile "Conversion Rates" window: ant compile.development -Dtab="Conversion Rate"
11) Restart Tomcat and go login as Openbravo with Openbravo Admin role.
12) Go to General Setup || Application || Conversion Rates || Conversion Rate
13) Type again multiply 27090 in the conversion record from EUR to VNĐ.

Now divide field should not be 0 but 0.000037.

After this, the following steps should work properly.

Regards.