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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015720
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 09. Financial managementminoralways2011-01-20 18:452011-04-04 12:56
ReportermaiteView Statuspublic 
Assigned Todalsasua 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision14103ac69e3e
ProjectionnoneETAnoneTarget Version2.50MP28
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP25SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015720: 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"
TagsNo tags attached.
Attached Filespng file icon 1.png [^] (149,026 bytes) 2011-03-21 16:30


png file icon 2.png [^] (149,971 bytes) 2011-03-21 16:30

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0016522 closedadrianromero Not possible to define SQLDescription for Amortization table filtering by @Line@ 

-  Notes
(0034254)
dalsasua (reporter)
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 (manager)
2011-03-28 18:58

 Fix done. Pending to push changes to repository 2.50 when unfrozen.
(0035454)
hgbot (developer)
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 (developer)
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 (developer)
2011-04-04 12:56

 verified

- Issue History
Date Modified Username Field Change
2011-01-20 18:45 maite New Issue
2011-01-20 18:45 maite Assigned To => dalsasua
2011-01-20 18:45 maite Modules => Core
2011-01-20 18:47 maite Proposed Solution updated
2011-02-17 18:25 dalsasua Note Added: 0034254
2011-03-21 16:29 maite Steps to Reproduce Updated View Revisions
2011-03-21 16:30 maite File Added: 1.png
2011-03-21 16:30 maite File Added: 2.png
2011-03-22 12:20 maite Issue Monitored: networkb
2011-03-28 18:57 adrianromero Status new => scheduled
2011-03-28 18:57 adrianromero Type defect => backport
2011-03-28 18:58 adrianromero Note Added: 0035284
2011-03-28 18:58 adrianromero Issue cloned 0016522
2011-03-28 18:58 adrianromero Relationship added depends on 0016522
2011-04-01 12:33 hgbot Checkin
2011-04-01 12:33 hgbot Note Added: 0035454
2011-04-01 12:33 hgbot Status scheduled => resolved
2011-04-01 12:33 hgbot Resolution open => fixed
2011-04-01 12:33 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/3e5fe652d51d9479ec7c9f1b5a37835d6dd86def [^]
2011-04-04 12:24 hgbot Checkin
2011-04-04 12:24 hgbot Note Added: 0035527
2011-04-04 12:24 hgbot Fixed in SCM revision http://code.openbravo.com/erp/stable/2.50/rev/3e5fe652d51d9479ec7c9f1b5a37835d6dd86def [^] => http://code.openbravo.com/erp/stable/2.50/rev/14103ac69e3eae970080dd746bc2aa2e93ba0b64 [^]
2011-04-04 12:56 maite Note Added: 0035534
2011-04-04 12:56 maite Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker