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!

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

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

Rookie 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

Rookie Answered on March 6, 2023.
Add Comment

Copying and pasting from here can be a bit odd. Please make sure it is copying a single quote character:


function updateApprovalStatus(rec_type, rec_id) {

nlapiSubmitField(rec_type, rec_id, 'approvalstatus', 1);

}

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

Rookie 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 🙂

Rookie 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   Limebox   Become a Sponsor   Become a Sponsor