Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0011183
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupcriticalalways2009-10-30 03:592009-10-31 00:00
ReportervanphucView Statuspublic 
Assigned Torafaroda 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50MP7SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011183: 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
TagsNo tags attached.
Attached Filesdoc file icon Error with Currency Conversion Set Up.doc [^] (553,472 bytes) 2009-10-30 03:59

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of feature request 0011028 closedrafaroda Currency Exchange Rate 
duplicate of defect 00105742.40MP10 closedharikrishnan The converion rate table has to save the rates with more decimals 

-  Notes
(0021480)
rafaroda (developer)
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.

- Issue History
Date Modified Username Field Change
2009-10-30 03:59 vanphuc New Issue
2009-10-30 03:59 vanphuc Assigned To => rafaroda
2009-10-30 03:59 vanphuc File Added: Error with Currency Conversion Set Up.doc
2009-10-30 06:01 rafaroda Relationship added duplicate of 0011028
2009-10-30 06:01 rafaroda Status new => closed
2009-10-30 06:01 rafaroda Note Added: 0021480
2009-10-30 06:01 rafaroda Duplicate ID 0 => 11028
2009-10-30 06:01 rafaroda Resolution open => duplicate
2009-10-30 06:01 rafaroda Relationship added duplicate of 0010574
2009-10-31 00:00 anonymous sf_bug_id 0 => 2889762

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker