Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 07. Sales managementmajoralways2011-02-24 16:142011-03-23 00:00
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityurgentResolutionfixedFixed in Version3.0RC5
StatusclosedFix in branchpiFixed in SCM revisione9b0a01aa669
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0016045: It is not possible to void an invoice with conversion rate

DescriptionIt is not possible to void an invoice with conversion rate. You obtain error DATA_EXCEPTION (which also need to be fixed to show proper error). Problem is when filtering dates to find conversion rate
Steps To Reproduce1. General Setup || Application || Conversion Rates || Conversion Rate: define conversion rates from EUR to MXN and from MXN to EUR, from date 27/01/2011 to date 27/01/2011 and any rate.
2. Master Data Management || Pricing || Price List || Price List : create sales price list for MXN. Valid from 01/01/2011 and add price for Shirts
3. Sales Management || Transactions || Sales Invoice || Header : create record for Main organization, business partner mcgiver, pricelist MXN
4. Sales Management || Transactions || Sales Invoice || Header >> Lines : add line for one Shirt
5. Come back to header and complete
6. Try to Void the invoice and you will obtain

Problem is located in function C_Currency_Rate, when creating CUR_Rate. Problem is that ValidFrom and ValidTo have value '2011-01-27 00:00:00' but v_ConvDate is '2011-01-27 10:15:23'. Only should filter bu date and no by hour and minute
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks backport 00157872.50MP27 closedadrianromero It is not possible to void an invoice with conversion rate 

-  Notes
hgbot (developer)
2011-03-02 11:43

Repository: erp/devel/pi
Changeset: e9b0a01aa6690f34f761c073ada9309e9a6bc167
Author: Adrián Romero <adrianromero <at>>
Date: Wed Mar 02 11:40:14 2011 +0100
URL: [^]

Fixes issue 0016045: It is not possible to void an invoice with conversion rate
It has been applied the function TRUNC to remove the hours and minutes to the conversion date and also it has been removed the raise exception instruction that hid the error conversion message

M src-db/database/model/functions/C_CURRENCY_RATE.xml
M src-db/database/model/functions/C_INVOICE_POST.xml
adrianromero (manager)
2011-03-02 11:51
edited on: 2011-03-02 11:51

* Testing the issue

Follow the steps to test and verify that now the invoice can be voided because it takes properly the void date without the hours, minutes and seconds.

Verify also that if does not really exist a valid change rate in the date when the invoice is voided it does not appear the error DATA_EXCEPTION but also the message explaining that there not exists a conversion hour for the specified date.

* Other areas affected

All areas that performs currency changes may be affected because now the date used is used without hours, minutes and seconds.

It also may affect other errors when processing an invoice that instead of displaying an DATA_EXCEPTION error, will display the cause error.

maite (developer)
2011-03-22 11:05

DATA_EXCEPTION message is note received any more. If you have not conversion rate defined for today's date (as you should because new invoice is going to be created) proper message is raised. If you define requested rate invoice is voided properly.

- Issue History
Date Modified Username Field Change
2011-02-24 16:14 adrianromero New Issue
2011-02-24 16:14 adrianromero Assigned To => adrianromero
2011-02-24 16:14 adrianromero Modules => Core
2011-02-24 16:14 adrianromero Issue generated from 0015787
2011-02-24 16:14 adrianromero Relationship added blocks 0015787
2011-02-24 16:15 adrianromero Status new => scheduled
2011-02-24 16:15 adrianromero fix_in_branch => pi
2011-03-02 11:43 hgbot Checkin
2011-03-02 11:43 hgbot Note Added: 0034488
2011-03-02 11:43 hgbot Status scheduled => resolved
2011-03-02 11:43 hgbot Resolution open => fixed
2011-03-02 11:43 hgbot Fixed in SCM revision => [^]
2011-03-02 11:51 adrianromero Note Added: 0034495
2011-03-02 11:51 adrianromero Note Edited: 0034495 View Revisions
2011-03-22 11:05 maite Note Added: 0035131
2011-03-22 11:05 maite Status resolved => closed
2011-03-22 11:05 maite Fixed in Version => 3.0RC5
2011-03-23 00:00 anonymous sf_bug_id 0 => 3235751

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker