Change Approved status to Pending Approval

Answered

Hi,

We need to change approval status on historical supplier invoices from “Approved” to “Pending Approval”.
Essentially, what we want to achieve is all historical supplier invoices to be removed from EFT Bill payments, so they can be first reviewed and only if needed go to Bill payment processing (after being approved).

Is there any way to achieve it?

Many thanks!

Beginner Asked on February 28, 2023 in Best Practices.
Add Comment
17 Answer(s)

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

Beginner Answered on March 3, 2023.
Add Comment

Hi,

You might need to set the Audience. It should look something like this but you may with to set the Audience to just Administrators, for example:

RE: Change Approved status to Pending Approval

Thanks,

Chris

Intermediate Answered on March 6, 2023.
Add Comment

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:

RE: Change Approved status to Pending Approval

Beginner Answered on March 6, 2023.
Add Comment

There was a typo in my code:

function updateApprovalStstus(rec_type, rec_id) {
    nlapiSubmitField(rec_type, rec_id, ‘approvalstatus’, 1);
}

should be:

function updateApprovalStatus(rec_type, rec_id) {
    nlapiSubmitField(rec_type, rec_id, ‘approvalstatus’, 1);
}

Thanks,

Chris

Intermediate Answered on March 6, 2023.
Add Comment

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

Beginner Answered on March 6, 2023.
Add Comment

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))

Beginner Answered on March 10, 2023.
Add Comment

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 🙂

Beginner Answered on March 10, 2023.

No problem. So pleased you’ve got it sorted!

on March 10, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor