Microsoft Dynamics GP (Archived)

Removing unposted scheduled payments

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (7)

Answers (0)

Jothi Krishnan N 1,895 on at

Like (0)

Report

Are you not able to simply delete the payment scheduled?

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Michael Stewart on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Michael Stewart on at

Like (0)

Report

"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.

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No