Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030865Openbravo ERPZ. Otherspublic2015-09-17 13:292015-09-21 10:59
Reportermaite 
Assigned Tovmromanos 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3.2Fixed in Version 
Merge Request Status
Review Assigned Todmiguelez
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2014-08-22
Regression introduced in release3.0PR14Q4
Regression introduced by commithttps://code.openbravo.com/erp/devel/main/rev/705e724737c0 [^]
Triggers an Emergency PackNo
Summary0030865: Include option to match transactions with higher date than bank statement line date (and update transaction date to bsl date)
DescriptionBefore Match Statement refactor, option to "Hide transactions after statement date" exists, so user was able to uncheck it and select transactions with higher date than statemen's date and run matching process. This option is not available any more after Match Statement refactor
Steps To Reproduce1. Access Cuenta de Banco financial account
2. Access Imported bank statement tab and create record with dates=09/09/2015
3. Add line with date 09/09/2015 and any amount
4. Access Transactions tab and create new register for 15/09/2015 and same amount. Process transaction
5. Run Match Statement process and realize that you are not able to find transaction when pressing "search" (magnifying glass) button from bank statement line
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 00308593.0PR15Q4 closed vmromanos Include option to match transactions with higher date than bank statement line date (and update transaction date to bsl date) 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-09-18 09:21vmromanosTypedefect => backport
2015-09-18 09:21vmromanosTarget Version3.0PR15Q4 => 3.0PR15Q3.2
2015-09-18 09:21vmromanosTag Attached: Approved
2015-09-21 10:56hgbotCheckin
2015-09-21 10:56hgbotNote Added: 0080521
2015-09-21 10:56hgbotStatusscheduled => resolved
2015-09-21 10:56hgbotResolutionopen => fixed
2015-09-21 10:56hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q3.2/rev/a8a58dc92469678a64b541556e42da168bf5835d [^]
2015-09-21 10:59dmiguelezReview Assigned To => dmiguelez
2015-09-21 10:59dmiguelezNote Added: 0080522
2015-09-21 10:59dmiguelezStatusresolved => closed

Notes
(0080521)
hgbot   
2015-09-21 10:56   
Repository: erp/backports/3.0PR15Q3.2
Changeset: a8a58dc92469678a64b541556e42da168bf5835d
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Fri Sep 18 11:31:27 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q3.2/rev/a8a58dc92469678a64b541556e42da168bf5835d [^]

Fixed bug 30865: Match Statement Transactions prior to Bank Statement Line date

When searching for transactions, the HQL query transformer added a where clause to get only the transactions prior or equal to the bank statement line's transaction date.
There are cases where you want to match to transactions registered after the bank statement line's transaction date.
Before the refactor, there was a flag to hide/show transactions in the future. With the refactor that functionality was lost.

To implement it again, we have moved that restriction from the hql query transformer to a new default filter for this tab. Thus the user can remove the filter to show all the transactions regardless the transaction date.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/hqlinjections/TransactionsToMatchTransformer.java
---
(0080522)
dmiguelez   
2015-09-21 10:59   
Code Review + Testing Ok