Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013162Openbravo ERP09. Financial managementpublic2010-04-30 08:002010-07-20 00:00
Reporternetworkb 
Assigned Tosathiyan 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP14 
Target Version2.50MP18Fixed 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
Summary0013162: trial balance report is wrong if exist records of type "opening" similars
Descriptionif there is two records of type "opening" with the same account, date account and amount, in trial balance report only appear one of them
Steps To Reproduce. Financial Management || Accounting || Transactions || G/L Journal || Batch
  create new record

. Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header
  create new record: date 01/05/2010, opening checked

. Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header >> Lines
  new record:
   Accounting combination: Main-23200-_-_-_
   Foreign Currency Debit: 10
  new record:
   Accounting combination: Main-60000-_-_-_
   Foreign Currency Credit: 20
  new record:
   Accounting combination: Main-23200-_-_-_
   Foreign Currency Debit: 10
  new record:
   Accounting combination: Main-70000-_-_-_
   Foreign Currency Credit: 20

. Financial Management || Accounting || Transactions || G/L Journal || Batch >> Header
  process and post

. Financial Management || Accounting || Analysis Tools || Trial Balance Report || Trial Balance Report
  date from 02/05/2010
  date to 02/05/2010
  Accounting schema Smallbazar
  Organization Main
  Account Level Account

 in initial balance of account 232 only appear 10
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 00140742.50MP21 closed sathiyan Error with Opening entry in Trial Balance report 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-04-30 08:00networkbNew Issue
2010-04-30 08:00networkbAssigned To => dalsasua
2010-04-30 09:29dalsasuaStatusnew => scheduled
2010-04-30 09:29dalsasuafix_in_branch => pi
2010-05-11 18:19jpabloaeTarget Version2.50MP16 => 2.50MP17
2010-05-18 19:13networkbTarget Version2.50MP17 => 2.50MP18
2010-05-18 19:13networkbfix_in_branchpi =>
2010-05-25 11:31sathiyanAssigned Todalsasua => sathiyan
2010-05-25 13:38hgbotCheckin
2010-05-25 13:38hgbotNote Added: 0027722
2010-05-25 13:38hgbotStatusscheduled => resolved
2010-05-25 13:38hgbotResolutionopen => fixed
2010-05-25 13:38hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/88101b1f1a5fe5b7e1ee1583c163cf5b87235372 [^]
2010-06-03 22:49hudsonbotCheckin
2010-06-03 22:49hudsonbotNote Added: 0027927
2010-06-07 10:27sureshbabuNote Added: 0028042
2010-07-19 11:04sureshbabuNote Added: 0029383
2010-07-19 11:04sureshbabuStatusresolved => closed
2010-07-20 00:00anonymoussf_bug_id0 => 3031839
2010-08-05 13:07vmromanosRelationship addedhas duplicate 0014074

Notes
(0027722)
hgbot   
2010-05-25 13:38   
Repository: erp/devel/pi
Changeset: 88101b1f1a5fe5b7e1ee1583c163cf5b87235372
Author: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
Date: Tue May 25 17:07:25 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/88101b1f1a5fe5b7e1ee1583c163cf5b87235372 [^]

Fixes Issue 13162: trial balance report is wrong if exist records of type \"opening\" similars

---
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalance_data.xsql
---
(0027927)
hudsonbot   
2010-06-03 22:49   
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/88101b1f1a5f [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/c011484a38d9 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17407.obx [^]
(0028042)
sureshbabu   
2010-06-07 10:27   
Hi Sathiyan,

i have retested this fix, but i am not able to find the difference.

Kindly help me out to verify this fix.
(0029383)
sureshbabu   
2010-07-19 11:04   
Tested, its working fine