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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0021800
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementtrivialalways2012-10-01 08:012012-10-22 13:27
ReporterthirumalaikView Statuspublic 
Assigned Topramakrishnan 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision88e59255b367
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021800: 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."
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0053406)
dmiguelez (viewer)
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 (developer)
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 (viewer)
2012-10-17 10:29

 Code Review + Testing OK
(0053508)
hudsonbot (viewer)
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

- Issue History
Date Modified Username Field Change
2012-10-01 08:01 thirumalaik New Issue
2012-10-01 08:01 thirumalaik Assigned To => dmiguelez
2012-10-01 08:01 thirumalaik Modules => Core
2012-10-01 08:01 thirumalaik OBNetwork customer => No
2012-10-05 10:01 pramakrishnan Assigned To dmiguelez => pramakrishnan
2012-10-05 10:01 pramakrishnan Status new => scheduled
2012-10-05 10:01 pramakrishnan fix_in_branch => pi
2012-10-17 09:23 dmiguelez Note Added: 0053406
2012-10-17 10:02 hgbot Checkin
2012-10-17 10:02 hgbot Note Added: 0053407
2012-10-17 10:02 hgbot Status scheduled => resolved
2012-10-17 10:02 hgbot Resolution open => fixed
2012-10-17 10:02 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/88e59255b367b4962200cb6425f7cd1fb963f271 [^]
2012-10-17 10:29 dmiguelez Review Assigned To => dmiguelez
2012-10-17 10:29 dmiguelez Note Added: 0053411
2012-10-17 10:29 dmiguelez Status resolved => closed
2012-10-22 13:27 hudsonbot Checkin
2012-10-22 13:27 hudsonbot Note Added: 0053508

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker