Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0016507Openbravo ERP08. Project and service managementpublic2011-03-28 11:332012-05-25 12:13
jtarbal 
Sandrahuguet 
normalminorhave not tried
closedfixed 
5
3.0RC5 
3.0MP12 
Core
No
0016507: Project Profitability report does not show collections correctly
Currently, the "Project Profitability" report has a field called "Collected" that shows the sales invoices that have already been paid. This field is not updated with the new Advanced Payeables and Receivables.
1.- Go to "Multiphase Project" window and create a new project.
2.- Go to "Sales Invoice" and create a new invoice linked to the project created before.
3.- Through the "Add Payment" button in the invoice header, manage the collection of this invoice.
4.- Go to the "Project Profitability" report and select the project created in step 1.
5.- Generate the report and realize that the "Collected" field does not show the real collected amount.
VMA-Reviewed
png Captura de pantalla 2011-09-21 a las 09.46.52.png (61,141) 2011-09-21 09:48
https://issues.openbravo.com/file_download.php?file_id=4582&type=bug
png
Issue History
2011-03-28 11:33jtarbalNew Issue
2011-03-28 11:33jtarbalAssigned To => adrianromero
2011-03-28 11:33jtarbalModules => Core
2011-06-03 10:58dalsasuaAssigned Toadrianromero => dalsasua
2011-07-20 18:16dalsasuaAssigned Todalsasua => jonalegriaesarte
2011-09-19 22:32psarobeNote Added: 0041102
2011-09-19 22:32psarobeStatusnew => feedback
2011-09-21 09:47jtarbalNote Added: 0041178
2011-09-21 09:48jtarbalFile Added: Captura de pantalla 2011-09-21 a las 09.46.52.png
2011-10-07 12:40dmitry_mezentsevStatusfeedback => scheduled
2011-10-07 12:40dmitry_mezentsevNote Added: 0041555
2011-10-07 12:40dmitry_mezentsevfix_in_branch => pi
2012-04-03 12:20jonalegriaesarteAssigned Tojonalegriaesarte => vmromanos
2012-04-10 16:21vmromanosTag Attached: VMA-Reviewed
2012-05-07 10:44SandrahuguetAssigned Tovmromanos => Sandrahuguet
2012-05-07 15:30SandrahuguetNote Added: 0048414
2012-05-23 18:12hgbotCheckin
2012-05-23 18:12hgbotNote Added: 0048894
2012-05-23 18:12hgbotStatusscheduled => resolved
2012-05-23 18:12hgbotResolutionopen => fixed
2012-05-23 18:12hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5f69cb68090f680cd22b32755f1678ff4d9938db [^]
2012-05-23 18:23miruritaNote Added: 0048898
2012-05-23 18:23miruritaStatusresolved => closed
2012-05-23 18:23miruritaFixed in Version => 3.0MP12
2012-05-25 12:13hudsonbotCheckin
2012-05-25 12:13hudsonbotNote Added: 0049192

Notes
(0041102)
psarobe   
2011-09-19 22:32   
Following your steps the field that is populated is "Reinvoicing". Is that correct?
(0041178)
jtarbal   
2011-09-21 09:47   
The field I am referring to is COLLECTED. This field remains empty. See screenshot attached.
(0041555)
dmitry_mezentsev   
2011-10-07 12:40   
I tested it in Demo (MP3) and Collected is not updated.
(0048414)
Sandrahuguet   
2012-05-07 15:30   
Test Plan:
-Go to multiphase project, and create one:
 ·Organization: F&B US, Inc.
 ·Name:project
 ·Business partner: Healthy Food Supermarkets, Co.
 ·Click in project status and change to order
-Go to sales invoice and create one
 ·Organization: F&B US, Inc.
 ·Business partner: Healthy Food Supermarkets, Co.
 ·Project: project
 ·Payment terms: 30 days
 ·Payment method: wire transfer
 ·Create a new line: Product= energy drink, invoiced quantity 10.
-Go to Project Profitability, generate the report and realize that the "Collected" field does show the real collected amount.
(0048894)
hgbot   
2012-05-23 18:12   
Repository: erp/devel/pi
Changeset: 5f69cb68090f680cd22b32755f1678ff4d9938db
Author: Sandra Huguet <sandra.huguet <at> openbravo.com>
Date: Mon May 07 15:19:46 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5f69cb68090f680cd22b32755f1678ff4d9938db [^]

Fixed bug 16507 Update 'collected' field in update Project Profitability
Update 'collected' field in update Project Profitability report to APR

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---
(0048898)
mirurita   
2012-05-23 18:23   
code review + testing OK

Using payment monitor fields of the invoice header.
(0049192)
hudsonbot   
2012-05-25 12:13   
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/5401e185a8b0 [^]

Maturity status: Test