Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0027293Openbravo ERPZ. Otherspublic2014-08-07 15:192014-12-30 23:24
Reporterngarcia 
Assigned Toreinaldoguerra 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1Fixed in Version 
Merge Request Status
Review Assigned ToSandrahuguet
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket30281
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0027293: Total Outstanding amount is not updated when reactivating an invoice
DescriptionTotal Outstanding amount is not updated when reactivating an invoice
Steps To ReproduceAs group admin role:
   Create a Sales Invoice and complete it
   Reactivate it
   Check in grid view the Total Outstanding and Days till due fields have a value different from 0
   Void the invoice
   The values remain equal
   Launch the Payment Monitor process and check the values are updated to 0
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 00276173.0PR15Q1 closed fsoto82 Sales Invoice - Wrong "Paid in Full Date" when reactivating a Payment IN 
related to defect 00272503.0PR15Q1 closed reinaldoguerra "finalsettlement" field should be set to null when payment related to invoice is removed 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-08-07 15:19ngarciaNew Issue
2014-08-07 15:19ngarciaAssigned To => jonalegriaesarte
2014-08-07 15:19ngarciaOBNetwork customer => Yes
2014-08-07 15:19ngarciaModules => Core
2014-08-07 15:19ngarciaSupport ticket => 30281
2014-08-07 15:19ngarciaResolution time => 1414015200
2014-08-07 15:19ngarciaTriggers an Emergency Pack => No
2014-08-07 15:19ngarciaIssue Monitored: networkb
2014-09-08 16:12jonalegriaesarteAssigned Tojonalegriaesarte => AtulOpenbravo
2014-09-22 12:15vmromanosRelationship addedrelated to 0027617
2014-09-22 13:41vmromanosRelationship addedrelated to 0027250
2014-09-22 16:36jonalegriaesarteTarget Version => 3.0PR15Q1
2014-10-10 07:22reinaldoguerraAssigned ToAtulOpenbravo => reinaldoguerra
2014-10-10 07:22reinaldoguerraStatusnew => scheduled
2014-10-10 08:46reinaldoguerraNote Added: 0070855
2014-10-11 01:00reinaldoguerraNote Edited: 0070855bug_revision_view_page.php?bugnote_id=0070855#r6773
2014-11-03 15:36hgbotCheckin
2014-11-03 15:36hgbotNote Added: 0071369
2014-11-03 15:36hgbotStatusscheduled => resolved
2014-11-03 15:36hgbotResolutionopen => fixed
2014-11-03 15:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ed4a6b77221928ed8c9d5772ded66f1211093d8f [^]
2014-11-03 15:37SandrahuguetReview Assigned To => Sandrahuguet
2014-11-03 15:37SandrahuguetNote Added: 0071370
2014-11-03 15:37SandrahuguetStatusresolved => closed
2014-12-30 23:24hudsonbotCheckin
2014-12-30 23:24hudsonbotNote Added: 0073011

Notes
(0070855)
reinaldoguerra   
2014-10-10 08:46   
(edited on: 2014-10-11 01:00)
Test plan used:
1- Login into Openbravo ERP
2- Go to Sales Invoice window and create one.
3- Select a product in lines tab for example: Bebida Energética 0.5L and set an invoice quantity.
4- Complete the invoice.
5- Check in grid view the Total Outstanding and Days till due fields have a value different from 0.
6- Reactivate the invoice.
7- Check in grid view the Total Outstanding and Days till due fields are set to zero.

8- Execute step 1-5 now for Purchase Invoice window.
9- Check in grid view the Total Outstanding and Days till due fields are set to zero.
(0071369)
hgbot   
2014-11-03 15:36   
Repository: erp/devel/pi
Changeset: ed4a6b77221928ed8c9d5772ded66f1211093d8f
Author: Reinaldo Guerra <reinaldo.guerra <at> peoplewalking.com>
Date: Fri Oct 24 16:28:44 2014 -0500
URL: http://code.openbravo.com/erp/devel/pi/rev/ed4a6b77221928ed8c9d5772ded66f1211093d8f [^]

Fixed bug 27293: Total Outstanding is not updated when reactivating an invoice

A new PL/SQL procedure has been attached to C_Invoice_Post - Finish Process extension point to update OutstandingAmt and DaysTillDue fields to zero in c_invoice table, when reactivating the invoice and none error ocurred during this process.
The modification affects both windows: sales and purchase invoice so when reactivate process is executed the mentioned fields are set to zero either for purchase or sales flow.

---
A src-db/database/model/functions/C_INVOICE_REACTIVATE.xml
A src-db/database/sourcedata/AD_EP_PROCEDURES.xml
---
(0071370)
Sandrahuguet   
2014-11-03 15:37   
Code review + testing OK
(0073011)
hudsonbot   
2014-12-30 23:24   
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/6525fe229e06 [^]
Maturity status: Test