RE: Remove historical vendor invoices from EFT
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?
Export the historical supplier invoices that need to be updated. Go to Transactions > Purchases > Enter Bills and filter the list to include only the invoices that you want to update. Then, click the Export button to export the invoices to a CSV file.
Open the CSV file in excel.
Add a new column to the spreadsheet and label it “Approval Status”.
In the “Approval Status” column, enter “Pending Approval” for each invoice that needs to be updated.
Save the CSV file.
Go to Transactions > Purchases > Enter Bills and click the Import CSV button.
Select the CSV file that you saved in step 5.
On the Import Options page, map the “Approval Status” column in the CSV file to the “Approval Status” field in NetSuite.
Click the Import button to import the CSV file.
Good luck 🙂