Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0008895Openbravo ERP08. Project and service managementpublic2009-05-05 09:192009-05-29 00:00
Reporternetworkb 
Assigned Tojayakumar 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionrPath Linux
Product Version2.40MP3 
Target VersionFixed in Versionpi 
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
Summary0008895: report "project profitability" is incorrect with invoices voids
Descriptionthe field "revenue real" in service column, and the field "reinvoicing real" in expense column, when exist any void invoice, the negative invoice is included in calcule, but the positive invoice is not included
Steps To Reproduce. create invoice I with total amount 100 euros with project p
. run project profitability report with project p selected:
   field real revenue in service column is 100
. void invoice I
. run project profitability report with project p selected:
   field real revenue in service column is -100

the same error is with expenses invoices.
Proposed SolutionThe problem is not in the report which correctly displays both invoices in Complete and Closed status.

The problem is that the negative invoice created when voiding has the status closed. Both the voided invoice and the invoice created to void it have to be in status void.

Review the following lines in the procedure C_INVOICE_POST:
-- Reversal Transaction is closed
          UPDATE C_INVOICE
            SET DocStatus='CL', -- the reversal transaction
            DocAction='--',
            Processed='Y'
          WHERE C_Invoice_ID=v_RInvoice_ID;
Additional Information
Tagscomsupchennai_sprint6
Relationships
related to defect 0009037 closed rafaroda Change Project Profitability citeria for displaying invoices 
depends on backport 0008903 closed jayakumar report "project profitability" is incorrect with invoices voids 
depends on backport 0008923 closed jayakumar report "project profitability" is incorrect with invoices voids 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-05-05 09:19networkbNew Issue
2009-05-05 09:19networkbAssigned To => rafaroda
2009-05-05 09:19networkbRegression testing => No
2009-05-05 11:13networkbNote Added: 0016036
2009-05-05 12:04psarobeStatusnew => scheduled
2009-05-05 12:04psarobefix_in_branch => pi
2009-05-05 12:33networkbNote Edited: 0016036
2009-05-06 11:06psarobeStatusscheduled => feedback
2009-05-06 11:06psarobeStatusfeedback => scheduled
2009-05-07 12:53rafarodaAssigned Torafaroda => sathiyan
2009-05-07 12:53rafarodafix_in_branchpi =>
2009-05-07 12:53rafarodaSteps to Reproduce Updated
2009-05-07 13:16sathiyanAssigned Tosathiyan => jayakumar
2009-05-11 06:18hgbotCheckin
2009-05-11 06:18hgbotNote Added: 0016208
2009-05-11 06:18hgbotStatusscheduled => resolved
2009-05-11 06:18hgbotResolutionopen => fixed
2009-05-11 06:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/33a0697f2aef936426fbf7ae17dfdb388a284e2a [^]
2009-05-11 06:20jayakumarTag Attached: comsupchennai_sprint6
2009-05-15 08:20rafarodaRelationship addedrelated to 0009037
2009-05-28 11:46sureshbabuStatusresolved => closed
2009-05-28 11:46sureshbabuNote Added: 0016719
2009-05-28 11:46sureshbabuFixed in Version => pi
2009-05-29 00:00anonymoussf_bug_id0 => 2798137

Notes
(0016036)
networkb   
2009-05-05 11:13   
(edited on: 2009-05-05 12:33)
Dear team,
We have tested this bug in last MP (240MP3), but it was reported by user with 2.35 MP7 version, for this reason, we need backport to 2.35.

Thanks
(0016208)
hgbot   
2009-05-11 06:18   
Repository: erp/devel/pi
Changeset: 33a0697f2aef936426fbf7ae17dfdb388a284e2a
Author: Jayakumar Kasinathan <jayakumar.kasinathan <at> openbravo.com>
Date: Sun May 10 21:51:09 2009 -0400
URL: http://code.openbravo.com/erp/devel/pi/rev/33a0697f2aef936426fbf7ae17dfdb388a284e2a [^]

Fixes bug 8895 report \"project profitability\" is incorrect with invoices voids.

---
M src-db/database/model/functions/C_INVOICE_POST.xml
---
(0016719)
sureshbabu   
2009-05-28 11:46   
Tested working fine