web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

AP Invoice status is Open but the Unapplied Amount is 0

(0) ShareShare
ReportReport
Posted on by 90

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:
I have the same question (0)
  • Suggested answer
    Cheryl Waswick Profile Picture
    Microsoft Employee on at

    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 617

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 461 Super User 2026 Season 1

#3
Syed Haris Shah Profile Picture

Syed Haris Shah 298 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans