NetSuite Vendor(Supplier) Prepayments Saved Search Setup For Bank Account

Written by Dylan Coetzee

August 30, 2021

  1. Navigate to Payments > Bank File Generation > Generate Bill Payment File.
  2. On Select Transaction Saved Search – select “Vendor Prepayment Transactions for EP” and click on Edit Search below the field.
  3. Rename the Saved Search.
  4. On the Criteria subtab below the Vendor(Supplier) : Internal ID add the following lines.
  5. Below Vendor (Supplier) : Internal ID – is not none. Add the following configurations with brackets matching.
  6. From Account – this will be the bank account you will be making the payments from.
  7. EFT Entity Bank Format – refers to the file format for the bank account company you are paying from.
  8. Saved the saved search and use this saved search preceding vendor prepayments form the Select Transaction Saved Search from the EP EFT – Bill Payment File Generation screen.
  9. Once you have set everything up you should be able to find prepayments and resolve the Bank Account Template Error “EP_00004 : There are missing or incorrect filters in this saved search. Click the Edit Search link if you want to review the filtering criteria. For more information, see the Defining Transaction Saved Searches for Electronic Payment topic in the Help Center.” error.

You May Also Like…

NetSuite Saved Search Formulas

NetSuite Saved Search Formulas NetSuite saved formulas are a powerful tool that can be used to calculate new values...


Submit a Comment

Your email address will not be published.