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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0016522
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 09. Financial managementminoralways2011-03-28 18:582011-04-05 00:00
ReporteradrianromeroView Statuspublic 
Assigned Toadrianromero 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionf7ef0a3e203b
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0016522: 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 Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks backport 00157202.50MP28 closeddalsasua Not possible to define SQLDescription for Amortization table filtering by @Line@ 

-  Notes
(0035285)
hgbot (developer)
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 (viewer)
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 (developer)
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 (viewer)
2011-04-04 13:39

 verified

- Issue History
Date Modified Username Field Change
2011-03-28 18:58 adrianromero New Issue
2011-03-28 18:58 adrianromero Assigned To => adrianromero
2011-03-28 18:58 adrianromero Modules => Core
2011-03-28 18:58 adrianromero OBNetwork customer => Yes
2011-03-28 18:58 adrianromero Issue generated from 0015720
2011-03-28 18:58 adrianromero Relationship added blocks 0015720
2011-03-28 18:59 hgbot Checkin
2011-03-28 18:59 hgbot Note Added: 0035285
2011-03-28 18:59 hgbot Status new => resolved
2011-03-28 18:59 hgbot Resolution open => fixed
2011-03-28 18:59 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/61d7922b0e9e251c1eb0173166b7923e33a56b1d [^]
2011-03-28 19:05 adrianromero Note Added: 0035286
2011-04-04 12:22 hgbot Checkin
2011-04-04 12:22 hgbot Note Added: 0035526
2011-04-04 12:22 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/61d7922b0e9e251c1eb0173166b7923e33a56b1d [^] => http://code.openbravo.com/erp/devel/pi/rev/f7ef0a3e203bde2e5bb143674ce8427a99d8d24a [^]
2011-04-04 13:39 maite Note Added: 0035543
2011-04-04 13:39 maite Status resolved => closed
2011-04-05 00:00 anonymous sf_bug_id 0 => 3274933

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker