Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0026542Openbravo ERP01. General setuppublic2014-05-13 17:072014-08-08 18:54
Reporterngarcia 
Assigned ToAtulOpenbravo 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR14Q4 
Merge Request Status
Review Assigned Tongarcia
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket28466
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0026542: Currency conversion can be deleted although it is used when posting a document
DescriptionCurrency conversion can be deleted although it is used when posting a document
Steps To ReproduceAs 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
Proposed SolutionConfigure 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;
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-05-13 17:07ngarciaNew Issue
2014-05-13 17:07ngarciaAssigned To => jonalegriaesarte
2014-05-13 17:07ngarciaModules => Core
2014-05-13 17:07ngarciaOBNetwork customer => Yes
2014-05-13 17:07ngarciaSupport ticket => 28466
2014-05-13 17:07ngarciaResolution time => 1406239200
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