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