Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Zero Dollar Payments still open

Posted on by 75,730

Does anyone know how I can move zero dollar AP payments into history? I was just reviewing a cash requirements report with a client and we see hundreds of zero dollar payments going all the way back to 2002. When we do a vendor inquiry and chose to view only the open payments there they all are. They have all been completely applied but yet they are still open.

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Zero Dollar Payments still open

    Running check links did not move these zero dollar payments to history. I will update the scripts for GP 2010 and let you know how it goes.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Zero Dollar Payments still open

    This is a client we have had for a long time. The person doing AP recently retired and when the replacement came in she saw all these documents on the cash requirements report. When I investigated I could see all these payments had zero left to be applied but they were still open. At this moment, I am copying their data to one of our servers so we can play. There are hundreds of these if not a thousand.  I have no idea how the previous person did this.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Zero Dollar Payments still open

    I think, I have misunderstood the question. Sorry for my previous reply.

    Please have a look on the below link.

    evarsys.com/dynamicsgp

    Hope this helps!!!

  • soma Profile Picture
    soma 24,406 on at
    RE: Zero Dollar Payments still open

    Hi Richard,

    May I know how did you applied the the zero dollar payments?

    I think, if you post any AP payments with zero dollar, it will automatically move to history. We can not apply zero dollar payments.

    Hope this helps!!!

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Zero Dollar Payments still open

    Hello Richard

    I have once faced the same issue with one of the client but on a quite narrow level, we discovered that some of the payments are stuck in the open status although they got fully applied.

    At that time, I looked around and considered a very neat script by Andy Hall, you may check it out on Dynamics GP Fully applied payments stuck in Open

    You may want to consider a test environment before running the script on such a wide range of transactions, to make sure that you are definitely on the right track.

    Your feedback is highly appreciated,

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans