Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Payables Invoice in OPEN - Inquiry Window Shows Applied

Posted on by Microsoft Employee

Hello:

In GP 2013 R2, an end user of ours cut a payables check today for several open invoices for a vendor.

Although she tried to pay an open invoice for this vendor, upon building this check batch, GP would not let her pay this one particular invoice.  This invoice would not even show as available for selection, in the Edit Payables Check Batch window. 

I did not get the chance to look at this with her, before she left for the day.

So, just now, I reviewed the check that she printed and posted and the invoices that the check was applied to.  All of these documents are in history, according to the Payables Transaction Inquiry - Vendor window.  Also, this check is showing as having paid all of its invoices and the check amount is accurate.  But, this one invoice is not listed.

This one invoice that GP would not let her pay is the only invoice of this vendor that is in OPEN status.  The Unapplied Amount shows as $0.00.  But, when I drill back on the Unapplied Amount link, no check is showing as ever having been applied to this invoice.

When I go to the Void Open Transactions window, pull up this invoice, and check the "Void" box, I get a message saying that this document cannot be voided as it has been either paid or partially applied.

When I go into the Apply Payables Documents window for this vendor, there is no Payment, Return, or Credit Memo to pull up.

This invoice is only in the PM20000 table and not in either the PM30200 or PM30300 table.  This $70.00 invoice displays, in PM20000, as $70.00 for the Document Amount but $0.00 for the Current Transaction Amount.

There is no data for this vendor in either the PM20100 table or in the PM10200 table.  Also, I looked at this invoice in the PM00400 table, and the status there simply shows as open.  Nothing appears out of the ordinary, in PM00400.

Is the remedy to simply update the invoice's record in the PM20000 table to have the Current Transaction Amount = the Document Amount and then run Check Links on the Payables Transaction Logical File?  If not, then what is the remedy?

Thank you!  Much appreciated!

John

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payables Invoice in OPEN - Inquiry Window Shows Applied

    Oh, and I also updated the DINVPDOF field to equal '01/01/1900'.

    Anyway, after running both of these scripts, the user was able to print and post the check just fine.  The Aged Trial Balance for the vendor was accurate, afterward, as well.  And, the inquiry window showed the data for the vendor to be correct!  

    John

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Payables Invoice in OPEN - Inquiry Window Shows Applied

    Here was the solution.  I simply updated the invoice's record in the PM20000 table to have the Current Transaction Amount = the Document Amount.

    In my research, I found that if I had afterward ran Check Links on the Payables Transaction Logical File, the invoice would have been moved to history and that would have made the situation worse.  :)

    Thanks!

    John

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans