- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Forum
- :
- Delete Payment Schedules
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The stored procedure PaymentScheduleRemoveBatch could be what you're looking for.
This thread has been automatically locked due to inactivity.
To continue the discussion, please start a new thread.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The stored procedure PaymentScheduleRemoveBatch could be what you're looking for.
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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. 😉
- Mark as New
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Markward, Thank you for your suggestions and will be in touch with you if required.
Appreciate your contribution to the community 🙂
Regards
Rajesh
