Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0026542Openbravo ERP01. General setuppublic2014-05-13 17:072014-08-08 18:54
ngarcia 
AtulOpenbravo 
highminoralways
closedfixed 
5
 
3.0PR14Q4 
ngarcia
Core
No
0026542: Currency conversion can be deleted although it is used when posting a document
Currency conversion can be deleted although it is used when posting a document
As group admin role:
   Create a Sales Invoice in USD for F&B España Región Norte
   Complete and post it
   Try to edit the conversion rate from USD to EUR with
      Valid From Date <= Invoice Accounting Date
      Valid To Date >= Invoice Accounting Date
   You will get the following message:
      "Saving failed. Cannot modify used rate"
   Check that you could delete it instead
Configure the C_CONVERSION_RATE_TRG to be fired when deleting a record and add a condition not to enter the following condition if TG_OP = DELETE:

  IF(new.ValidTo IS NULL) THEN
    -- If there is no end date, set it to X
      new.ValidTo:=TO_DATE('31-12-9999', 'DD-MM-YYYY') ;
  END IF;
  --Check for invalid dates
  IF new.ValidTo < new.ValidFrom THEN
    RAISE EXCEPTION '%', '@20505@'; --OBTG:-20000--
  END IF;
No tags attached.
Issue History
2014-05-13 17:07ngarciaNew Issue
2014-05-13 17:07ngarciaAssigned To => jonalegriaesarte
2014-05-13 17:07ngarciaModules => Core
2014-05-13 17:07ngarciaTriggers an Emergency Pack => No
2014-05-13 17:08ngarciaIssue Monitored: networkb
2014-05-13 17:09ngarciaSummaryCurrency conversion could be deleted although it is used when posting a document => Currency conversion can be deleted although it is used when posting a document
2014-05-13 17:09ngarciaDescription Updatedbug_revision_view_page.php?rev_id=5818#r5818
2014-05-13 17:22ngarciaProposed Solution updated
2014-05-19 14:33jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-07-30 09:50AtulOpenbravoAssigned Topramakrishnan => AtulOpenbravo
2014-07-30 09:50AtulOpenbravoStatusnew => scheduled
2014-07-30 09:50AtulOpenbravofix_in_branch => pi
2014-07-30 10:12AtulOpenbravoReview Assigned To => ngarcia
2014-07-30 10:12AtulOpenbravofix_in_branchpi =>
2014-07-30 10:18hgbotCheckin
2014-07-30 10:18hgbotNote Added: 0068973
2014-07-30 10:18hgbotStatusscheduled => resolved
2014-07-30 10:18hgbotResolutionopen => fixed
2014-07-30 10:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/67abd792f3d32294b33f7bf5b416f86dfbdb24cb [^]
2014-07-30 12:02ngarciaStatusresolved => closed
2014-07-30 12:02ngarciaFixed in Version => 3.0PR14Q4
2014-08-08 18:54hudsonbotCheckin
2014-08-08 18:54hudsonbotNote Added: 0069241

Notes
(0068973)
hgbot   
2014-07-30 10:18   
Repository: erp/devel/pi
Changeset: 67abd792f3d32294b33f7bf5b416f86dfbdb24cb
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Jul 30 13:40:16 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/67abd792f3d32294b33f7bf5b416f86dfbdb24cb [^]

Fixes Issue 26542: Currency conversion can be deleted although it is used
when posting a document

---
M src-db/database/model/triggers/C_CONVERSION_RATE_TRG.xml
---
(0069241)
hudsonbot   
2014-08-08 18:54   
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/4450016dee64 [^]
Maturity status: Test