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
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
"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.
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.
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!!!
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.
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!!!
Are you not able to simply delete the payment scheduled?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156