cancel
Showing results for 
Search instead for 
Did you mean: 

ALERT FOR INCOMING PAYMENT

Former Member
0 Kudos

Hello Experts,

How can i generate an alert for incoming payment recived?

Accepted Solutions (1)

Accepted Solutions (1)

former_member1269712
Active Contributor
0 Kudos

Hi Divya,

Whenever incoming payment transaction done by user alert will popup.

try this..

SELECT 
	N1.SERIESNAME+'-'+CAST( OC.DOCNUM AS CHAR(20))  AS 'Incoming Payment No',
	OC.DOCDATE AS 'Incoming Payment Date',
	OC.CARDNAME AS 'Customer Name',
	OC.DOCTOTAL AS 'Amount'
FROM ORCT OC
INNER JOIN NNM1 N1 ON OC.SERIES=N1.SERIES
left outer join OCRD ON oc.cardcode=ocrd.cardcode
WHERE CONVERT(VARCHAR,OC.CREATEDATE,103) = CONVERT(VARCHAR,GETDATE(), 103)

Thanks

Sachin

Answers (0)