Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0023012Openbravo ERP09. Financial managementpublic2013-02-07 16:262013-04-25 01:50
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0023012: 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
Additional Information
TagsNo tags attached.
Relationships
depends on defect 0023011 closed AugustoMauch Wrong hql query due to hql order by clause of a tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-02-07 16:26eduardo_ArgalNew Issue
2013-02-07 16:26eduardo_ArgalAssigned To => eduardo_Argal
2013-02-07 16:26eduardo_ArgalModules => Core
2013-02-07 16:26eduardo_ArgalOBNetwork customer => No
2013-02-07 16:26eduardo_ArgalTriggers an Emergency Pack => No
2013-02-07 16:26eduardo_ArgalStatusnew => scheduled
2013-02-07 16:26eduardo_Argalfix_in_branch => pi
2013-02-07 16:26eduardo_ArgalStatusscheduled => acknowledged
2013-02-07 16:27eduardo_ArgalRelationship addeddepends on 0023011
2013-04-19 18:22hgbotCheckin
2013-04-19 18:22hgbotNote Added: 0058065
2013-04-19 18:22hgbotStatusacknowledged => resolved
2013-04-19 18:22hgbotResolutionopen => fixed
2013-04-19 18:22hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cdaa760eb48680f428f6f6aee9f192773ac9094e [^]
2013-04-22 16:36hudsonbotCheckin
2013-04-22 16:36hudsonbotNote Added: 0058107
2013-04-23 12:53hgbotCheckin
2013-04-23 12:53hgbotNote Added: 0058126
2013-04-23 12:54dmiguelezNote Added: 0058127
2013-04-23 12:54dmiguelezStatusresolved => closed
2013-04-25 01:50hudsonbotCheckin
2013-04-25 01:50hudsonbotNote Added: 0058193

Notes
(0058065)
hgbot   
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   
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   
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   
2013-04-23 12:54   
Code Review + Testing Ok
(0058193)
hudsonbot   
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