Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018861
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajoralways2011-10-25 10:552011-11-04 13:58
ReportermiruritaView Statuspublic 
Assigned ToioritzCia 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionf298bc6c2d27
ProjectionnoneETAnoneTarget Version3.0MP5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018861: 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
TagsNo 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
Powered by Mantis Bugtracker