0008903: report "project profitability" is incorrect with invoices voids

Description

the 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 Solution

The 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;

Tags

comsupchennai_sprint6

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	backport	0009088		closed	rafaroda	Change Project Profitability citeria for displaying invoices
blocks	defect	0008895		closed	jayakumar	report "project profitability" is incorrect with invoices voids

Notes
(0016207) hgbot (developer) 2009-05-11 06:12	Repository: erp/stable/2.40 Changeset: 28f141bf34d11849ae6d48e143b1df69cb08b0a6 Author: Jayakumar Kasinathan <jayakumar.kasinathan <at> openbravo.com> Date: Sun May 10 21:44:10 2009 -0400 URL: http://code.openbravo.com/erp/stable/2.40/rev/28f141bf34d11849ae6d48e143b1df69cb08b0a6 [^] Fixes bug 8903 report \"project profitability\" is incorrect with invoices voids. --- M src-db/database/model/functions/C_INVOICE_POST.xml ---

(0016373) sureshbabu (reporter) 2009-05-15 11:17	Tested working fine

Issue History
Date Modified	Username	Field	Change
2009-05-05 12:04	psarobe	Type	defect => backport
2009-05-05 12:04	psarobe	fix_in_branch	=> 2.40
2009-05-07 12:33	psarobe	Steps to Reproduce Updated
2009-05-07 12:53	rafaroda	Assigned To	rafaroda => sathiyan
2009-05-07 12:53	rafaroda	Steps to Reproduce Updated
2009-05-07 13:16	sathiyan	Assigned To	sathiyan => jayakumar
2009-05-11 06:12	hgbot	Checkin
2009-05-11 06:12	hgbot	Note Added: 0016207
2009-05-11 06:12	hgbot	Status	scheduled => resolved
2009-05-11 06:12	hgbot	Resolution	open => fixed
2009-05-11 06:12	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/stable/2.40/rev/28f141bf34d11849ae6d48e143b1df69cb08b0a6 [^]
2009-05-11 06:19	jayakumar	Tag Attached: comsupchennai_sprint6
2009-05-11 17:48	psarobe	Fixed in Version	=> 2.40MP4
2009-05-15 11:17	sureshbabu	Status	resolved => closed
2009-05-15 11:17	sureshbabu	Note Added: 0016373
2009-05-19 18:17	rafaroda	Relationship added	related to 0009088