Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018275Openbravo ERPZ. Otherspublic2011-08-12 15:232011-08-22 18:39
Reportermirurita 
Assigned Tomirurita 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018275: AlertsForWrongInvoices not taking in account VOID payment schedule details
DescriptionAfter the new status included in payments (void), the sum of the payment schedule details don't have to match with the payment schedule amount.

You can have the following scenario in which an invoice has been included in a payment and then this payment voided. The status in the database is the following:
Invoice Payment Schedule = 100
Payment Schedule Detail = 100
Payment Schedule Detail = 100 (voided)
That's why the new rule is: sum of the not voided payment schedule details have to match with the payment schedule amount.

The alert (AlertsForWrongInvoices) included in APRM for detecting discrepancies must be updated to take in account voided payment schedule details.
Steps To Reproduce1) Create invoice 1 (100€)
2) Pay completely invoice 1 with a payment method configured to be deferred (Awaiting Execution)
3) Void this payment
4) You will see the alert.
Proposed SolutionIgnore voided payment schedule details in the alert query.
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0018328 closed mirurita AlertsForWrongInvoices not taking in account VOID payment schedule details 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-08-12 15:23miruritaNew Issue
2011-08-12 15:23miruritaAssigned To => mirurita
2011-08-12 15:23miruritaModules => Core
2011-08-19 14:46miruritaStatusnew => scheduled
2011-08-19 14:46miruritafix_in_branch => pi
2011-08-22 12:25hgbotCheckin
2011-08-22 12:25hgbotNote Added: 0040379
2011-08-22 12:25hgbotStatusscheduled => resolved
2011-08-22 12:25hgbotResolutionopen => fixed
2011-08-22 12:25hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4566e9ce5e26355f05386944c5b5e186881bd155 [^]
2011-08-22 13:58psanjuanNote Added: 0040385
2011-08-22 13:58psanjuanStatusresolved => closed
2011-08-22 13:58psanjuanfix_in_branchpi =>
2011-08-22 18:39hudsonbotCheckin
2011-08-22 18:39hudsonbotNote Added: 0040423

Notes
(0040379)
hgbot   
2011-08-22 12:25   
Repository: erp/devel/pi
Changeset: 4566e9ce5e26355f05386944c5b5e186881bd155
Author: Mikel Irurita <mikel.irurita <at> openbravo.com>
Date: Mon Aug 22 12:23:24 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4566e9ce5e26355f05386944c5b5e186881bd155 [^]

Fixes issue 18275: AlertsForWrongInvoices modulescript not taking in account void psd-s

---
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoices.class
M modules/org.openbravo.advpaymentmngt/build/classes/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoicesData.class
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoices.java
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoices_data.xsql
M modules/org.openbravo.advpaymentmngt/src-util/modulescript/src/src/org/openbravo/advpaymentmngt/modulescript/AlertsForWrongInvoicesData.java
---
(0040385)
psanjuan   
2011-08-22 13:58   
fixed and working
(0040423)
hudsonbot   
2011-08-22 18:39   
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/30e6a459386a [^]

Maturity status: Test