2,961
Which table holds the check that are voided?
The payment/check information doesn't exists in PM30300 table anymore. Does the record move into different table after the check being voided?
*This post is locked for comments
You should look at Victoria Yudin's website (www.victoriayudin.com)
Here's a query for the check register - this shows voided and not voided
SELECT T.CHEKBKID Checkbook_ID,
T.CMTrxNum Trx_Number,
D.DOCABREV Trx_Type,
T.TRXDATE Trx_Date,
T.GLPOSTDT GL_Posting_Date,
T.paidtorcvdfrom Paid_To_Received_From,
CASE
WHEN T.CMTrxType in (1,2,5,101,102)
THEN T.Checkbook_Amount
WHEN T.CMTrxType = 7 AND X.CMCHKBKID = X.CMFRMCHKBKID
THEN T.Checkbook_Amount*0
WHEN T.CMTrxType = 7 AND T.CHEKBKID = X.CMCHKBKID
THEN T.Checkbook_Amount
WHEN T.CMTrxType = 7 AND T.CHEKBKID = X.CMFRMCHKBKID
THEN T.Checkbook_Amount*-1
ELSE T.Checkbook_Amount*-1
END Checkbook_Amount,
T.CURNCYID Currency_ID,
T.DSCRIPTN 'Description',
T.ClrdAmt Cleared_Amount,
CASE T.Recond
WHEN 1 THEN 'Yes'
ELSE 'No'
END Reconciled,
T.AUDITTRAIL Audit_Trail,
CASE T.VOIDED
WHEN 1 THEN 'Yes'
ELSE 'No'
END Voided
FROM CM20200 T
LEFT OUTER JOIN
CM20600 X
ON T.Xfr_Record_Number = X.Xfr_Record_Number
INNER JOIN CM40101 D
ON D.CMTrxType = T.CMTrxType
PM30300 is the History Apply Table so this shows what the check was applied to. The PM30200 table should be what you are looking for. That is the Historical/Paid transactions table.
Edit: To further clarify, once the check is voided, it is no longer applied to anything and that's why you wouldn't see it in the PM30300 table any longer.
Share
Report
All responses (
Answers (
