Delete Payment Schedules

[ImIronMan]

Hi ,

We have around 900 payment schedules in FNMS and would like to delete all of them (excluding couple of vendors) and create new payment schedules. Finding it real difficult to browse each contract and then delete payment schedule and it seems there is no 'Delete' option on 'All Payments' page either

Is they any way/script to delete multiple payment schedules (excluding few vendors like 'microsoft') in one go

[mfranz · Accepted solution]

The stored procedure PaymentScheduleRemoveBatch could be what you're looking for.

[ImIronMan]

@mfranz 

Thanks for your quick responses.

If you can spare couple of minutes, can I ask you to share the query/steps to exclude a particular publisher.

Just not that good at SQL 🙂

Thanks in advance

[mfranz]

Hi Rajesh,

The complete code would be more than I can currently contribute here. What I noticed from looking at the tables is that the payment schedules and payment plans do not seem to have any links to publishers. So I guess you'll have to join to following  tables:

• Vendor
• Contract
• PaymentSchedule
• PaymentScheduleDetail

That should enable you to filter for payments/schedules related to specific publishers.

If you're interested in some SQL, there is a neat little cource at sololearn: https://www.sololearn.com/Course/SQL/

Best regards,

Markward

PS: I can get you in contact with Softline sales, if you're interested in some consulting work. 😉

[ImIronMan]

Hi Markward, Thank you for your suggestions and will be in touch with you if required.

Appreciate your contribution to the community 🙂

Regards

Rajesh