Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0008903
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 08. Project and service managementmajoralways2009-05-05 09:192009-05-15 11:17
ReporternetworkbView Statuspublic 
Assigned Tojayakumar 
PriorityimmediateResolutionfixedFixed in Version2.40MP4
StatusclosedFix in branch2.40Fixed in SCM revision28f141bf34d1
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.40MP3SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0008903: 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;
Tagscomsupchennai_sprint6
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 0009088 closedrafaroda Change Project Profitability citeria for displaying invoices 
blocks defect 0008895 closedjayakumar 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 (viewer)
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker