Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0030170Openbravo ERP09. Financial managementpublic2015-06-12 14:102015-06-24 02:56
Reportervmromanos 
Assigned Toaferraz 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q3Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0030170: Generic UpdatePaymentPlan module script
DescriptionCurrently the UpdatePaymentPlan module script fixes the wrong data related to issue 0028236.

However we have found other bugs that create wrong payment plan too, so it makes sense to adapt this module script to be more generic, trying to fix any possible mismatch between payment plan and the details.

This module script improvement should be included in core only if we first verify that it has no significant negative impact into the performance
Steps To ReproduceNA
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00299723.0PR15Q3 closed jorge-garcia Outstanding amount of sales order payment plan is not updated when payment method is set as automatic receipt 
depends on backport 00301163.0PR15Q1.5 closed jorge-garcia Outstanding amount of sales order payment plan is not updated when payment method is set as automatic receipt 
depends on defect 00301663.0PR15Q3 closed aferraz Wrong order payment plan with isinvoicepaid feature 
depends on defect 0028236 closed pramakrishnan Payment schedule amount incorrectly calculated when adding a payment from reconcile window to a sales order 
depends on defect 0030009 closed aferraz UpdatePaymentPlan modulscript takes hours to finish updating from mp31 to PR15Q2 
depends on backport 00302203.0PR15Q2.3 closed aferraz Generic UpdatePaymentPlan module script 
depends on backport 00302213.0PR15Q1.6 closed aferraz Generic UpdatePaymentPlan module script 
depends on defect 0030007 closed aferraz Payment schedule amount incorrectly calculated when adding a payment from reconcile window to a sales order 
depends on defect 00300823.0PR15Q3 closed jorge-garcia Payment plan is updating wrong in some circunstancies 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-06-12 14:10vmromanosNew Issue
2015-06-12 14:10vmromanosAssigned To => aferraz
2015-06-12 14:10vmromanosModules => Core
2015-06-12 14:10vmromanosTriggers an Emergency Pack => No
2015-06-12 14:11vmromanosRelationship addedrelated to 0029972
2015-06-12 14:11vmromanosRelationship addeddepends on 0030116
2015-06-12 14:11vmromanosRelationship addeddepends on 0030166
2015-06-12 14:11ngarciaIssue Monitored: ngarcia
2015-06-12 14:11vmromanosRelationship addeddepends on 0028236
2015-06-12 14:27eugeniIssue Monitored: eugeni
2015-06-12 14:48aferrazRelationship addedrelated to 0030009
2015-06-15 16:43aferrazStatusnew => scheduled
2015-06-15 17:55aferrazRelationship deletedrelated to 0030009
2015-06-15 17:55aferrazRelationship addeddepends on 0030009
2015-06-22 11:44vmromanosStatusscheduled => acknowledged
2015-06-22 11:45vmromanosStatusacknowledged => scheduled
2015-06-22 11:56vmromanosRelationship addeddepends on 0030007
2015-06-22 11:58vmromanosRelationship addeddepends on 0030082
2015-06-23 17:15hgbotCheckin
2015-06-23 17:15hgbotNote Added: 0078449
2015-06-23 17:15hgbotStatusscheduled => resolved
2015-06-23 17:15hgbotResolutionopen => fixed
2015-06-23 17:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1cc71ac627a7282c1989104a7435520172b03b46 [^]
2015-06-23 17:17vmromanosReview Assigned To => vmromanos
2015-06-23 17:17vmromanosNote Added: 0078455
2015-06-23 17:17vmromanosStatusresolved => closed
2015-06-24 02:56hudsonbotCheckin
2015-06-24 02:56hudsonbotNote Added: 0078465

Notes
(0078449)
hgbot   
2015-06-23 17:15   
Repository: erp/devel/pi
Changeset: 1cc71ac627a7282c1989104a7435520172b03b46
Author: Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
Date: Mon Jun 22 18:36:18 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1cc71ac627a7282c1989104a7435520172b03b46 [^]

Fixes issue 30170: Generic UpdatePaymentPlan module script

Select query in UpdatePaymentPlan has been changed to make it generic.
Now it will fix all fin_payment_schedule related to an order or an invoice which paidamt or outstandingamt does not match with the sum of its fin_payment_scheduledetail amount.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/UpdatePaymentPlanData.class
M src-util/modulescript/src/org/openbravo/modulescript/UpdatePaymentPlan_data.xsql
---
(0078455)
vmromanos   
2015-06-23 17:17   
Code review + testing OK
(0078465)
hudsonbot   
2015-06-24 02:56   
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/0a35ad8c7048 [^]
Maturity status: Test