web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Voided Check
Microsoft Dynamics GP (Archived)

Voided Check

(0) ShareShare
ReportReport
Posted on by Babin 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

I have the same question (0)
  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    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.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    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

  • Babin Profile Picture
    Babin 2,961 on at

    Thanks Deanne. This is what I was looking for.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans