Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018861Openbravo ERP09. Financial managementpublic2011-10-25 10:552011-11-04 13:58
Reportermirurita 
Assigned ToioritzCia 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP5Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018861: General Ledger Journal report not showing Transction accounting entries
DescriptionTransactions 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 Reproduce1) 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 SolutionFrom the ad_table_id information stored in fact_acct try to get the correct tab associated.
conflicting cases:
- Transactions tab
- Reconciliations tab
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-25 10:55miruritaNew Issue
2011-10-25 10:55miruritaAssigned To => ioritzCia
2011-10-25 10:55miruritaModules => Core
2011-10-31 08:57hgbotCheckin
2011-10-31 08:57hgbotNote Added: 0042386
2011-10-31 08:57hgbotStatusnew => resolved
2011-10-31 08:57hgbotResolutionopen => fixed
2011-10-31 08:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f298bc6c2d27e07d9ce1cc33d59369845711ea1a [^]
2011-10-31 11:43miruritaNote Added: 0042393
2011-10-31 11:43miruritaStatusresolved => closed
2011-11-04 13:58hudsonbotCheckin
2011-11-04 13:58hudsonbotNote Added: 0042607

Notes
(0042386)
hgbot   
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   
2011-10-31 11:43   
Verified.
(0042607)
hudsonbot   
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