Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012216Openbravo ERP09. Financial managementpublic2010-02-10 18:052010-05-18 12:12
Reporternetworkb 
Assigned Tosathiyan 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP17Fixed in Version2.50MP14 
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
Summary0012216: Some tables do not contain USER1_ID, USER2_ID, C_PROJECT_ID and C_CAMPAIGN_ID
DescriptionGL_JOURNAL and GL_JOURNALLINE does not contain some fields needed to post correctly transactions. Other tables, have them.

This fields are:
USER1_ID
USER2_ID
C_PROJECT_ID
C_CAMPAIGN_ID
Steps To Reproduce
Proposed Solution- create columns USER1_ID, USER2_ID, C_PROJECT_ID and C_CAMPAIGN_ID in gl_journal table
- modify DocGLJournal.java to move data from this columns to the fact_acct
- add the fields of project and campaign to the gl journal window.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-10 18:05networkbNew Issue
2010-02-10 18:05networkbAssigned To => dalsasua
2010-02-10 18:05networkbOBNetwork customer => Yes
2010-02-10 18:06networkbSummarySome tables does not contain USER1_ID, USER2_ID, C_PROJECT_ID and C_CAMPAIGN_ID => Some tables do not contain USER1_ID, USER2_ID, C_PROJECT_ID and C_CAMPAIGN_ID
2010-02-11 11:54dalsasuaStatusnew => scheduled
2010-02-11 11:54dalsasuafix_in_branch => pi
2010-02-11 11:55dalsasuafix_in_branchpi =>
2010-02-11 11:55dalsasuaProposed Solution updated
2010-02-11 11:59dalsasuaPriorityhigh => urgent
2010-02-25 11:31sathiyanAssigned Todalsasua => sathiyan
2010-02-26 16:01hgbotCheckin
2010-02-26 16:01hgbotNote Added: 0024871
2010-02-26 16:01hgbotStatusscheduled => resolved
2010-02-26 16:01hgbotResolutionopen => fixed
2010-02-26 16:01hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4b33212d14a285933f8d4f12ef4d8064b2ef0263 [^]
2010-03-08 16:05jpabloaeTarget Version2.50MP14 => 2.50MP15
2010-03-09 11:46arunkumarNote Added: 0025168
2010-03-09 11:46arunkumarStatusresolved => closed
2010-03-09 11:46arunkumarFixed in Version => 2.50MP13
2010-03-10 17:23anonymoussf_bug_id0 =>
2010-03-10 18:29anonymoussf_bug_id => 2968046
2010-03-11 10:29jpabloaeFixed in Version2.50MP13 => 2.50MP14
2010-03-12 22:40hudsonbotCheckin
2010-03-12 22:40hudsonbotNote Added: 0025350
2010-05-18 12:12gorka_gilTarget Version2.50MP15 => 2.50MP17

Notes
(0024871)
hgbot   
2010-02-26 16:01   
Repository: erp/devel/pi
Changeset: 4b33212d14a285933f8d4f12ef4d8064b2ef0263
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Fri Feb 26 20:33:46 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4b33212d14a285933f8d4f12ef4d8064b2ef0263 [^]

Fixes Issue 12216: Some tables do not contain USER1_ID, USER2_ID, C_PROJECT_ID and C_CAMPAIGN_ID

---
M src-db/database/model/tables/GL_JOURNAL.xml
M src-db/database/sourcedata/AD_COLUMN.xml
M src-db/database/sourcedata/AD_FIELD.xml
M src/org/openbravo/erpCommon/ad_forms/DocGLJournal_data.xsql
---
(0025168)
arunkumar   
2010-03-09 11:46   
Tested & Working fine
(0025350)
hudsonbot   
2010-03-12 22:40   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/4b33212d14a2 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]