details:   https://code.openbravo.com/erp/devel/pi/rev/3bf7e8a8b2db
changeset: 13299:3bf7e8a8b2db
user:      Gorka Ion Damián <gorkaion.damian <at> openbravo.com>
date:      Wed Jul 27 11:49:56 2011 +0200
summary:   Related to issue 17966.Fixed postgresql issue.

diffstat:

 
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
 |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (12 lines):

diff -r 39dff0d82077 -r 3bf7e8a8b2db 
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
--- 
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
     Wed Jul 27 11:43:14 2011 +0200
+++ 
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_GEN_PAYMENTSCHEDULE_INV.xml
     Wed Jul 27 11:49:56 2011 +0200
@@ -246,7 +246,7 @@
                    fixmonthday, fixmonthday2, fixmonthday3, netdays,
                    fixmonthoffset, netday, isnextbusinessday
             FROM c_paymentterm
-            WHERE c_paymentterm_id=v_paymentterm);
+            WHERE c_paymentterm_id=v_paymentterm) a;
         FOR cur_payments IN (
             SELECT line, percentage, onremainder, excludetax,
                    COALESCE(paymentrule, v_paymentrule) AS paymentrule,

------------------------------------------------------------------------------
Got Input?   Slashdot Needs You.
Take our quick survey online.  Come on, we don't ask for help often.
Plus, you'll get a chance to win $100 to spend on ThinkGeek.
http://p.sf.net/sfu/slashdot-survey
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to