ANS-1579 · PURCHASE & VENDOR MANAGEMENT
How to Display Accounts Payable Transactions on NetSuite Project Records?
Learn to create a custom saved search and sublist to view vendor bills and purchase orders directly on NetSuite project or job records.
Short answer
To display Accounts Payable transactions like vendor bills on NetSuite project records, create a transaction saved search filtering for Type, Main Line, and Project. Then, configure a custom entity sublist using this search, linking it to the desired subtab on the project record. This ensures relevant financial data is readily accessible.
Scenario
Users may find that Accounts Payable transactions, such as vendor bills, are not visible or easily accessible when viewing Project or Job entity records in NetSuite. This can hinder financial oversight and reporting directly from the project context.
Solution
To display Accounts Payable transactions on Project or Job entity records, follow these steps to create a custom saved search and sublist:
Navigate to Reports > Saved Searches > All Saved Searches > New.
Select "Transaction" as the search type.
Under the Criteria tab, within the Standard subtab, add the following filters:
- Type is
Purchase Order,Bill - Main Line is
False - Project : Name/ID is
not empty
- Type is
Under the Available Filters tab, add the
Namefilter and check "Show in Filter Region".Mark the search as "Public".
Check "Available as Sublist View".
Provide a descriptive name for the search and save it.
Create a custom subtab by navigating to Customization > Forms > Subtabs > Entity tab. Set a title for the subtab and save it (this step is optional if an existing subtab is to be used).
Navigate to Customization > Forms > Sublists > Entity tab.
Locate and select the previously saved search.
Check the "Job" box to associate the sublist with job records.
Select the desired subtab where the sublist will appear on the entity record.
Save the custom sublist.
For additional information, refer to the SuiteAnswers article "View Purchase Order and Vendor Bill transactions in Project / Job entity record" (Answer ID: 33679).
Expert NetSuite Support
Need help with this NetSuite issue?
Purchase & Vendor Management consulting and configuration support
