Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0027293Openbravo ERPZ. Otherspublic2014-08-07 15:192014-12-30 23:24
ngarcia 
reinaldoguerra 
normalminoralways
closedfixed 
5
 
3.0PR15Q1 
Sandrahuguet
Core
No
0027293: Total Outstanding amount is not updated when reactivating an invoice
Total Outstanding amount is not updated when reactivating an invoice
As 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
No tags attached.
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 
Issue History
2014-08-07 15:19ngarciaNew Issue
2014-08-07 15:19ngarciaAssigned To => jonalegriaesarte
2014-08-07 15:19ngarciaModules => Core
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