ANS-0171 · SAVED SEARCHES & FORMULAS
How to Identify Unapplied Vendor Bills in NetSuite
Learn how to create a NetSuite saved search to pinpoint vendor bills that have not yet been paid or had other transactions applied.
Short answer
To identify unapplied vendor bills in NetSuite, create a transaction saved search. Use the filter 'Transaction : Applying Transaction' is none. This filter effectively isolates vendor bills that have not been paid or had any subsequent transactions applied to them, helping users manage outstanding vendor obligations efficiently.
Scenario
Organizations often need to track vendor bills that are still outstanding or have not yet been processed with a payment or other applying transaction. Identifying these unapplied vendor bills is crucial for accurate financial reporting and effective accounts payable management. This requires a method to filter out vendor bills that are awaiting further action within NetSuite.
Solution
To identify vendor bills that have not yet had a subsequent transaction, such as a payment, applied to them, a transaction saved search can be utilized. It is important to note that the vendor's invoice number is typically entered in the 'Reference No.' field on a Vendor Bill. The 'Applying Transaction' field in NetSuite saved searches, however, refers to transactions that apply to the current record, such as a payment applying to a vendor bill. Therefore, to find vendor bills that are still awaiting application, create a transaction saved search and apply the following filter:
'Transaction : Applying Transaction' is noneThis filter effectively isolates vendor bills that have not been paid or had any other applying transaction recorded against them, providing clear visibility into outstanding vendor obligations.
Expert NetSuite Support
Need help with this NetSuite issue?
Saved Searches & Formulas consulting and configuration support