details:   /erp/devel/pi/rev/61d7922b0e9e
changeset: 11386:61d7922b0e9e
user:      Adrián Romero <adrianromero <at> openbravo.com>
date:      Mon Mar 28 18:58:49 2011 +0200
summary:   Fixes issue 0016522: Not possible to define SQLDescription for 
Amortization table filtering by @Line@
Now DocLineAmortizationData retrieves the A_AMORTIZATIONLINE_ID field

diffstat:

 src/org/openbravo/erpCommon/ad_forms/DocLineAmortization_data.xsql |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r ff10593fc411 -r 61d7922b0e9e 
src/org/openbravo/erpCommon/ad_forms/DocLineAmortization_data.xsql
--- a/src/org/openbravo/erpCommon/ad_forms/DocLineAmortization_data.xsql        
Mon Mar 28 18:38:46 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_forms/DocLineAmortization_data.xsql        
Mon Mar 28 18:58:49 2011 +0200
@@ -24,7 +24,7 @@
     <Sql>
       <![CDATA[
         SELECT A_AMORTIZATIONLINE.AD_ORG_ID, A_AMORTIZATIONLINE.LINE, 
A_AMORTIZATIONLINE.AMORTIZATIONAMT, A_AMORTIZATIONLINE.C_CURRENCY_ID,
-        A_ASSET.M_PRODUCT_ID, A_AMORTIZATIONLINE.A_ASSET_ID
+        A_ASSET.M_PRODUCT_ID, A_AMORTIZATIONLINE.A_ASSET_ID, 
A_AMORTIZATIONLINE.A_AMORTIZATION_ID
         FROM A_AMORTIZATIONLINE, A_ASSET
         WHERE A_AMORTIZATIONLINE.A_ASSET_ID = A_ASSET.A_ASSET_ID
         AND A_AMORTIZATIONLINE.A_AMORTIZATION_ID =?

------------------------------------------------------------------------------
Create and publish websites with WebMatrix
Use the most popular FREE web apps or write code yourself; 
WebMatrix provides all the features you need to develop and publish 
your website. http://p.sf.net/sfu/ms-webmatrix-sf
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to