Show Purchase Orders and Vendor Bills Under Related Records of Project/Job Record When Projects on Sales Transactions Are Not Consolidated

Purchase transactions (Purchase Orders and Vendor Bills) are not directly associated with Project entities because they are part of the Accounts Payable module and not the Advanced Project Management module of NetSuite. This is being reproducible when Accounting Preference Consolidate Projects on Sales Transactions is disabled.

1. Navigate to Lists > Relationships > Projects
2. Click View a Project record
3. Click Related Records tab
4. Click Transactions subtab
5. Result: Vendor Bills and Purchase Orders associated with existing Project/Job are not displayed. Only sales transactions are listed (Sales Orders, Invoices).

Enhancement 135548 was filed to request for the purchase transactions to appear in the Transactions subtab of the Project/Job records.

User may either consider enabling the Accounting Preference Consolidate Projects on Sales Transactions.

Or as an alternate solution user may create a custom sublist that will pull up these transactions in the Project record.

I. Create a Saved Transaction Search

1. Navigate to Lists > Search > Saved Searches > New
2. Click Transaction Search Type
3. Search Title: Enter Title
4. Public: Enter Checkmark
5. Available as Sublist View: Enter Checkmark
6. Click Criteria tab
7. Click Standard subtab
8. Filter:
   Note: For every required field use the drop-down menu to select it and once adjusted click Set if needed.
   
   • Select Type
   • Type: Select any of
   • Select Purchase Order, Bill
   • Select Main Line
   • Main Line: Select False
   • Select Project Fields...
   • Project Filter: Select Name/ID
   • Name/ID: Select is not empty
9. Click Available Filters tab
10. Filter:
    
    • Select Name
    • Show in Filter Region: Enter Checkmark
    • Click Add
11. Click Results tab
12. Click Columns subtab
    Note: Select all columns/fields as required to be shown on the new custom sublist. For every field use the drop-down menu to select it and once adjusted click Add if needed.
13. Click Save & Run

1. Navigate to Customization > Forms > Subtabs  > New
2. Title: Enter Title of the new subtab
   Example: Related Bills & Purchase Orders
3. Click Save

1. Navigate to Customization > Forms > Sublists
2. Click Entity tab
3. Search: Select the Search from step I
4. Label: Enter the Label of sublist
5. Tab: Select Related Records (or other tab where the sublist should show up)
6. Job: Enter Checkmark
7. Click Save