Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040189
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Matching Algorithmmajoralways2019-02-13 10:082019-02-14 10:57
ReporterLeyreView Statuspublic 
Assigned Tomarkmm82 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision927330ab5ee4
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commithttps://code.openbravo.com/erp/pmods/org.openbravo.module.invoicematchingalgorithm/rev/aecbf237ba4b [^]
Regression levelProduction - Confirmed Stable
Review Assigned ToSandrahuguet
Regression introduced in release
Summary

0040189: Error in query when launching Match Statement

DescriptionError in query when launching Match Statement

Steps To Reproduce1. Apply module's dataset.

2. Go to a Financial Account and set Advanced Matching Algorithm as Matching Algorithm.

3. Create a new record in Bank statement, add a bank statement line with a business partner and process.

4. Create a new transaction in the same financial account: set the same amount but a different business partner and process it.

5. Launch the Match Statement process and select the option to launch the algorithm automatically.

** Check an error is shown in the log
Proposed SolutionIssue: https://issues.openbravo.com/view.php?id=38382 [^]

Changeset: https://code.openbravo.com/erp/pmods/org.openbravo.module.invoicematchingalgorithm/rev/aecbf237ba4be73c51ff7b0e0c4defc44f51080b [^]

It added a line:
+ whereClause.append(" = :amout");

Instead:
+ whereClause.append(" = :amount");
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
caused by defect 0038382 closedcaristu Openbravo ERP Deprecate usage of positional query parameters in OBQuery 

-  Notes
(0109815)
markmm82 (developer)
2019-02-14 03:46

Test Plan:
1. Apply module's dataset.

2. Go to a Financial Account and set Advanced Matching Algorithm as Matching Algorithm.

3. Create a new record in Bank statement, add a bank statement line with a business partner and process.

4. Create a new transaction in the same financial account: set the same amount but a different business partner and process it.

5. Launch the Match Statement process and select the option to launch the algorithm automatically.
  Notice that transaction and bank statement ahve been matched automatically.
(0109826)
hgbot (developer)
2019-02-14 10:56

Repository: erp/pmods/org.openbravo.module.invoicematchingalgorithm
Changeset: 927330ab5ee4cb9e1bbc8ad949dbb573de04301e
Author: Mark Molina <mark.molina <at> doceleguas.com>
Date: Wed Feb 13 23:46:32 2019 -0300
URL: http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicematchingalgorithm/rev/927330ab5ee4cb9e1bbc8ad949dbb573de04301e [^]

Fixes issue 40189: Error in query when launching Match Statement

The named parameter "amount" was incorrect defined

---
M src/org/openbravo/module/invoicematchingalgorithm/algorithm/InvoiceMatchingAlgorithm.java
---
(0109827)
Sandrahuguet (developer)
2019-02-14 10:57

Code review + testing OK

- Issue History
Date Modified Username Field Change
2019-02-13 10:08 Leyre New Issue
2019-02-13 10:08 Leyre Assigned To => Triage Finance
2019-02-13 10:08 Leyre Resolution time => 1550444400
2019-02-13 10:13 Leyre Summary Error in the field "amount" => Error in query when launching Match Statement
2019-02-13 10:13 Leyre Description Updated View Revisions
2019-02-13 13:24 Sandrahuguet Assigned To Triage Finance => AtulOpenbravo
2019-02-13 13:34 Sandrahuguet Assigned To AtulOpenbravo => markmm82
2019-02-13 16:45 Leyre Resolution time 1550444400 => 1551826800
2019-02-14 00:16 markmm82 Status new => acknowledged
2019-02-14 03:00 markmm82 Relationship added caused by 0038382
2019-02-14 03:01 markmm82 Regression introduced by commit => https://code.openbravo.com/erp/pmods/org.openbravo.module.invoicematchingalgorithm/rev/aecbf237ba4b [^]
2019-02-14 03:45 markmm82 Status acknowledged => scheduled
2019-02-14 03:46 markmm82 Note Added: 0109815
2019-02-14 10:21 Sandrahuguet Regression level => Production - Confirmed Stable
2019-02-14 10:56 hgbot Checkin
2019-02-14 10:56 hgbot Note Added: 0109826
2019-02-14 10:56 hgbot Status scheduled => resolved
2019-02-14 10:56 hgbot Resolution open => fixed
2019-02-14 10:56 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.module.invoicematchingalgorithm/rev/927330ab5ee4cb9e1bbc8ad949dbb573de04301e [^]
2019-02-14 10:57 Sandrahuguet Review Assigned To => Sandrahuguet
2019-02-14 10:57 Sandrahuguet Note Added: 0109827
2019-02-14 10:57 Sandrahuguet Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker