Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035455Openbravo ERP09. Financial managementpublic2017-03-08 17:542017-03-08 17:56
Reportervmromanos 
Assigned ToTriage Omni OMS 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035455: Adapt every query that uses credit to take advantage of FIN_PAYMENT_BPARTNER_CREDIT index
DescriptionAs part of the fix for 0033581, a new index FIN_PAYMENT_BPARTNER_CREDIT has been declared in FIN_Payment table.

We should review all the places where the previous index can be useful and adapt them to use it, following a similar solution to 0033581.

After a quick search, these are the places found (more research should be done!):

FinancialUtils.getPaymentsWithCredit()
RptC_Bpartner.getCustomerPaymentsWithCredit()

Think also whether it makes sense to have this duplicated or centralize instead everything in just one method
Steps To ReproduceNA
Proposed Solution
Additional Information
TagsPerformance
Relationships
depends on defect 00335813.0PR17Q2 closed vmromanos slow defaults retrieval in add payment 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-03-08 17:54vmromanosNew Issue
2017-03-08 17:54vmromanosAssigned To => Triage Finance
2017-03-08 17:54vmromanosOBNetwork customer => No
2017-03-08 17:54vmromanosModules => Core
2017-03-08 17:54vmromanosTriggers an Emergency Pack => No
2017-03-08 17:54vmromanosRelationship addeddepends on 0033581
2017-03-08 17:55vmromanosDescription Updatedbug_revision_view_page.php?rev_id=14748#r14748
2017-03-08 17:56vmromanosTag Attached: Performance

There are no notes attached to this issue.