Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
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,947

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,947 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,406 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,406 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 22,647 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,947 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 22,647 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

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans