Project:
View Revisions: Issue #15720 | [ All Revisions ] [ Back to Issue ] | ||
Summary | 0015720: Not possible to define SQLDescription for Amortization table filtering by @Line@ | ||
Revision | 2011-03-21 16:29 by maite | ||
Steps To Reproduce | 1. 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 |
||
Revision | 2011-02-17 18:25 by maite | ||
Steps To Reproduce | 1. Go to Financial Management || Accounting || Setup || Accounting Schema || Accounting Schema >> Account Schema Tables : 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 3. Financial Management || Assets || Assets || Assets >> Asset Amortization : specify asset amortization 4. Financial Management || Assets || Amortization || Header : create amortization 5. Financial Management || Assets || Amortization || Header >> Line: add line using your asset 6. Process and post amortization. realize that your description is not being used 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@" then when re-posting amortization your description is used. Should be reviewed is same happen with other tables |
Copyright © 2000 - 2009 MantisBT Group |