Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cannot void AP Invoice
Microsoft Dynamics GP (Archived)

Cannot void AP Invoice

(0) ShareShare
ReportReport
Posted on by Bill B 75
We have several very old invoices in AP that I do not seem to be able to void. I have not been able to locate them in the AP sql tables either. They are very old and I would remove them with a sql statement if I could find them. Any ideas appreciated. Thanks, Bill

*This post is locked for comments

  • Bill B Profile Picture
    Bill B 75 on at
    Re: Re: Re: Re: Cannot void AP Invoice
    Thanks, we did get this resolved by doing a little AP housekeeping applying a remainder of the payment then journaling it out. So our issue is solved. I was looking in the POP tables I guess thats why I could not find the docs. Thanks for your reply. Bill
  • Rashid Farooq Profile Picture
    Rashid Farooq 1,000 on at
    Re: Re: Re: Cannot void AP Invoice
    I also could not understand as you said that you could not locate AP’s in SQL table and also want to remove using SQL. If you simply want to remove AP’s using SQL approach then find your AP’s in following SQL tables.

    SELECT *FROM PM00400

    SELECT *FROM PM20000

    SELECT *FROM PM30200

    SELECT *FROM PM30300

    SELECT *FROM PM30401

    SELECT *FROM PM30600

    SELECT *FROM PM30700

    SELECT *FROM PM30800

    After removing from above tables, run reconcile against Vendor using Microsoft Dynamics GPàUtilitiesàPurchasingàReconcile navigation

  • Bill B Profile Picture
    Bill B 75 on at
    Re: Re: Cannot void AP Invoice
    Excellent point, these were several years old, and I am guilty of feeling certainly there must be an issue with these docs. But when I verified there was an open balance and a partially applied balance. Thanks for pointing me back at the cause. Bill
  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Cannot void AP Invoice

    When you say that you cannot void, what do you mean?  Do you get an error?

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

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans