Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013515Openbravo ERP09. Financial managementpublic2010-06-03 11:242010-07-23 00:00
Reporternetworkb 
Assigned Tobalamurugan 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionCommunity Appliance
Product Version2.50MP18 
Target Version2.50MP20Fixed in Version 
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
Summary0013515: incorrect order of entries in general ledger journal
Descriptionwhen exists several documents with the same dateacct, the order of entries in general ledger journal is not correct.

The same problem with Opening and closing entries.
If there are documents with dateacct equal to opening or closing entrie, the order in general ledger is incorrect
Steps To Reproduce1. Financial Management || Accounting || Transactions || Open/Close Period Control || Open/Close Period Control
 close period 2006

2. Financial Management || Accounting || Setup || Fiscal Calendar || Calendar >> Year
  create reg fact acct process

3. create invoice with dateacct 01/01/2007
4. process and post

5. create bankstatement with date 01/01/2007 and with payment generated in step 4
6. process and post

7. execute the general ledger report:
 entries generated by bankstatement are previous to entries generated by invoice
 entries genrated by opening entries are the last entries
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-06-03 11:24networkbNew Issue
2010-06-03 11:24networkbAssigned To => dalsasua
2010-06-03 11:24networkbOBNetwork customer => Yes
2010-06-07 16:42adrianromeroStatusnew => scheduled
2010-06-07 16:42adrianromerofix_in_branch => pi
2010-06-08 12:31psanjuanNote Added: 0028175
2010-06-08 12:31psanjuanfix_in_branchpi =>
2010-06-08 12:38psanjuanNote Added: 0028177
2010-06-08 12:39psanjuanNote Deleted: 0028177
2010-06-23 08:11balamuruganAssigned Todalsasua => balamurugan
2010-06-24 15:23hgbotCheckin
2010-06-24 15:23hgbotNote Added: 0028744
2010-06-24 15:23hgbotStatusscheduled => resolved
2010-06-24 15:23hgbotResolutionopen => fixed
2010-06-24 15:23hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0e4d680283442d96aeacb8e890ea876922d11df3 [^]
2010-06-30 12:17hudsonbotCheckin
2010-06-30 12:17hudsonbotNote Added: 0028903
2010-07-22 16:50sureshbabuNote Added: 0029473
2010-07-22 16:50sureshbabuStatusresolved => closed
2010-07-23 00:00anonymoussf_bug_id0 => 3033260

Notes
(0028175)
psanjuan   
2010-06-08 12:31   
It will only be fixed the fact that Opening and Closing entries are going to be properly identify so those can be listed taking into account the proper order.
Opening entry will always be the 1st one
Closing entry will always be the last one.
(0028744)
hgbot   
2010-06-24 15:23   
Repository: erp/devel/pi
Changeset: 0e4d680283442d96aeacb8e890ea876922d11df3
Author: Balamurugan Ramadoss <balamurugan.ramadoss <at> openbravo.com>
Date: Thu Jun 24 18:52:07 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/0e4d680283442d96aeacb8e890ea876922d11df3 [^]

Fixes Issue 13515: incorrect order of entries in general ledger journal.

---
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal_data.xsql
---
(0028903)
hudsonbot   
2010-06-30 12:17   
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/0e4d68028344 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/0670375d782d [^]
Tests: http://builds.openbravo.com/view/int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17726.obx [^]
(0029473)
sureshbabu   
2010-07-22 16:50   
verified