Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0028773Openbravo ERP09. Financial managementpublic2015-01-26 16:472015-09-24 17:29
Reporteraferraz 
Assigned Toaferraz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target Version3.0PR15Q4Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket34152
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0028773: Grid from Match Statement popup is not filtering correctly by Date column
DescriptionWhen you try to filter by "Date" column in the grid of Match Statement popup, the grid filters by "Transaction Date" instead
Steps To Reproduce- Go to Financial Account window and select "Bank - Account 1"
- Move to Transaction tab and create one with "BP Deposit" transaction type, "19-01-2015" transaction date, "Salaries" g/l item and 500.00 deposit amount. Process it.
- Move to Imported Bank Statement tab and create one with "20-01-2015" transaction date, "Salaries" g/l item and 500.00 amount in. Process it.
- Click on Match Statement button, and click ok on the confirm popup. Match Statement popup shows a grid with the bank statment created line matched with the transaction created line.
- Realize that if you filter by "Date" column with "20-01-2015" value (bank statement date) the record is not shown, but if you filter with "19-01-2015" value (transaction date) it is.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0028674 new AugustoMauch Grid from Match Statement popup is not filtering correctly by Date column 
depends on defect 0028877 closed aferraz API Change Request: Change transactionDate column name in aprm_matchstatement table 
has duplicate defect 00288853.0PR15Q2 closed aferraz Filtering by date does not work in "Match Statement" window 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-01-26 16:47aferrazNew Issue
2015-01-26 16:47aferrazAssigned To => aferraz
2015-01-26 16:47aferrazOBNetwork customer => No
2015-01-26 16:47aferrazModules => Core
2015-01-26 16:47aferrazTriggers an Emergency Pack => No
2015-01-26 16:48aferrazRelationship addedrelated to 0028674
2015-02-06 12:45SandrahuguetRelationship addedblocks 0028885
2015-02-06 12:49SandrahuguetRelationship addeddepends on 0028877
2015-02-06 17:43dmitry_mezentsevRelationship replacedhas duplicate 0028885
2015-09-18 14:11maiteIssue Monitored: networkb
2015-09-18 14:13maiteOBNetwork customerNo => Yes
2015-09-18 14:13maiteSupport ticket => 34152
2015-09-18 14:13maiteResolution time => 1443736800
2015-09-18 14:13maitePrioritynormal => urgent
2015-09-18 14:13maiteSeverityminor => major
2015-09-18 14:13maiteTarget Version => 3.0PR15Q4
2015-09-21 16:26hgbotCheckin
2015-09-21 16:26hgbotNote Added: 0080536
2015-09-21 16:26hgbotCheckin
2015-09-21 16:26hgbotNote Added: 0080538
2015-09-21 16:26hgbotStatusnew => resolved
2015-09-21 16:26hgbotResolutionopen => fixed
2015-09-21 16:26hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/2fd1c4667c2e773d99d5f66fa7e73e79b01aba9c [^]
2015-09-21 18:02hgbotCheckin
2015-09-21 18:02hgbotNote Added: 0080545
2015-09-22 10:43dmiguelezReview Assigned To => dmiguelez
2015-09-22 10:43dmiguelezNote Added: 0080556
2015-09-22 10:43dmiguelezStatusresolved => closed
2015-09-24 17:29hudsonbotCheckin
2015-09-24 17:29hudsonbotNote Added: 0080624

Notes
(0080536)
hgbot   
2015-09-21 16:26   
Repository: erp/devel/api-checks
Changeset: 1ddcc1b5fcf9ad4c47fd34a6fe48378040b8cae8
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Sep 21 16:25:33 2015 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/1ddcc1b5fcf9ad4c47fd34a6fe48378040b8cae8 [^]

Fixes Issue 28877. API Change in Java due to Issue 28773.

---
M java/reference/java.japi.gz
---
(0080538)
hgbot   
2015-09-21 16:26   
Repository: erp/devel/pi
Changeset: 2fd1c4667c2e773d99d5f66fa7e73e79b01aba9c
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Tue Jan 27 12:37:32 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2fd1c4667c2e773d99d5f66fa7e73e79b01aba9c [^]

Fixes issue 28773: Grid from Match Statement popup is not filtering correctly

transactionDate column from aprm_matchstatement table has been renamed to trxDate in order to avoid having the same column name as transactionDate from fin_finacc_transaction, which causes problems in the query

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
---
(0080545)
hgbot   
2015-09-21 18:02   
Repository: erp/devel/api-checks
Changeset: 7ed1d7f8d339a7ddfdaac0fd0d6b8dc676af2bc8
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Mon Sep 21 18:02:12 2015 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/7ed1d7f8d339a7ddfdaac0fd0d6b8dc676af2bc8 [^]

Fixes Issue 28877. API Change in Java due to Issue 28773.

---
M java/reference/java.japi.gz
---
(0080556)
dmiguelez   
2015-09-22 10:43   
Code Review + Testing Ok
(0080624)
hudsonbot   
2015-09-24 17:29   
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/37e30a4ff711 [^]
Maturity status: Test