Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0037117 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 03. Procurement management | minor | always | 2017-10-19 14:09 | 2018-11-22 16:58 | |||
Reporter | ngarcia | View Status | public | |||||
Assigned To | markmm82 | |||||||
Priority | high | Resolution | unable to reproduce | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0037117: Simplify error message when adding an invoice with exchange rate in Reversed Invoices tab of an invoice with exchange rate | |||||||
Description | Simplify error message when adding an invoice with exchange rate in Reversed Invoices tab of an invoice with exchange rate | |||||||
Steps To Reproduce | As group admin role: Change the currency of a purchase price list to USD Create a Purchase Invoice using that price list Add a line to it Add a conversion from USD to EUR in Exchange Rate tab Complete it Create a new Purchase Invoice with same price list but different conversion rate Create a third Purchase Invoice Add two lines with negative quantity in order to reverse the previously created invoices Add one of the invoices in Reversed Invoices tab, check the Exchange Rate of the original invoice has been copied Add the other invoice in Reversed Invoices tab and check the following error message is raised: Saving failed. It is not allowed to have multiple exchange rates defined for the same pair of currencies (Currency From -> Currency To). Where: SQL statement "INSERT INTO c_conversion_rate_document ( c_conversion_rate_document_id, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, C_CURRENCY_ID, C_CURRENCY_ID_TO, C_INVOICE_ID, FIN_PAYMENT_ID, APRM_FINACC_TRANSACTION_V_ID, RATE, FOREIGN_AMOUNT ) VALUES ( get_uuid(), Cur_Exchange_info.AD_Client_ID, Cur_Exchange_info.AD_Org_ID, Cur_Exchange_info.ISACTIVE, TO_DATE(NOW()), Cur_Exchange_info.CREATEDBY, TO_DATE(NOW()), Cur_Exchange_info.UPDATEDBY, Cur_Exchange_info.C_CURRENCY_ID, Cur_Exchange_info.C_CURRENCY_ID_TO, NEW.C_INVOICE_ID, Cur_Exchange_info.FIN_PAYMENT_ID, Cur_Exchange_info.APRM_FINACC_TRANSACTION_V_ID, Cur_Exchange_info.RATE, Cur_Exchange_info.FOREIGN_AMOUNT )" PL/pgSQL function c_invoice_reverse_trg() line 85 at SQL statement | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0100930) markmm82 (developer) 2017-12-05 15:55 |
Test Plan: As group admin role: Change the currency of a purchase price list to USD Create a Purchase Invoice using that price list Add a line to it Add a conversion from USD to EUR in Exchange Rate tab Complete it Create a new Purchase Invoice with same price list but different conversion rate Create a third Purchase Invoice Add two lines with negative quantity in order to reverse the previously created invoices Add one of the invoices in Reversed Invoices tab, check the Exchange Rate of the original invoice has been copied Add the other invoice in Reversed Invoices tab and check the following error message is raised: Saving failed. It is not allowed to have multiple exchange rates defined for the same pair of currencies (Currency From -> Currency To). Notice it is simplified and details are not present. |
(0108059) dmiguelez (developer) 2018-11-22 16:58 |
This issue is no longer reproducible |
Issue History | |||
Date Modified | Username | Field | Change |
2017-10-19 14:09 | ngarcia | New Issue | |
2017-10-19 14:09 | ngarcia | Assigned To | => Triage Finance |
2017-10-19 14:09 | ngarcia | Modules | => Core |
2017-10-19 14:09 | ngarcia | Triggers an Emergency Pack | => No |
2017-10-19 14:11 | ngarcia | Issue Monitored: networkb | |
2017-12-04 16:31 | markmm82 | Assigned To | Triage Finance => markmm82 |
2017-12-04 16:32 | markmm82 | Status | new => scheduled |
2017-12-05 15:55 | markmm82 | Note Added: 0100930 | |
2018-11-22 16:58 | dmiguelez | Note Added: 0108059 | |
2018-11-22 16:58 | dmiguelez | Status | scheduled => closed |
2018-11-22 16:58 | dmiguelez | Resolution | open => unable to reproduce |
Copyright © 2000 - 2009 MantisBT Group |