Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035632ModulesRemittancepublic2017-03-28 15:542017-10-11 17:56
ReporterSandrahuguet 
Assigned Tomarkmm82 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusscheduledResolutionopen 
PlatformOS20OS VersionCommunity Appliance
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0035632: Performance should be improved when a new remittance record is created
DescriptionPerformance should be improved when a new remittance record is created in a hgvol enviroment.

The following log is shown in the openbravo.log:

WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Remittance, in tab Remittance the combo fields inpfinFinancialAccountId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
Steps To ReproduceIn a hgvol enviroment
-As system admin
-Go to session preferences window
-Set org.openbravo.client.application.window.FormInitializationComponent to DEBUG

-Login in the ERP
-Go to remitances window
-Create new record, takes around 3s and the following log is shown in the openbravo.log:

WARN org.openbravo.client.application.window.FormInitializationComponent - Warning: In the window Remittance, in tab Remittance the combo fields inpfinFinancialAccountId contain more than 1000 entries, and this could cause bad performance in the application. Possible fixes include changing these columns from a combo into a Selector, or adding a validation to reduce the number of entries in the combo.
Proposed Solution
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-28 15:54SandrahuguetNew Issue
2017-03-28 15:54SandrahuguetAssigned To => Triage Finance
2017-03-28 15:54SandrahuguetTag Attached: Performance
2017-03-29 09:57SandrahuguetSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14909#r14909
2017-03-30 15:39SandrahuguetNote Added: 0095716
2017-04-03 13:50aferrazAssigned ToTriage Finance => markmm82
2017-10-11 17:48AtulOpenbravoStatusnew => scheduled
2017-10-11 17:56AtulOpenbravoNote Added: 0099867

Notes
(0095716)
Sandrahuguet   
2017-03-30 15:39   
It is only reproducible in one of our big testing enviroment with user Openbravo. Not reproducible with an user that only have access to one organization.
(0099867)
AtulOpenbravo   
2017-10-11 17:56   
Solution: Use OBUISEL_Selector Reference Financial Account Selector defined in Advanced Payables and Receivables Mngmt Module. Remittance module is dependant on this module so it is safe to use this selector.

Test Plan

- Define a new Financial Account in F&B España - Región Norte organization with name as Test Financial Account Región Norte
- Navigate to Remittance Window.
- Select organization as "F&B España - Región Norte"
- Realize that Financial account shown in the list are
  - Caja
  - Cuenta de Banco
  - Test Financial Account Región Norte
- Change organization to "F&B España - Región Sur"
- Realize that financial account shown in the list are
  - Caja
  - Cuenta de Banco
- Change organization to "F&B España, S.A"
- Realize that financial account shown in the list are
  - Caja
  - Cuenta de Banco
  - Test Financial Account Región Norte