Show the Unbilled Sales Order Amount on Open Sales Order Report for the Line Item that is Associated to the Project Only

1. Navigate to Transactions > Sales > Enter Sales Orders
-- In the Items tab, select more than one service items
-- Select/Create a project in the Project column field next to one of the service items.  Note: Not all service items are associated to the project

2. Create a Project or Transaction saved search

3. Add the following fields on the Criteria tab:
-- For Project saved search, select Transaction : Type is Sales order > add the Amount and Amount Unbilled fields in the Results tab
-- For Transaction saved search, select Type is Sales order > add the Amount and Amount Unbilled fields in the Results tab

NetSuite will show the amount per line item in the Amount field but the whole sales order amount in the Amount Unbilled field assuming the sales order is not yet invoiced/billed.

To show the unbilled sales order amount for the line item that is associated to the project only, create a custom saved report by customizing the Open Sales Order report.

      1. Navigate to Reports > Order Management > Open Sales Orders > Customize
2. Add 2 more column fields in the Edit Columns page
---In the Open Sales Orders folder, navigate to Entity (Line) subfolder >click Name
---In the Open Sales Orders folder, click Aggregate Amount
3. Navigate to Filters page > add the following:
---In the Open Sales Orders folder, navigate to Entity (Line) > click Name = Contains = :
4. Type a report name in the Name field
5. Click Preview or Save