Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015720Openbravo ERP09. Financial managementpublic2011-01-20 18:452011-04-04 12:56
Reportermaite 
Assigned Todalsasua 
PriorityhighSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP25 
Target Version2.50MP28Fixed 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
Summary0015720: 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
depends on defect 0016522 closed adrianromero Not possible to define SQLDescription for Amortization table filtering by @Line@ 
Attached Filespng 1.png (149,026) 2011-03-21 16:30
https://issues.openbravo.com/file_download.php?file_id=3722&type=bug
png

png 2.png (149,971) 2011-03-21 16:30
https://issues.openbravo.com/file_download.php?file_id=3723&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2011-01-20 18:45maiteNew Issue
2011-01-20 18:45maiteAssigned To => dalsasua
2011-01-20 18:45maiteModules => Core
2011-01-20 18:47maiteProposed Solution updated
2011-02-17 18:25dalsasuaNote Added: 0034254
2011-03-21 16:29maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1653#r1653
2011-03-21 16:30maiteFile Added: 1.png
2011-03-21 16:30maiteFile Added: 2.png
2011-03-22 12:20maiteIssue Monitored: networkb
2011-03-28 18:57adrianromeroStatusnew => scheduled
2011-03-28 18:57adrianromeroTypedefect => backport
2011-03-28 18:58adrianromeroNote Added: 0035284
2011-03-28 18:58adrianromeroIssue cloned0016522
2011-03-28 18:58adrianromeroRelationship addeddepends on 0016522
2011-04-01 12:33hgbotCheckin
2011-04-01 12:33hgbotNote Added: 0035454
2011-04-01 12:33hgbotStatusscheduled => resolved
2011-04-01 12:33hgbotResolutionopen => fixed
2011-04-01 12:33hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/3e5fe652d51d9479ec7c9f1b5a37835d6dd86def [^]
2011-04-04 12:24hgbotCheckin
2011-04-04 12:24hgbotNote Added: 0035527
2011-04-04 12:24hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.50/rev/3e5fe652d51d9479ec7c9f1b5a37835d6dd86def [^] => http://code.openbravo.com/erp/stable/2.50/rev/14103ac69e3eae970080dd746bc2aa2e93ba0b64 [^]
2011-04-04 12:56maiteNote Added: 0035534
2011-04-04 12:56maiteStatusresolved => closed

Notes
(0034254)
dalsasua   
2011-02-17 18:25   
Please notice that the description "SELECT @Line@||'--' from dual" always writes -- as description, even if the lines of the amortization where created using the "Create Amortization" process in asset header window.
(0035284)
adrianromero   
2011-03-28 18:58   
Fix done. Pending to push changes to repository 2.50 when unfrozen.
(0035454)
hgbot   
2011-04-01 12:33   
Repository: erp/stable/2.50
Changeset: 3e5fe652d51d9479ec7c9f1b5a37835d6dd86def
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Mar 28 18:56:15 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/3e5fe652d51d9479ec7c9f1b5a37835d6dd86def [^]

Fixes issue 0015720: 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
---
(0035527)
hgbot   
2011-04-04 12:24   
Repository: erp/stable/2.50
Changeset: 14103ac69e3eae970080dd746bc2aa2e93ba0b64
Author: Adrián Romero <adrianromero <at> openbravo.com>
Date: Mon Apr 04 12:19:12 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/14103ac69e3eae970080dd746bc2aa2e93ba0b64 [^]

Fixes issue 0015720: 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
---
(0035534)
maite   
2011-04-04 12:56   
verified