Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Removing unposted scheduled payments

Posted on by Microsoft Employee

Is posting and voiding scheduled payments our only option? Has anyone tried removing these via SQL query?

 

Thank you.

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Removing unposted scheduled payments

    Hi,

    Instead of having to deal with a long payment schedule, compress your schedule down to one payment, pay it After you set up a scheduled payment transaction, you can still change it.

    Kind regards

    Leslie

  • RE: Removing unposted scheduled payments

    "I was not able to do this. Once I zeroed the payment amounts, I received an error message that the payment amount total did not match the scheduled amount.

    I did find a solution, however. Void the original voucher, then go back into Scheduled Payments entry and look up the schedule. You will be given a message with the option to delete the schedule."

    FYI... my answer was in response to this posting.

  • RE: Removing unposted scheduled payments

    This did not work for me.  Maybe because I had already posted some of the recurring payments.  Now, I have voided everything, but still have an open schedule that can't be deleted.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Removing unposted scheduled payments

    As I mentioned earlier, while you changed the payment to zero, you also need to distribute the same amount to any other installment. Otherwise, it will through the error "payment amount total did not match the scheduled amount".

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Removing unposted scheduled payments

    I was not able to do this. Once I zeroed the payment amounts, I received an error message that the payment amount total did not match the scheduled amount.

    I did find a solution, however. Void the original voucher, then go back into Scheduled Payments entry and look up the schedule. You will be given a message with the option to delete the schedule.

    Thanks all.

  • Suggested answer
    soma Profile Picture
    soma 24,406 on at
    RE: Removing unposted scheduled payments

    You can  not delete the scheduled Payable payment once you posted. You need to post and void the same.

    But, you can do one more thing with adjusting the amount to any other installments.

    1. Just go to the Payables Scheduled Payment Entry window(Transaction-->Purchasing-->Scheduled Payment), then select the Scheduled Number which you need to correct.

    2. Then click the Amortization button and now delete the amount(Make it zero) in Payment Amount column and adjust the amount to any other scheduled payment installment.

    3. Now close this window and click Save.

    4. Then go to Post Scheduled Payment window and post the payment which you have make it zero.

    5. After posting it will create a JV with zero amount and it wont affect anything on the vendor & GL balance.

    Note: You can follow above my steps to correct the posted scheduled payments with adjusting the amount to any other installment. But, you can not remove the payment of particular installment. For this case you just need to post and void.

    Hope this helps!!!

  • Jothi Krishnan N Profile Picture
    Jothi Krishnan N 1,865 on at
    RE: Removing unposted scheduled payments

    Are you not able to simply delete the payment scheduled?

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

Featured topics

Product updates

Dynamics 365 release plans