Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007196Openbravo ERP09. Financial managementpublic2009-01-28 14:222011-02-04 09:15
Reportersureshbabu 
Assigned Tormorley 
PrioritynormalSeveritytrivialReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version2.35MP10 
Target VersionFixed 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
Summary0007196: Records displayed under Asset Amortization page are not sorted properly by default
DescriptionRecords displayed under Asset Amortization are not sorted properly by default.

Steps To ReproduceSteps to reproduce:
• Login as userA
• Go to Financial Management->Assets->Assets
• Click on new button to create a new asset
• Fill all the mandatory fields
• Check "Depreciate" check
• Set "Calculate type": Time
• Set "Amortize": Monthly
• Set "Use life - Months": 3
• Set "Purchase date": 01-01-2008
• Set "Deprecation start date": 15-01-2008
• Set "Asset value": 100
• Set "Deprecation amt.": 100
• Save
• Click on "Create Amortization"
• Go to Financial Management->Assets->Assets->Asset Amortization ,


Expected result: Four lines with percentages of 16.14, 33.33, 33.33 and 17.20 will be generated.

Actual Result: Four lines generated but not sorted properly by default.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0007826 closed rafaroda Line items displayed in Asset amortization page not sorted properly 
Attached Filesdoc Test Case ID 1646_Amortize asset by time in non complete months.doc (152,576) 2009-01-28 14:23
https://issues.openbravo.com/file_download.php?file_id=754&type=bug
Issue History
Date ModifiedUsernameFieldChange
2009-01-28 14:22sureshbabuNew Issue
2009-01-28 14:22sureshbabuAssigned To => rafaroda
2009-01-28 14:23sureshbabusf_bug_id0 => 2543019
2009-01-28 14:23sureshbabuFile Added: Test Case ID 1646_Amortize asset by time in non complete months.doc
2009-01-30 16:29psarobeStatusnew => scheduled
2009-01-30 16:29psarobeAssigned Torafaroda => Dowid
2009-01-30 16:29psarobefix_in_branch => trunk
2009-03-06 08:24rafarodaRelationship addedhas duplicate 0007826
2009-03-11 12:40DowidNote Added: 0014572
2009-03-11 12:40DowidStatusscheduled => feedback
2009-03-12 09:24psarobeStatusfeedback => scheduled
2009-03-12 09:24psarobeTypedefect => feature request
2009-03-12 09:24psarobefix_in_branchpi =>
2009-03-24 10:59AinhoaPagolaAssigned ToDowid => pjuvara
2009-03-24 10:59AinhoaPagolaStatusscheduled => feedback
2009-03-24 10:59AinhoaPagolaStatusfeedback => new
2011-02-04 09:15jpabloaeAssigned Topjuvara => rmorley

Notes
(0014572)
Dowid   
2009-03-11 12:40   
Hi Suresh,

I believe that it is not a bug, because column "amortization" is a link to the parent table with compound AD id (id include three date field). System interprets this id as a String not as a Date.
In current grid functionality system can't interpret "compound id" in any other way except String.
 
So, in the grid value in the column "amortization" interprets as a string and the sorting works correctly.

I believe this bug should be marked as acknowledged.
You can add the future request for improve "Data Grid" for you suggestion.