details: /erp/stable/2.50/rev/ed0418b01ffc
changeset: 9446:ed0418b01ffc
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Fri May 20 08:58:37 2011 +0200
summary: Fixes issue 17285: Report Cashflow Forecast links are not working.
diffstat:
src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_data.xsql | 8
++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diffs (29 lines):
diff -r 5cc4710b30ca -r ed0418b01ffc
src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_data.xsql
--- a/src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_data.xsql
Thu May 19 17:26:30 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_data.xsql
Fri May 20 08:58:37 2011 +0200
@@ -132,10 +132,10 @@
TO_CHAR(I.DATEINVOICED,TO_CHAR(?)) AS DATEINVOICED,
c_currency_convert(DP.AMOUNT, dp.C_CURRENCY_ID,
ba.c_Currency_ID, dp.dateplanned,null, ba.ad_client_id, ba.ad_org_id) AS AMOUNT,
(CASE WHEN DP.C_Invoice_ID IS NOT NULL
- THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesInvoice/Payment_Relation.html' WHEN 'N' THEN
'PurchaseInvoice/Payment_Relation.html' END)
+ THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesInvoice/PaymentIn_Relation.html' WHEN 'N' THEN
'PurchaseInvoice/PaymentOut_Relation.html' END)
ELSE
CASE WHEN DP.C_Order_ID IS NOT NULL
- THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesOrder/Payment_Relation.html' WHEN 'N' THEN
'PurchaseOrder/Payment_Relation.html' END)
+ THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesOrder/PaymentIn_Relation.html' WHEN 'N' THEN
'PurchaseOrder/PaymentOut_Relation.html' END)
ELSE
CASE WHEN DP.C_Settlement_Generate_ID IS NOT NULL
THEN 'Settlement/CreatedPayments_Relation.html'
@@ -207,10 +207,10 @@
TO_CHAR(I.DATEINVOICED,TO_CHAR(?)) AS DATEINVOICED,
c_currency_convert(DP.AMOUNT, dp.C_CURRENCY_ID,
ba.c_Currency_ID, dp.dateplanned,null, ba.ad_client_id, ba.ad_org_id) AS AMOUNT,
(CASE WHEN DP.C_Invoice_ID IS NOT NULL
- THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesInvoice/Payment_Relation.html' WHEN 'N' THEN
'PurchaseInvoice/Payment_Relation.html' END)
+ THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesInvoice/PaymentIn_Relation.html' WHEN 'N' THEN
'PurchaseInvoice/PaymentOut_Relation.html' END)
ELSE
CASE WHEN DP.C_Order_ID IS NOT NULL
- THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesOrder/Payment_Relation.html' WHEN 'N' THEN
'PurchaseOrder/Payment_Relation.html' END)
+ THEN (CASE ISRECEIPT WHEN 'Y' THEN
'SalesOrder/PaymentIn_Relation.html' WHEN 'N' THEN
'PurchaseOrder/PaymentOut_Relation.html' END)
ELSE
CASE WHEN DP.C_Settlement_Generate_ID IS NOT NULL
THEN 'Settlement/CreatedPayments_Relation.html'
------------------------------------------------------------------------------
What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
