Issue #9295 Issue #23537 Fix InvoiceListItem performance.

diff --git a/foundation-database/public/functions/determinediscountdate.sql b/foundation-database/public/functions/determinediscountdate.sql
index fac9d6f..76fccd5 100644 (file)
--- a/foundation-database/public/functions/determinediscountdate.sql
+++ b/foundation-database/public/functions/determinediscountdate.sql
@@ -1,5 +1,5 @@
-CREATE OR REPLACE FUNCTION determineDiscountDate(INTEGER, DATE) RETURNS DATE AS $$
--- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. 
+CREATE OR REPLACE FUNCTION determineDiscountDate(INTEGER, DATE) RETURNS DATE STABLE AS $$
+-- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
 -- See www.xtuple.com/CPAL for the full text of the software license.
 DECLARE
   pTermsid ALIAS FOR $1;

diff --git a/foundation-database/public/functions/determineduedate.sql b/foundation-database/public/functions/determineduedate.sql
index 789fc55..beb3433 100644 (file)
--- a/foundation-database/public/functions/determineduedate.sql
+++ b/foundation-database/public/functions/determineduedate.sql
@@ -1,5 +1,5 @@
-CREATE OR REPLACE FUNCTION determineDueDate(INTEGER, DATE) RETURNS DATE AS $$
--- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple. 
+CREATE OR REPLACE FUNCTION determineDueDate(INTEGER, DATE) RETURNS DATE STABLE AS $$
+-- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
 -- See www.xtuple.com/CPAL for the full text of the software license.
 DECLARE
   pTermsid ALIAS FOR $1;