Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004974 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 08. Project and service management | minor | always | 2008-09-09 17:26 | 2009-03-03 17:16 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | Dowid | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40 | |||
| Status | closed | Fix in branch | 2.40 | Fixed in SCM revision | 11172 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004974: Employee Expenses: Expense Date field and Business Partner field value | |||||||
| Description | Employee Expenses lines tab should look like Invoiceable Expenses lines one. Comparing the two screenshots attached, one can see that in Employee Expenses lines tab: 1) 'Expense Date' field is not shown. 2) 'Business Partner' field is filled with employee name instead of the business partner of the expense line (if any). There is an issue with 'S_TIMEEXPENSELINE_V' view. | |||||||
| Steps To Reproduce | 1. Go to Project & Service Management || Transactions || Expense Sheet 2. Add a new one and save 3. Go to 'Lines' tab. 4. Select Reinvoincing option, a product and a business partner. 5. Go back to 'Header' tab and click on 'Process' button. 5. Go to Project & Service Management || Transactions || Employee Expenses 6. Select the previous employee and go to 'Lines' tab. Notice that: 1) 'Expense Date' field is not shown. 2) 'Business Partner' field is filled with employee name instead of business partner one. | |||||||
| Proposed Solution | S_TIMEEXPENSELINE_V view, that is the base for Employee Expense line tab, looks like: SELECT tel.s_timeexpenseline_id, tel.ad_client_id, tel.ad_org_id, tel.isactive, tel.created, tel.createdby, tel.updated, tel.updatedby, tel.s_timeexpense_id, tel.line, tel.istimereport, te.datereport, tel.m_product_id, tel.qty, tel.expenseamt, tel.c_currency_id, tel.convertedamt, tel.s_resourceassignment_id, tel.description, tel.note, tel.isinvoiced, tel.c_project_id, tel.c_activity_id, tel.c_campaign_id, tel.c_invoiceline_id, tel.invoiceprice, tel.c_uom_id, tel.c_orderline_id, tel.c_projectphase_id, tel.c_projecttask_id, tel.s_timetype_id, te.c_bpartner_id FROM s_timeexpenseline tel JOIN s_timeexpense te ON tel.s_timeexpense_id = te.s_timeexpense_id WHERE tel.qty <> 0 AND tel.c_invoiceline_id IS NULL AND te.processed = 'Y' AND tel.isactive = 'Y' AND te.isactive = 'Y' AND tel.istimereport <> 'Y' 1) In order to show Expense Date field, 'tel.dateexpense' should be added before FROM clause. 2) In order to show correct value of expense line business partner, 'tel.c_bpartner_id' should be added before FROM clause. But this seem to conflict with current 'te.c_bpartner_id'. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0011268) svnbot (reporter) 2008-12-12 17:44 |
Repository: openbravo Revision: 11172 Author: dowid Date: 2008-12-12 17:44:43 +0100 (Fri, 12 Dec 2008) bug fixed 0004974: Employee Expenses: Expense Date field and Business Partner field value --- U branches/r2.40/src-db/database/model/views/S_TIMEEXPENSELINE_V.xml U branches/r2.40/src-db/database/sourcedata/AD_COLUMN.xml U branches/r2.40/src-db/database/sourcedata/AD_ELEMENT.xml U branches/r2.40/src-db/database/sourcedata/AD_FIELD.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=11172&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-09 17:26 | anonymous | New Issue | |
| 2008-09-09 17:26 | anonymous | Assigned To | => cromero |
| 2008-09-09 17:26 | anonymous | Status | new => scheduled |
| 2008-09-09 17:26 | anonymous | Fixed in Version | => 2.40 |
| 2008-09-09 17:26 | anonymous | fix_in_branch | => 2.40 |
| 2008-10-29 13:10 | cromero | Assigned To | cromero => AinhoaPagola |
| 2008-11-25 16:38 | rafaroda | Assigned To | AinhoaPagola => Dowid |
| 2008-12-12 17:44 | svnbot | Checkin | |
| 2008-12-12 17:44 | svnbot | Note Added: 0011268 | |
| 2008-12-12 17:44 | svnbot | Status | scheduled => resolved |
| 2008-12-12 17:44 | svnbot | Resolution | open => fixed |
| 2008-12-12 17:44 | svnbot | svn_revision | => 11172 |
| 2009-03-03 17:16 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |