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

Advanced 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

Advanced 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

To change the approval status on historical supplier invoices from “Approved” to “Pending Approval” to remove them from EFT Bill payments, you’ll need to follow these steps:

  1. Access the historical supplier invoices in your accounting or invoicing system.
  2. Locate the invoices that need to be changed to “Pending Approval.”
  3. Depending on your system, you may be able to bulk update the approval status of these invoices or update them individually.
  4. Change the approval status of each invoice to “Pending Approval” to ensure they are not included in EFT Bill payments.
  5. Once the invoices have been reviewed and approved, they can then be processed for bill payment.

If your system doesn’t allow for bulk updates or if you encounter any issues during the process, you may need to consult with your system administrator or support team for assistance.

By following these steps, you should be able to achieve your goal of removing historical supplier invoices from EFT Bill payments until they have been properly reviewed and approved.

Rookie Answered on May 10, 2024.
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   SuiteMigration   Become a Sponsor