Administrators and users may notice inconsistencies when reviewing billable expense reports in NetSuite’s Expense Report List View. In some cases, the Billable column displays “No” even though one or more expense lines within the report are marked as billable.
This article explains why this behavior occurs, identifies the system limitation involved, and provides an alternative solution using a saved search.
Scenario
When viewing expense reports under: Transactions > Employees > Enter Expense Reports > List, the Billable column may display “No” even when the expense report contains billable expense lines.
However:
- Opening the expense report record itself shows the expense line correctly marked as Billable
- The billable flag is functioning properly at the line level
- The inconsistency only appears in the List View
Explanation
NetSuite has confirmed this behavior as a system limitation.
The Billable field shown in the Expense Report List View does not evaluate billable status at the individual expense line level. Instead, the list view references summary-level transaction data, which may not accurately reflect the billable information contained within the expense report.
As a result:
- Expense reports with billable lines may still display as non-billable in the List View
An enhancement request has already been submitted to NetSuite engineering: Enhancement ID: 731326 Expenses > Exp reports > All > List view columns > Have a column that indicates if the expense report is billed.
Recommended Workaround
As an alternative solution, administrators and users can create a Saved Search to accurately display billable information at the expense line level.
Step 1: Create a New Transaction Saved Search
- Navigate to: Lists > Search > Saved Searches > New
- Select: Transaction
Step 2: Configure Criteria
Under the Criteria tab, add the following filters:
Field | Value |
|---|
Type | Expense Report |
Main Line | False |
Employee | Desired Employee (optional) |
Note: The Employee field can also be added under the Available Filters tab for dynamic filtering.
Step 3: Configure Results
Under the Results tab:
- Add the Billable field
- Remove any unnecessary fields
- Add additional columns as needed, such as:
- Employee
- Date
- Amount
- Customer/Project
Step 4: Save and Run
The saved search will now display billable information accurately at the expense line level.