pgsql/investigations/ar-cash.sql
authorEdward <edward@roojs.com>
Wed, 5 Feb 2014 06:30:31 +0000 (14:30 +0800)
committerEdward <edward@roojs.com>
Wed, 5 Feb 2014 06:30:31 +0000 (14:30 +0800)
pgsql/investigations/ar-cash.sql

index 957449b..8bff3ef 100644 (file)
@@ -141,13 +141,13 @@ $BODY$
   LANGUAGE plpgsql VOLATILE
   COST 100;
   
-ALTER FUNCTION  x_ar_verify_creditmemo(integer)
+ALTER FUNCTION  x_ar_verify_cash(integer)
   OWNER TO admin;
 
 
     
     
-SELECT x_ar_verify_creditmemo(aropen_id) FROM aropen where aropen_doctype = 'C' order by aropen_id asc;
+SELECT x_ar_verify_cash(arapply_id) FROM arapply where arapply_source_doctype = 'K' AND arapply_target_doctype = 'I' order by arapply_id asc;