Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016522Openbravo ERP09. Financial managementpublic2011-03-28 18:582011-04-05 00:00
Reporteradrianromero 
Assigned Toadrianromero 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
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
Summary0016522: Not possible to define SQLDescription for Amortization table filtering by @Line@
DescriptionNot possible to define SQLDescription for Amortization table filtering by @Line@
If you only use @RecordId@ it works as expected
Steps To Reproduce1. Go to Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema >> Account Schema Tables : search for table called "FinancialMgmtAmortization" add following description
"
SELECT 'Amortizacion: '|| A_AMORTIZATION.NAME || ' Linea: '||A_AMORTIZATIONLINE.LINE
FROM A_AMORTIZATION, A_AMORTIZATIONLINE WHERE A_AMORTIZATION.A_AMORTIZATION_ID =
A_AMORTIZATIONLINE.A_AMORTIZATION_ID AND A_AMORTIZATION.A_AMORTIZATION_ID =
@RecordId@ AND A_AMORTIZATIONLINE.A_AMORTIZATIONLINE_ID = @Line@
"

2. Financial Management || Assets || Assets || Assets : create asset for Main organization and asset group Machinery
3. Financial Management || Assets || Amortization || Header : create amortization for Main organization and today's date
5. Financial Management || Assets || Amortization || Header >> Line: add line using your asset and setting any fixed amount
6. Process and post amortization. Press "Detail" link in generated entry and realize that your description is not being used (standard description is being used. See screenshot1 attached)

If you modify description to "SELECT 'Amortizacion: '|| A_AMORTIZATION.NAME
FROM A_AMORTIZATION, A_AMORTIZATIONLINE WHERE A_AMORTIZATION.A_AMORTIZATION_ID =
A_AMORTIZATIONLINE.A_AMORTIZATION_ID AND A_AMORTIZATION.A_AMORTIZATION_ID =
@RecordId@" and then come back to Amortization and unpost/post it again description customized is used(but without filtering by line). See screenshot2 attached

Should be reviewed is same happen with other tables
Proposed SolutionModify file "DocLineAmortization_data.xsql" to retrieve data "A_AMORTIZATIONLINE.A_AMORTIZATIONLINE_ID"
Additional Information
TagsNo tags attached.
Relationships
blocks backport 00157202.50MP28 closed dalsasua Not possible to define SQLDescription for Amortization table filtering by @Line@ 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-28 18:58adrianromeroNew Issue
2011-03-28 18:58adrianromeroAssigned To => adrianromero
2011-03-28 18:58adrianromeroModules => Core
2011-03-28 18:58adrianromeroIssue generated from0015720
2011-03-28 18:58adrianromeroRelationship addedblocks 0015720
2011-03-28 18:59hgbotCheckin
2011-03-28 18:59hgbotNote Added: 0035285
2011-03-28 18:59hgbotStatusnew => resolved
2011-03-28 18:59hgbotResolutionopen => fixed
2011-03-28 18:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/61d7922b0e9e251c1eb0173166b7923e33a56b1d [^]
2011-03-28 19:05adrianromeroNote Added: 0035286
2011-04-04 12:22hgbotCheckin
2011-04-04 12:22hgbotNote Added: 0035526
2011-04-04 12:22hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/61d7922b0e9e251c1eb0173166b7923e33a56b1d [^] => http://code.openbravo.com/erp/devel/pi/rev/f7ef0a3e203bde2e5bb143674ce8427a99d8d24a [^]
2011-04-04 13:39maiteNote Added: 0035543
2011-04-04 13:39maiteStatusresolved => closed
2011-04-05 00:00anonymoussf_bug_id0 => 3274933

Notes
(0035285)
hgbot   
2011-03-28 18:59   
Repository: erp/devel/pi
Changeset: 61d7922b0e9e251c1eb0173166b7923e33a56b1d
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Mar 28 18:58:49 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/61d7922b0e9e251c1eb0173166b7923e33a56b1d [^]

Fixes issue 0016522: Not possible to define SQLDescription for Amortization table filtering by @Line@
Now DocLineAmortizationData retrieves the A_AMORTIZATIONLINE_ID field

---
M src/org/openbravo/erpCommon/ad_forms/DocLineAmortization_data.xsql
---
(0035286)
adrianromero   
2011-03-28 19:05   
* Testing the issue

Follow the steps to test and verify that the new description query is used.

* Other areas affected

No other areas affected. It has been modified only the query that gets the resutls for the description.
(0035526)
hgbot   
2011-04-04 12:22   
Repository: erp/devel/pi
Changeset: f7ef0a3e203bde2e5bb143674ce8427a99d8d24a
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Apr 04 12:21:55 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f7ef0a3e203bde2e5bb143674ce8427a99d8d24a [^]

Fixes issue 0016522: Not possible to define SQLDescription for Amortization table filtering by @Line@
Now DocLineAmortizationData retrieves the A_AMORTIZATIONLINE_ID field

---
M src/org/openbravo/erpCommon/ad_forms/DocLineAmortization_data.xsql
---
(0035543)
maite   
2011-04-04 13:39   
verified