Scenario
This is currently logged as an Enhancement 26537. As an alternate solution, a Transaction Saved Search can be created.
Solution
- Navigate to Reports > Saved Searches > All Saved Searches > New
- Click Transaction
- Search Title: Enter Title
- Click Criteria
-
Click Standard
- Select Type
- Type: Select any of
- Select Sales Order
- Click Set
- Select Status
- Status: Select none of
- Select Sales Order:Cancelled, Sales Order:Closed, Sales Order:Pending Approval
- Click Set
- Select Amount Unbilled
- Amount Unbilled: Select greater than or equal to
- Value: Enter 1
- Click Set
-
Select Main Line
- Main Line: Select Yes
- Click Set
- Select Type
- Click Results
- Click Columns
Note: For every required field use the drop-down menu to select it and once adjusted click Add if needed.- Select Document Number
- Select Date
- Select Name
- Select Amount (Transaction Total)
- Select Amount Unbilled
-
Select Formula (Numeric)
- Formula: Enter {amount}-{amountunbilled}
- Custom Label: Enter Amount Billed
- Select Status
- Show Totals: Enter Checkmark
- Click Available Filters
- Select Date
- Show in Filter Region: Enter Checkmark
- Click Add
- Click Save & Run