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) / AP Apply
Microsoft Dynamics GP (Archived)

AP Apply

(0) ShareShare
ReportReport
Posted on by Community Member

A vendor was paid using a credit card in Manual Check entry and the payment was applied in full to an open invoice. Both the invoice and the payment are fully applied. However, both are still showing on the Computer Check Edit List every time we run it. When I look in the SQL tables I can see the apply information in both PM20100 and PM30300. But the transaction is in PM30200 not PM20000. Do I need to delete the apply information out of PM20100 or is there a process in GP that will correct this?

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: AP Apply

    I played around a bit more and found that you can run a computer check batch and select the specific vendor in the Select Checks window. When you print checks it will print a remittance for the vendor. After you post the checks the apply is removed from the PM20100 table.

  • Community Member Profile Picture
    Community Member on at
    Re: AP Apply

    Thanks, Richard,

    But, there is really nothing wrong with the transactions. It is simply the way GP is handling the applies.  When you manually apply a document it updates the PM20100 table and the PM30300 table with the apply information.

    GP does not remove the apply information from the PM20100 table until you run a computer check for the vendor. It is in the PM20100 table so that it will print on the next computer check that you issue to the vendor.

    In this instance, the vendor was paid by a manual payment in the form of a credit card that was applied to an invoice and there doesn't appear to be a way to remove the apply information out of the PM20100 table except by deleting it in SQL.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: AP Apply

    The PM30200 table is history where the other tables are open.  It appears the transaction has been split.  This has been shown to occur when a payment is applied to an invoice fully paying off the invoice (as you did) and then the work station is turned off or accidentally shut down without closing the payment apply task.  Yes, corrections need to be made through SQL, removing entries in history and restoring open entries to a normal unpaid or unapplied state.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,407 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans