Scenario
The finance team requires enhanced filtering capabilities on the Invoice Billable Customer page to streamline billing processes. Currently, users are unable to filter invoice billable records by Department, making it difficult to isolate transactions related to specific Departments.
Solution
The fields under Additional Columns and Additional Filters on the Invoice Billable Customer page are all from the Customer sublist, which means they are fields available from the Customer record.
Under Enhancement 15880, By default, Department, Class, and Location fields are not available in the Customer records.
Since the Department field is not available on the Customer record by default, you need to create a custom entity field and add it to the Customer record.
- Navigate to Customization > Lists, Records, & Fields > Entity Fields > New
- Label: Enter Department, or Class, or Location
- Type: Select List/Record
- List/Record: Select Department, or Class, or Location
- Click Applies To
- Customer: Enter Checkmark
- Click Display
- Subtab: Select Main
- Click Save
- Then navigate to Transactions > Customers > Invoice Billable Customers
- On the top of the list of transactions, click Customize
- Select the Additional Filters tab
- Select Department, or Class, or Location
- Click Save
-----
If you find this information useful, let us know by reacting or commenting on this post!