Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

AP Invoice status is Open but the Unapplied Amount is 0

Posted on by 88

We have a situation where an invoice status is Open but there is no apply information in the Apply Zoom. 

pastedimage1662024384470v1.png

We've performed Check Links and Reconcile but nothing gets kicked out. 

I am unable to void the Open Trx as we get the partially applied error  I've identified there are stranded payment records in the PM20100 & PM10200.  But if I delete those records, perform check links the Invoice is sent to history but still has no apply info

I think I've found the resolution but want to know if anyone can think of any reason this might be a bad idea.  I've done it in the TEST environment and it seems fine

I ran the following script to update the CURTRXAM to = the amount of the invoice.  Then when I ran checklinks the following records get kicked out which seems to be what I want.

pastedimage1662024538239v2.png

I'm then able to go in and void the Open Transaction and void it so I can re-enter it and pay it.  

Can anyone think of anything I'm overlooking that might come back to haunt me later down the road?

Thanks in advance for your help!

Categories:
  • Suggested answer
    RE: AP Invoice status is Open but the Unapplied Amount is 0

    Looks good.  Updating the CURTRXAM on the invoice and then getting rid of those phantom apply records (either directly in SQL or by running check links) is correct.   The steps above sound good.

    Cheryl

    Dynamics GP Support

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,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

Product updates

Dynamics 365 release plans