Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015504Openbravo ERPZ. Otherspublic2010-12-21 16:142011-05-24 10:55
Reportermaite 
Assigned Toeduardo_Argal 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015504: Implement procedure to rollback reconciliations
DescriptionActually you can not rollback reconciliations so user is not able to delete a transaction which has been reconciled.
User should be able to rollback this reconciliation and, as a consequence, will be able to delete the transaction.
Steps To Reproduce0. Configure APR: creating Financial Account, Payment method and so on...
1. Financial Management || Receivables & Payables || Transactions || Payment In || Header : create record for any BP and press "Add payment" button
2. Choose Transaction Type=GLItem and set any GLItem and any amount. Add and process
3. Financial Management || Receivables & Payables || Transactions || Financial Account || Account >> Transactions : press "Add transaction" ans choose created GL item.
4. Financial Management || Receivables & Payables || Transactions || Financial Account || Account >> Transactions : choose added transaction and press "Reconcile" button. Process
5. Once it is reconciled select it in Transactions grid and try to "Delete" it.

You will obtain this error:
Error
APRM_ReconciledDocument: Currency(102) (iSOCode: EUR) - Bank - 21-12-2010 - 1000 - 0.00 - 400016 - 0
Proposed Solution
Additional Information
TagsclosingMay2011
Relationships
depends on backport 0016020 closed eduardo_Argal Implement procedure to rollback reconciliations 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-12-21 16:14maiteNew Issue
2010-12-21 16:14maiteAssigned To => adrianromero
2010-12-21 16:14maiteModules => Advanced Payables and Receivables Mngmt
2010-12-21 16:15maitePriorityurgent => high
2010-12-21 16:15maiteSeveritymajor => minor
2010-12-21 16:27adrianromeroAssigned Toadrianromero => eduardo_Argal
2011-01-25 02:39eintelauIssue Monitored: eintelau
2011-02-14 19:17dmitry_mezentsevNote Added: 0034189
2011-02-21 12:41eduardo_ArgalNote Added: 0034279
2011-02-21 12:41eduardo_ArgalStatusnew => scheduled
2011-02-21 12:41eduardo_Argalfix_in_branch => pi
2011-02-21 12:41miruritaAssigned Toeduardo_Argal => mtaal
2011-02-21 12:41miruritaAssigned Tomtaal => eduardo_Argal
2011-03-08 11:17hgbotCheckin
2011-03-08 11:17hgbotNote Added: 0034646
2011-03-08 11:17hgbotStatusscheduled => resolved
2011-03-08 11:17hgbotResolutionopen => fixed
2011-03-08 11:17hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e512eb8da0b254c224901f9c25b418e27d33efb7 [^]
2011-05-24 10:12dalsasuaTag Attached: closingMay2011
2011-05-24 10:55dalsasuaStatusresolved => closed

Notes
(0034189)
dmitry_mezentsev   
2011-02-14 19:17   
Eduardo, Maite,

Here is the comment about the issue from the partner.
Both customers are catching up on bank statements. They are for example entering statements since september last year. If they accidentally enter a reconciliation date of february they cannot reconcile before february anymore. It's a bit frustrating not being able to undo that action. I have now 2 customers with that problem which leads me to believe that this will be a common mistake made that requires a user-friendly way of solving. If it canbe solved short-term by changing a date in the database then that works for me too. Currently customer are getting slightly nervous they cannot continue."

The last statement makes all the sense for me. While we are doing correct fix can we provide a script to "decrease the heat"?

Thanks.
(0034279)
eduardo_Argal   
2011-02-21 12:41   
Hi,

We are working on this feature
(0034646)
hgbot   
2011-03-08 11:17   
Repository: erp/devel/pi
Changeset: e512eb8da0b254c224901f9c25b418e27d33efb7
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Tue Mar 08 11:19:07 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e512eb8da0b254c224901f9c25b418e27d33efb7 [^]

Fixes bug 0015504: Implement procedure to rollback reconciliations

---
M modules/org.openbravo.advpaymentmngt/src-db/database/model/views/APRM_RECONCILIATION_V.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MESSAGE.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_MODEL_OBJECT.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_PROCESS_PARA.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REFERENCE.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_REF_LIST.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_VAL_RULE.xml
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/MatchTransaction.java
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_actionbutton/Reconciliation.java
M src-db/database/sourcedata/AD_REF_LIST.xml
A modules/org.openbravo.advpaymentmngt/src-db/database/model/modifiedTables/FIN_RECONCILIATION.xml
A modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/process/FIN_ReconciliationProcess.java
---