Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0035455Openbravo ERP09. Financial managementpublic2017-03-08 17:542017-03-08 17:56
vmromanos 
Triage Omni OMS 
normalmajorhave not tried
newopen 
5
 
 
Core
No
0035455: Adapt every query that uses credit to take advantage of FIN_PAYMENT_BPARTNER_CREDIT index
As 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
NA
Performance
depends on defect 00335813.0PR17Q2 closed vmromanos slow defaults retrieval in add payment 
Issue History
2017-03-08 17:54vmromanosNew Issue
2017-03-08 17:54vmromanosAssigned To => Triage Finance
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.