Identify Cash Header mismatches Cash Detail

From KeystoneIntranet
Jump to navigation Jump to search


SELECT SESSION_NO,TRANS_NO,POST_DATE,CUST_NO,CHECK_NO
,CHECK_AMOUNT
,SUM(CREDIT_AMOUNT-ALLOW_AMOUNT-DISC_AMOUNT) Sum_Cash_Det
,CHECK_AMOUNT-SUM(CREDIT_AMOUNT-ALLOW_AMOUNT-DISC_AMOUNT) Sum_Discrep
,SUM(CREDIT_AMOUNT) Sum_Credit
,SUM(DISC_AMOUNT) Sum_Disc,SUM(ALLOW_AMOUNT) Sum_Allow
FROM ARTCSHHD,ARTCSHDT
WHERE 
ARTCSHHD.SESSION_NO=ARTCSHDT.SESSION_NO
AND
ARTCSHHD.TRANS_NO=ARTCSHDT.TRANS_NO
GROUP BY SESSION_NO,TRANS_NO,POST_DATE,CUST_NO,CHECK_NO,CHECK_AMOUNT
HAVING CHECK_AMOUNT-SUM(CREDIT_AMOUNT-ALLOW_AMOUNT-DISC_AMOUNT)<>0