Identify Cash Header mismatches Cash Detail

From KeystoneIntranet
Revision as of 12:58, 14 July 2023 by WikiAdmin (talk | contribs) (1 revision imported)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
Retrieved from "http://in.compucrete.com/index.php?title=Identify_Cash_Header_mismatches_Cash_Detail&oldid=262"