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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023012
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementmajorsometimes2013-02-07 16:262013-04-25 01:50
Reportereduardo_ArgalView Statuspublic 
Assigned Toeduardo_Argal 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisioncdaa760eb486
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023012: Accounting tab for transactions does not order properly when negative values exist

DescriptionAccounting entries should be ordered so that debit entries are displayed prior to credit ones. This behavior does not work when having negative entries in the ledger.
Steps To ReproduceCreate a sales invoice with a negative line and configure the ledger to allow negative entries.
Browse Accounting tab once posted and verify ordering is not optimal.
Proposed SolutionModify hqlorderbyclause for Accounting tabs inside transactional windows and set the following ordering criteria:
accountingSchema.name, accountingDate, abs(debit) desc, debit desc, abd(credit) desc, value
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on defect 0023011 closedAugustoMauch Wrong hql query due to hql order by clause of a tab 

-  Notes
(0058065)
hgbot (developer)
2013-04-19 18:22

Repository: erp/devel/pi
Changeset: cdaa760eb48680f428f6f6aee9f192773ac9094e
Author: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
Date: Fri Apr 19 18:21:54 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cdaa760eb48680f428f6f6aee9f192773ac9094e [^]

Fixes issue 23012

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
M src-db/database/sourcedata/AD_TAB.xml
---
(0058107)
hudsonbot (developer)
2013-04-22 16:36

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/f78aa78542fa [^]

Maturity status: Test
(0058126)
hgbot (developer)
2013-04-23 12:53

Repository: erp/devel/pi
Changeset: 423380e4f7ea629f4fc1cf505286ce42797b7ff1
Author: David Miguelez <david.miguelez <at> openbravo.com>
Date: Tue Apr 23 12:52:24 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/423380e4f7ea629f4fc1cf505286ce42797b7ff1 [^]

Related to Issue 23012: Orders Accounting Tab below Transactions
Tab by Debit and Credit.

---
M modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TAB.xml
---
(0058127)
dmiguelez (developer)
2013-04-23 12:54

Code Review + Testing Ok
(0058193)
hudsonbot (developer)
2013-04-25 01:50

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/9fa1ecafd560 [^]

Maturity status: Test

- Issue History
Date Modified Username Field Change
2013-02-07 16:26 eduardo_Argal New Issue
2013-02-07 16:26 eduardo_Argal Assigned To => eduardo_Argal
2013-02-07 16:26 eduardo_Argal Modules => Core
2013-02-07 16:26 eduardo_Argal Triggers an Emergency Pack => No
2013-02-07 16:26 eduardo_Argal Status new => scheduled
2013-02-07 16:26 eduardo_Argal fix_in_branch => pi
2013-02-07 16:26 eduardo_Argal Status scheduled => acknowledged
2013-02-07 16:27 eduardo_Argal Relationship added depends on 0023011
2013-04-19 18:22 hgbot Checkin
2013-04-19 18:22 hgbot Note Added: 0058065
2013-04-19 18:22 hgbot Status acknowledged => resolved
2013-04-19 18:22 hgbot Resolution open => fixed
2013-04-19 18:22 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cdaa760eb48680f428f6f6aee9f192773ac9094e [^]
2013-04-22 16:36 hudsonbot Checkin
2013-04-22 16:36 hudsonbot Note Added: 0058107
2013-04-23 12:53 hgbot Checkin
2013-04-23 12:53 hgbot Note Added: 0058126
2013-04-23 12:54 dmiguelez Note Added: 0058127
2013-04-23 12:54 dmiguelez Status resolved => closed
2013-04-25 01:50 hudsonbot Checkin
2013-04-25 01:50 hudsonbot Note Added: 0058193


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker