rajeshponnala
Flexera
Flexera

Delete Payment Schedules

Jump to solution

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

 

0 Kudos
1 Solution

Accepted Solutions
mfranz
Shining star

Re: Delete Payment Schedules

Jump to solution

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

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

0 Kudos
4 Replies
mfranz
Shining star

Re: Delete Payment Schedules

Jump to solution

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

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

0 Kudos
rajeshponnala
Flexera
Flexera

Re: Delete Payment Schedules

Jump to solution

@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

0 Kudos
mfranz
Shining star

Re: Delete Payment Schedules

Jump to solution

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

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos
rajeshponnala
Flexera
Flexera

Re: Delete Payment Schedules

Jump to solution

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

Appreciate your contribution to the community 🙂

Regards

Rajesh