Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0031473Openbravo ERP08. Project and service managementpublic2015-11-13 14:572015-12-17 17:49
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR16Q1Fixed in Version 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket39245
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0031473: Project Profitability report does not consider project information set at invoice line
DescriptionProject Profitability report does not consider project information set at invoice line
Steps To Reproduce0. Activated Instance
1. Access Client window and verify that Project dimension is enabled at line level
2. Logout / login
3. Access Multiphase Project window and create new record
4. Register Purchase Invoice for España org and "Otros servicios" pricelist
5. Add line for "Telefonia" product and set previous project as dimension
6. Process invoice
7. Run "Project Profitability" report for previous org, business partner and project and realize that no information is shown

NOTE: if you set project at header level instead of line level then information will be shown in the report
Proposed SolutionProblem is that report is checking project defined at c_invoice level or at C_InvoiceLine_AcctDimension level but in that case no information has been created in this tab for this invoice
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-11-13 14:57maiteNew Issue
2015-11-13 14:57maiteAssigned To => Triage Finance
2015-11-13 14:57maiteOBNetwork customer => Yes
2015-11-13 14:57maiteModules => Core
2015-11-13 14:57maiteSupport ticket => 39245
2015-11-13 14:57maiteResolution time => 1450306800
2015-11-13 14:57maiteTriggers an Emergency Pack => No
2015-11-13 14:57maiteIssue Monitored: networkb
2015-12-09 07:05AtulOpenbravoAssigned ToTriage Finance => AtulOpenbravo
2015-12-09 07:06AtulOpenbravoStatusnew => scheduled
2015-12-09 12:01AtulOpenbravoNote Added: 0082613
2015-12-09 14:33psanjuanSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=10427#r10427
2015-12-10 12:50psanjuanNote Added: 0082637
2015-12-10 12:51psanjuanNote Edited: 0082613bug_revision_view_page.php?bugnote_id=0082613#r10439
2015-12-10 12:55psanjuanNote Edited: 0082637bug_revision_view_page.php?bugnote_id=0082637#r10441
2015-12-10 15:02psanjuanNote Edited: 0082637bug_revision_view_page.php?bugnote_id=0082637#r10442
2015-12-10 16:51AtulOpenbravoNote Edited: 0082613bug_revision_view_page.php?bugnote_id=0082613#r10443
2015-12-16 14:06psanjuanNote Edited: 0082637bug_revision_view_page.php?bugnote_id=0082637#r10486
2015-12-16 14:06psanjuanNote Added: 0082804
2015-12-16 14:22psanjuanNote Edited: 0082804bug_revision_view_page.php?bugnote_id=0082804#r10488
2015-12-16 14:25psanjuanNote Edited: 0082804bug_revision_view_page.php?bugnote_id=0082804#r10489
2015-12-16 14:28psanjuanNote Edited: 0082804bug_revision_view_page.php?bugnote_id=0082804#r10490
2015-12-16 14:38psanjuanNote Edited: 0082804bug_revision_view_page.php?bugnote_id=0082804#r10491
2015-12-16 14:40psanjuanNote Edited: 0082804bug_revision_view_page.php?bugnote_id=0082804#r10492
2015-12-16 14:43psanjuanNote Edited: 0082804bug_revision_view_page.php?bugnote_id=0082804#r10493
2015-12-16 14:52psanjuanNote Edited: 0082804bug_revision_view_page.php?bugnote_id=0082804#r10494
2015-12-17 12:13hgbotCheckin
2015-12-17 12:13hgbotNote Added: 0082817
2015-12-17 12:13hgbotStatusscheduled => resolved
2015-12-17 12:13hgbotResolutionopen => fixed
2015-12-17 12:13hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/447428f58b158f817c1c8ea97678102527a4343e [^]
2015-12-17 12:14vmromanosReview Assigned To => vmromanos
2015-12-17 12:14vmromanosNote Added: 0082818
2015-12-17 12:14vmromanosStatusresolved => closed
2015-12-17 17:49hudsonbotCheckin
2015-12-17 17:49hudsonbotNote Added: 0082848

Notes
(0082613)
AtulOpenbravo   
2015-12-09 12:01   
(edited on: 2015-12-10 16:51)
Test Plan
- Activate the instance with license key.
1. Go to Client window and verify that Project dimension is enabled at line level.
2. Logout / login.
3. Create a Project Type as Standard.
4. Go to Multiphase Project window and create new record.
5. Using button Change Project Type, select type as Standard with some default date.
6. Create Purchase Invoice for España org and "Otros servicios" pricelist.
7. Add line for "Telefonia" product and set previous project as dimension.
8. Process invoice.
9. Run "Project Profitability" report for previous org, business partner and project and realize that invoice line amount information is shown in this report.
(0082637)
psanjuan   
2015-12-10 12:50   
(edited on: 2015-12-16 14:06)
not able to reproduce the issue as with above repro-steps I always get report content as null. Checking.

Issue verified as some configuration steps were missing.
(0082804)
psanjuan   
2015-12-16 14:06   
(edited on: 2015-12-16 14:52)
Test Plan

- Activate the instance with license key.

Test Case 1

- Go to Client window and verify that Project dimension is enabled at line level. Logout / login.

- Create a Project Type as "Standard", for F&B España org.

- Go to Multiphase Project window and create new record for F&B España, named "Project 100". Save it

- Using button "Set Project Type", select type as Standard with some default date, ie 01-01-2015

- Select a Business Partner in the project, under "More Information" section, i.e. alimentos y supermercados.

- Select a sales representative at the project header.

- Enter a project phase, named "Opening Phase", starting from 01-01-2015

- Click on "Change Project Status" and select "Order". Press OK.

- Verify that the process finish successfully.

- Enter below data in the header of the project:
Service Revenue = 10000
Planned Expenses = 850
Services Provided Cost = 500
Outsourced Cost = 150
Reinvoiced Expenses = 800
Save it

- Run Project Profitability report for F&B España, currency EUR and Project 100. Verify that there are no real services either expenses shown in the report for the project but just planned figures.

- Create a purchase invoice for España org, Bebidas Alegres BP, dated on today's date. Select product "Cerveza Ale 0.5L", invoiced quantity = 550. Select Project 100 under "Dimensions" section. Complete and Post the invoice for a total net amount = 748.00 EUR

- Run Project Profitability report for the same criteria as below and verify that an expense of 748.00 EUR is shown in there under Expenses // Expenses.

- Create a purchase invoice for España org, Bebidas Alegres BP, dated on today's date. Select Project 100 under "Dimensions" section, this time in the invoice header. go to Lines tab and select product "Cerveza Ale 0.5L", invoiced quantity = 25. Complete and Post the invoice for a total net amount = 34.00 EUR

- Run Project Profitability report for the same criteria as below and verify that an expense of 782.00 EUR is shown in there under Expenses // Expenses.

- Create a sales invoice for España org, Alimentos y Supermercados BP, dated on today's date. Select product "Bebida Energetica", invoiced quantity = 80. Select Project 100 under "Dimensions" section. Complete and Post the invoice for a total net amount = 119.20 EUR

- Run Project Profitability report for the same criteria as below and verify that a revenue of 119.20 EUR is shown in there under Expenses // Reinvoicing.

- Create a sales invoice for España org, Alimentos y Supermercados BP, dated on today's date.Select Project 100 under "Dimensions" section at the header. Go to Lines tab and select product "Bebida Energetica", invoiced quantity = 20 . Complete and Post the invoice for a total net amount = 29.80 EUR

- Run Project Profitability report for the same criteria as below and verify that a revenue of 149 EUR is shown in there under Expenses // Reinvoicing.

Test Case 1

Repeat above steps by creating a new project named Project 200 and making sure that the expense or reinvoincing lines related to each project are properly shown in the project profitability report for each project.

This last implies the creation of a purchase invoice with two purchase invoice lines one of them related to a different project. Same for Sales invoices.

Verified two HTML format and PDF Format.

Test Case 3

Repeate all above steps by creating the invoices (purchase/sales) from the corresponding orders (purchase/sales) in which each order line point to a different project. Verify that the amounts shown in the project profitability report are the correct ones, once invoice are completed and post to the ledger.

Verified. Issue can be code reviewed and closed.
(0082817)
hgbot   
2015-12-17 12:13   
Repository: erp/devel/pi
Changeset: 447428f58b158f817c1c8ea97678102527a4343e
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Wed Dec 09 16:24:10 2015 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/447428f58b158f817c1c8ea97678102527a4343e [^]

Fixes Issue 31473:Project Profitability report does not consider project
information set at invoice line

Invoice Line project information is used prior to Invoice project info.

---
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitability_data.xsql
---
(0082818)
vmromanos   
2015-12-17 12:14   
Code review OK
(0082848)
hudsonbot   
2015-12-17 17:49   
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/7bb1cbcee3ce [^]
Maturity status: Test