Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / find Invoice linked to...
Microsoft Dynamics GP (Archived)

find Invoice linked to Voided check

(0) ShareShare
ReportReport
Posted on by Babin 2,961

I issued and posted two checks for an invoice - ChK-A and ChK-B. I voided one of them ChK-A. 

Now i am trying to find original Invoice/Voucher linked to for voided check Chk-A. 

 

Is this possible to see in GP or query in SQL? 

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: find Invoice linked to Voided check

    Hi Bab,

    When you applied the check to the invoice(s) a record or records was written to the PM30300 table. That table holds all of the apply information. When you voided the check, those records were deleted because an apply no longer exists.

    Kind regards,

    Leslie

  • Babin Profile Picture
    Babin 2,961 on at
    RE: find Invoice linked to Voided check

    Soma,

    Yes I created the payment and invoice separately and applied to each other.

    So is that mean the applied details get deleted instead of moving to some tables in GP when voiding the payment/check?

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: find Invoice linked to Voided check

    Best practice is, before voiding get the applied details then void the check if you need the applied information.

    Hope this helps!!!

  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: find Invoice linked to Voided check

    I think, if you created a payment & invoice separately and applied to each other then voided the check, you can not find out the applied invoice/voucher number.

    Hope this helps!!!

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: find Invoice linked to Voided check

    Thanks for that Leslie.

    Bab, I believe that Leslie is correct, that is going to be your best best for finding the Voucher number.

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: find Invoice linked to Voided check

    Hi,

    If the check was applied in the same transaction that created the check, you might find the information by reprinting the posting journal from the original transaction.

    Kind regards,

    Leslie

  • Babin Profile Picture
    Babin 2,961 on at
    RE: find Invoice linked to Voided check

    Bill, It only tells the Payment Number linked with the voided check # but not the voucher number.  I am trying to find the voucher number here for which the voided check # was  issued.

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: find Invoice linked to Voided check

    When you voided ChK-A did you get a posting / voided transaction journal from the Purchase module?

    If you did not, then you might first consider a quick reprint of that document.  It should tell you what you need to know.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans