Sorry for the delayed response – thank you very much for this. Tested and it worked!

Hi Chris,

I just typed it in (not copying) and re-saved it again and it worked!
Thank you so much for your help, really really appreciate it 🙂

Hi Chris,
Sorry for not getting back to you earlier – I have only had a chance to do the testing today. It did work first time, when I chose 1 specific invoice to start with but then when I tried another one – I again got the same error (illegal character (Approval status mass update.js#2))

Hi Chris,
Thank you for your answer.
I am now getting another error, when trying to upload the updated file to the script:
Syntax error: illegal character

Hi Chris,
Thank you for your answer. It worked this time.
I have created a mass update and performed it but got the following error message:

Hi Chris,

Thank you for your answer.
I have followed everything as you said but the Vendor Bill hasn’t appeared in Mass update under the Custom Updates drop down list. Is anything else I need to add on Script Deployment in order for it to be populated in the Custom updates?

Thank you for your help!
Daria

Hi Chris,
Sorry for the delay- didn’t have chance to test it today.
I will do tomorrow. Where can I save that Java file first, so I can upload it after? Would it be Notes?
Thank you so much for your help!

Hi Chris,
Thanks for getting back to me.
If I could update approval status from “approved” to “pending approval” on the historical supplier invoices I thought all those invoices will stop being shown on the EFT Bill Payments and will go via the approval workflow I have created.
This should hopefully save Finance lot of time as they won’t have to look for the specific approved invoices among 10000 of historical invoices on the EFT Bill Payments and manually tick the box. As only approved invoices should be shown there. Am I right?

Or it could be another way but I can’t think of anything else.

I have Sandbox, yes 🙂

Thanks again!

Hi Chris,
Many thanks for looking into it.
I am afraid I won’t be able to do scripting as not as advanced(
Is there any other way to overcome the issue?

The main issue is that Finance is doing manual approval in Excel for the historical supplier invoices and then tick the boxes on the EFT bill payments for the approved ones (sometimes it might take them whole day as there might be a lot of transactions).

Sorry, if I am not clear, I’ve been thinking about it for so many days now and probably confusing myself..

Appreciate any help here! Thank you

Hi,
Thank you for your reply. I tried updating them via CSV but as they are historical vendor invoices the approval status is locked (or could it be because I have a pending approval workflow in place?)