Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021800Openbravo ERP07. Sales managementpublic2012-10-01 08:012012-10-22 13:27
Reporterthirumalaik 
Assigned Topramakrishnan 
PrioritynormalSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021800: Not convertible(no rate) error during posting eventhough conversion rate available in exchange rate tab
DescriptionI'm trying to create a new Purchase invoice in INR.I faced Error,
Document currency cannot be converted to the Accounting Schema currency during posting and button showing "Not convertible(no rate) error during posting".
I reactivated my Invoice and added conversion rate in "Exchange rates" tab.
After that,I completed my record and trying for post.Still I'm facing the same error.

I created a conversion rate for (INR ->USD) in General Setup --> Conversion rates and tried posting.It's working fine.

It seems like,posting process is looking for the coversion rate setup at global/system level even though it's not applicable here.

As per conversion rate document,the system need to approach like following,

When processing/accounting a document, the system will look:

    * first for the applicable exchange rate entered at document level and
    * then, and just in case there is no exchange rate at document level, it will look for the coversion rate setup at global/system level in the application path:
    "General Setup // Application // Conversion Rates "
    * The system must warn the user in case there is no exchange rate setup at all.

http://wiki.openbravo.com/wiki/Exchange_Rate_at_Document_Level [^]

The error is completely reproducible in Purchase Invoice and please confirm the same in other posting windows.

 
Steps To Reproduce1.Create a new purchase pricelist with currency INR in Organization - "F&B US Inc".
(make sure,no conversion rate available for INR - USD in General Setup --> Conversion rates.If so,delete it).

2.Create a new purchase Invoice in Organization - "F&B US Inc" and select INR Pricelist.add lines and appropriate amount.

3.Add INR - USD conversion rate in Exchange rates tab.

4.Complete the record and try posting.you may face error, Error,
Document currency cannot be converted to the Accounting Schema currency during posting and button may show "Not convertible(no rate)"

5.Create a conversion rate for (INR ->USD) in General Setup --> Conversion rates and try posting again.Ii will work without any error.

The error in step [4] is wrong because,"The system must warn the user in case there is no exchange rate setup at all."
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-01 08:01thirumalaikNew Issue
2012-10-01 08:01thirumalaikAssigned To => dmiguelez
2012-10-01 08:01thirumalaikModules => Core
2012-10-05 10:01pramakrishnanAssigned Todmiguelez => pramakrishnan
2012-10-05 10:01pramakrishnanStatusnew => scheduled
2012-10-05 10:01pramakrishnanfix_in_branch => pi
2012-10-17 09:23dmiguelezNote Added: 0053406
2012-10-17 10:02hgbotCheckin
2012-10-17 10:02hgbotNote Added: 0053407
2012-10-17 10:02hgbotStatusscheduled => resolved
2012-10-17 10:02hgbotResolutionopen => fixed
2012-10-17 10:02hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/88e59255b367b4962200cb6425f7cd1fb963f271 [^]
2012-10-17 10:29dmiguelezReview Assigned To => dmiguelez
2012-10-17 10:29dmiguelezNote Added: 0053411
2012-10-17 10:29dmiguelezStatusresolved => closed
2012-10-22 13:27hudsonbotCheckin
2012-10-22 13:27hudsonbotNote Added: 0053508

Notes
(0053406)
dmiguelez   
2012-10-17 09:23   
Test Plan 1:
Login as Openbravo/openbravo
Create a new Price List
"Organization":F&B US, Inc.
"Name":Test PriceList
"Currency":INR

Create Price List Version
"Name":Test Price List
"Valid From Date":05-10-2012
"Price List Schema":Price List Schema

Create Product Price
"Product":Cherry Cola
"Unit Price":2.00
"List Price":2.00

"Product":Cola
"Unit Price":1.00
"List Price":1.00

Create a new Purchase Invoice
"Organization":F&B US, Inc.
"Price List":Test Price List

Create Lines
"Product":Cherry Cola
"Invoiced Quantity":5

"Product":Cola
"Invoiced Quantity":10

Create Exchange Rates
"Organization":F&B US, Inc.
"Currency":INR
"To Currency":USD
"Rate":0.0193

Complete the invoice
Post the invoice
Notice that the invoice is posted using the conversion rate available in the exchange tab

Test Plan 2:
Login as Openbravo/openbravo
Create a new Price List
"Organization":F&B US, Inc.
"Name":Test PriceList
"Currency":INR

Create Price List Version
"Name":Test Price List
"Valid From Date":05-10-2012
"Price List Schema":Price List Schema

Create Product Price
"Product":Cherry Cola
"Unit Price":2.00
"List Price":2.00

"Product":Cola
"Unit Price":1.00
"List Price":1.00

Create a new Purchase Invoice
"Organization":F&B US, Inc.
"Price List":Test Price List

Create Lines
"Product":Cherry Cola
"Invoiced Quantity":5

"Product":Cola
"Invoiced Quantity":10

Create Exchange Rates
"Organization":F&B US, Inc.
"Currency":INR
"To Currency":USD
"Rate":0.0193

Create a new conversion rate
"Organization":F&B US, Inc.
"Currency":INR
"To Currency":USD
"Valid From Date":01-10-2012
"Multiple Rate By":0.0193

Complete the invoice and Post it
Notice that the invoice is posted using the conversion rate available in the exchange tab

Test Plan 3:
Login as Openbravo/openbravo
Create a new Price List
"Organization":F&B US, Inc.
"Name":Test PriceList
"Currency":INR

Create Price List Version
"Name":Test Price List
"Valid From Date":05-10-2012
"Price List Schema":Price List Schema

Create Product Price
"Product":Cherry Cola
"Unit Price":2.00
"List Price":2.00

"Product":Cola
"Unit Price":1.00
"List Price":1.00

Create a new Purchase Invoice
"Organization":F&B US, Inc.
"Price List":Test Price List

Create Lines
"Product":Cherry Cola
"Invoiced Quantity":5

"Product":Cola
"Invoiced Quantity":10

Create a new conversion rate
"Organization":F&B US, Inc.
"Currency":INR
"To Currency":USD
"Valid From Date":01-10-2012
"Multiple Rate By":0.0193

Complete the invoice and Post it
Notice that the invoice is posted using the conversion rate available in the conversion rate tab

Test Plan 3:
Login as Openbravo/openbravo
Create a new Price List
"Organization":F&B US, Inc.
"Name":Test PriceList
"Currency":INR

Create Price List Version
"Name":Test Price List
"Valid From Date":05-10-2012
"Price List Schema":Price List Schema

Create Product Price
"Product":Cherry Cola
"Unit Price":2.00
"List Price":2.00

"Product":Cola
"Unit Price":1.00
"List Price":1.00

Create a new Purchase Invoice
"Organization":F&B US, Inc.
"Price List":Test Price List

Create Lines
"Product":Cherry Cola
"Invoiced Quantity":5

"Product":Cola
"Invoiced Quantity":10

Complete the invoice and Post it
Notice that the invoice is not posted and shows the error "Document currency cannot be converted to the Accounting Schema currency" since there is no conversion rate available for both in exchange rate tab and conversion rate tab

Test Plan 4:
Login as Openbravo/openbravo
Create a Payment Out
"Organization": F&B España, S.A
"Currency":EUR
Click on Add Details
Select the invoice 10000243

create exchange rate
"currency:"EUR
"To Currency:"USD
"Rate":10

Post the Payment
Notice that the payment is posted using the exchange rate in the exchange rate tab


Test Plan 5:
Login as Openbravo/openbravo

Create a Payment Out
"Organization": F&B España, S.A
"Currency":EUR
Click on Add Details
Select the invoice 10000243

post the payment

go to financial transaction and select the payment out transaction that is just posted

create exchange rate
"currency:"EUR
"To Currency:"USD
"Rate":20

Post the transaction
Notice that the transaction is posted using the exchange rate defined in the exchange rate tab
(0053407)
hgbot   
2012-10-17 10:02   
Repository: erp/devel/pi
Changeset: 88e59255b367b4962200cb6425f7cd1fb963f271
Author: Pandeeswari Ramakrishnan <pandeeswari.ramakrishnan <at> openbravo.com>
Date: Mon Oct 15 16:47:29 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/88e59255b367b4962200cb6425f7cd1fb963f271 [^]

Fixes Issue 21800 : Not convertible(no rate) error during posting

---
M src/org/openbravo/erpCommon/ad_forms/AcctServer.java
---
(0053411)
dmiguelez   
2012-10-17 10:29   
Code Review + Testing OK
(0053508)
hudsonbot   
2012-10-22 13:27   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/483f2e6dc1af [^]

Maturity status: Test