Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0018861 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 09. Financial management | major | always | 2011-10-25 10:55 | 2011-11-04 13:58 | |||
Reporter | mirurita | View Status | public | |||||
Assigned To | ioritzCia | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | f298bc6c2d27 | ||||
Projection | none | ETA | none | Target Version | 3.0MP5 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | 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 | 0018861: General Ledger Journal report not showing Transction accounting entries | |||||||
Description | Transactions accounting is not shown in General Ledger Journal report. In the query a join is done between ad_tab.ad_table_id = ad_table.ad_table_id. In some cases, i.e. Transactions tab, this tab is linked to a view. Different from the table configured in Accounting Schema tables. https://code.openbravo.com/erp/devel/pi/diff/9acda851780a/src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql [^] | |||||||
Steps To Reproduce | 1) Create a new GL Item. Enter accounts for different accounting schemas. 1) Go to 'Cashbook US East Coast' Financial Account 2) Click on Add Transaction button 3) Select GL Item in Transaction Type combo box 4) Select previously created GL Item. 5) Enter a Received In amount: 10€ 6) Click on OK button 7) Select entered transaction and click on Post button Realize that the accounting entries are not shown. | |||||||
Proposed Solution | From the ad_table_id information stored in fact_acct try to get the correct tab associated. conflicting cases: - Transactions tab - Reconciliations tab | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0042386) hgbot (developer) 2011-10-31 08:57 |
Repository: erp/devel/pi Changeset: f298bc6c2d27e07d9ce1cc33d59369845711ea1a Author: Ioritz Cia <ioritz.cia <at> openbravo.com> Date: Thu Oct 27 13:15:24 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/f298bc6c2d27e07d9ce1cc33d59369845711ea1a [^] Fixes issue 18861: General Ledger Journal report not showing Transction accounting entries. --- M src-db/database/sourcedata/AD_EXTENSION_POINTS.xml M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.html M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.xml M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql A src-db/database/model/functions/AD_GETTAB_FROM_TABLE.xml --- |
(0042393) mirurita (developer) 2011-10-31 11:43 |
Verified. |
(0042607) hudsonbot (developer) 2011-11-04 13:58 |
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/d10da320df2a [^] Maturity status: Test |
Issue History | |||
Date Modified | Username | Field | Change |
2011-10-25 10:55 | mirurita | New Issue | |
2011-10-25 10:55 | mirurita | Assigned To | => ioritzCia |
2011-10-25 10:55 | mirurita | Modules | => Core |
2011-10-31 08:57 | hgbot | Checkin | |
2011-10-31 08:57 | hgbot | Note Added: 0042386 | |
2011-10-31 08:57 | hgbot | Status | new => resolved |
2011-10-31 08:57 | hgbot | Resolution | open => fixed |
2011-10-31 08:57 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/f298bc6c2d27e07d9ce1cc33d59369845711ea1a [^] |
2011-10-31 11:43 | mirurita | Note Added: 0042393 | |
2011-10-31 11:43 | mirurita | Status | resolved => closed |
2011-11-04 13:58 | hudsonbot | Checkin | |
2011-11-04 13:58 | hudsonbot | Note Added: 0042607 |
Copyright © 2000 - 2009 MantisBT Group |