Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031389Openbravo ERPZ. Otherspublic2015-11-06 10:502015-11-23 21:17
Reportermaite 
Assigned Toaferraz 
PriorityimmediateSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR16Q1Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2014-09-23
Regression introduced in release3.0PR14Q4
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/179d97ee602d [^]
Triggers an Emergency PackNo
Summary0031389: Hover over Matched Document does not show document details information as before, in Match Statement pop-up
DescriptionBefore Match Statement refactor, if you hover over "Matched document" field document details information was shown: invoice/order documentno or gl item information
Steps To Reproduce1. Access Cuenta de Banco financial account, create new Bank Statement record and line with amount in=15 and process bank statement.
2. Register Sales Invoice with total gross =15. Process invoice
3. Register payment related with the invoice.
4. Run "Match Statement" process and match bank statement line with previous payment.
5. Hover over "Matched Document" field and realize that no information abut invoice appear

If you follow similar process in version prior to refactor (for example MP30.3) you can verify that invoice's document number appears
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00314423.0PR15Q4 closed aferraz Hover over Matched Document does not show document details information as before, in Match Statement pop-up 
depends on backport 00314433.0PR15Q3.4 closed aferraz Hover over Matched Document does not show document details information as before, in Match Statement pop-up 
caused by feature request 00293903.0PR14Q4 closed Sandrahuguet Reconciliation refactor project 
causes defect 00315153.0PR16Q1 closed aferraz Empty matched document when running Match Statement pocess 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-11-06 10:50maiteNew Issue
2015-11-06 10:50maiteAssigned To => Triage Finance
2015-11-06 10:50maiteModules => Advanced Payables and Receivables Mngmt
2015-11-06 10:50maiteResolution time => 1449702000
2015-11-06 10:50maiteTriggers an Emergency Pack => No
2015-11-06 10:52maiteSummaryHover over Matched Document does not show Invoice/Order information as before, in Match Statement pop-up => Hover over Matched Document does not show document details information as before, in Match Statement pop-up
2015-11-06 10:52maiteDescription Updatedbug_revision_view_page.php?rev_id=10094#r10094
2015-11-06 10:52maiteIssue Monitored: networkb
2015-11-10 12:33hgbotCheckin
2015-11-10 12:33hgbotNote Added: 0081643
2015-11-10 13:48aferrazAssigned ToTriage Finance => aferraz
2015-11-10 13:55aferrazRelationship addedcaused by 0029390
2015-11-10 13:58aferrazRegression level => Production - Confirmed Stable
2015-11-10 13:58aferrazRegression date => 2014-09-23
2015-11-10 13:58aferrazRegression introduced in release => 3.0PR14Q4
2015-11-10 13:58aferrazRegression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/179d97ee602d [^]
2015-11-11 18:17aferrazNote Added: 0081725
2015-11-12 10:14aferrazStatusnew => scheduled
2015-11-12 17:39vmromanosNote Deleted: 0081643
2015-11-12 19:20hgbotCheckin
2015-11-12 19:20hgbotNote Added: 0081782
2015-11-12 19:20hgbotStatusscheduled => resolved
2015-11-12 19:20hgbotResolutionopen => fixed
2015-11-12 19:20hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fe7e7c17712bcf75d97d44bc313b0d3e6e5d6377 [^]
2015-11-12 19:20hgbotCheckin
2015-11-12 19:20hgbotNote Added: 0081784
2015-11-12 19:20hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/fe7e7c17712bcf75d97d44bc313b0d3e6e5d6377 [^] => http://code.openbravo.com/erp/devel/pi/rev/fcda68dddca6df0c946d754ec956f7635ce0fe9c [^]
2015-11-12 19:27vmromanosReview Assigned To => vmromanos
2015-11-12 19:27vmromanosNote Added: 0081796
2015-11-12 19:27vmromanosStatusresolved => closed
2015-11-17 15:23aferrazRelationship addedcauses 0031515
2015-11-20 15:12aferrazNote Added: 0082031
2015-11-23 21:17hudsonbotCheckin
2015-11-23 21:17hudsonbotNote Added: 0082218
2015-11-23 21:17hudsonbotCheckin
2015-11-23 21:17hudsonbotNote Added: 0082220

Notes
(0081725)
aferraz   
2015-11-11 18:17   
Test plan:

As F&B Admin:

- Create a Sales Invoice for Alimentos y Supermercados.
  Add a line with Agua sin gas product and quantity 10.
  Process it. Let's say it has document number: 1000160.
  Click on Add Payment and process and deposit it.

- Access Cuenta de Banco Financial Account.
  Create new Bank Statement record.
  Create new line with amount in 18.51 (invoice gross amount), business partner Alimentos y Supermercados, business partner name "name of my bp" and description "bsl description".
  Process bank statement.

- Run "Match Statement" process.
  Select Ok when asking for automatic matching.
  Clear filter.
  Show Business Partner Name, Description and Transaction Description columns.
  Realize your bank statement line is shown as matched with the following information:
  Sender: "Alimentos y Supermercados", Business Partner Name: "name of my bp", Description: "bsl description", Transaction Description: "Invoice No.: 1000160".

As System Admin:

- Go to Match Statement P&E window, select Match Statement tab and check show in grid view flag for the following fields: Business Partner Name, Description and Transaction Description.
  
As F&B Admin:

- Access Cuenta de Banco Financial Account.
  Click on Match Statement.
  Clear filter.
  Realize your matched bank statement line is shown with the same information and Business Partner Name, Description and Transaction Description columns are shown by default.
(0081782)
hgbot   
2015-11-12 19:20   
Repository: erp/devel/pi
Changeset: fe7e7c17712bcf75d97d44bc313b0d3e6e5d6377
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Wed Nov 11 20:01:21 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fe7e7c17712bcf75d97d44bc313b0d3e6e5d6377 [^]

Fixes issue 31387 & Fixes issue 31389: Add two new columns in Match Statement

Added Business Partner Name and Transaction Description as new fields in Match Statement P&E window. They will not be shown in grid by default.
HQL Query in aprm_matchstatement table has been modified to retrieve this two new columns from FIN_BankStatementLine and FIN_Finacc_Transaction tables, and to retrieve bp.name as businessPartner also in case it is null.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
---
(0081784)
hgbot   
2015-11-12 19:20   
Repository: erp/devel/pi
Changeset: fcda68dddca6df0c946d754ec956f7635ce0fe9c
Author: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
Date: Thu Nov 12 18:42:04 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fcda68dddca6df0c946d754ec956f7635ce0fe9c [^]

Fixes issue 31387 & Fixes issue 31389: code review improvements

Reverted back the behavior of the Sender field. It shows the Business Partner Name (from the OB object) or the Business Partner Name string as it was doing before.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
---
(0081796)
vmromanos   
2015-11-12 19:27   
Code review + testing OK
(0082031)
aferraz   
2015-11-20 15:12   
https://testlink.openbravo.com/testlink/linkto.php?tprojectPrefix=Communit&item=testcase&id=Communit-8627 [^]
(0082218)
hudsonbot   
2015-11-23 21:17   
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/7b56bebaaa88 [^]
Maturity status: Test
(0082220)
hudsonbot   
2015-11-23 21:17   
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/7b56bebaaa88 [^]
Maturity status: Test