Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0040189 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Modules] Advanced Matching Algorithm | major | always | 2019-02-13 10:08 | 2019-02-14 10:57 | |||
| Reporter | Leyre | View Status | public | |||||
| Assigned To | markmm82 | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 927330ab5ee4 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Regression date | ||||||||
| Regression introduced by commit | https://code.openbravo.com/erp/pmods/org.openbravo.module.invoicematchingalgorithm/rev/aecbf237ba4b [^] | |||||||
| Regression level | Production - Confirmed Stable | |||||||
| Review Assigned To | Sandrahuguet | |||||||
| Regression introduced in release | ||||||||
| Summary | 0040189: Error in query when launching Match Statement | |||||||
| Description | Error in query when launching Match Statement | |||||||
| Steps To Reproduce | 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. ** Check an error is shown in the log | |||||||
| Proposed Solution | Issue: 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"); | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
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 |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |