Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037117Openbravo ERP03. Procurement managementpublic2017-10-19 14:092018-11-22 16:58
Reporterngarcia 
Assigned Tomarkmm82 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037117: Simplify error message when adding an invoice with exchange rate in Reversed Invoices tab of an invoice with exchange rate
DescriptionSimplify error message when adding an invoice with exchange rate in Reversed Invoices tab of an invoice with exchange rate
Steps To ReproduceAs 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-10-19 14:09ngarciaNew Issue
2017-10-19 14:09ngarciaAssigned To => Triage Finance
2017-10-19 14:09ngarciaModules => Core
2017-10-19 14:09ngarciaTriggers an Emergency Pack => No
2017-10-19 14:11ngarciaIssue Monitored: networkb
2017-12-04 16:31markmm82Assigned ToTriage Finance => markmm82
2017-12-04 16:32markmm82Statusnew => scheduled
2017-12-05 15:55markmm82Note Added: 0100930
2018-11-22 16:58dmiguelezNote Added: 0108059
2018-11-22 16:58dmiguelezStatusscheduled => closed
2018-11-22 16:58dmiguelezResolutionopen => unable to reproduce

Notes
(0100930)
markmm82   
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   
2018-11-22 16:58   
This issue is no longer reproducible