Update assessfinancecharge.sql

Changes needed to fulfill Feature Request 23344 to enhance the information shown on the invcitem records for Finance Charge invoices.

diff --git a/foundation-database/public/functions/assessfinancecharge.sql b/foundation-database/public/functions/assessfinancecharge.sql
index e75b6b6..d701d61 100644 (file)
--- a/foundation-database/public/functions/assessfinancecharge.sql
+++ b/foundation-database/public/functions/assessfinancecharge.sql
@@ -164,7 +164,10 @@ BEGIN
       -1,
       NULL,
       _fc.fincharg_markoninvoice,
-      'Finance Charge Assessment',
+--    - enhance data shown in the item description for the invoice line to indicate which invoice is affected
+--    - Feature Request 23344       
+--      'Finance Charge Assessment',
+      'Finance Charge Assessment - Invoice Number ' || _ar.aropen_docnumber || ' - Past Due Balance ' || (_ar.aropen_amount - _ar.aropen_paid) || ' Due Date - ' || _ar.aropen_duedate,
       1.0,
       1.0,
       pAssessAmount,