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
‎Nov 03, 2020 07:44 AM
The stored procedure PaymentScheduleRemoveBatch could be what you're looking for.
‎Nov 03, 2020 07:53 AM
The stored procedure PaymentScheduleRemoveBatch could be what you're looking for.
‎Nov 03, 2020 07:53 AM
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
‎Nov 03, 2020 11:22 AM
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:
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. 😉
‎Nov 04, 2020 03:48 AM
Hi Markward, Thank you for your suggestions and will be in touch with you if required.
Appreciate your contribution to the community 🙂
Regards
Rajesh
‎Nov 04, 2020 05:56 AM