## Documentation Index

Access the complete documentation index at:
https://www.zoho.com/ca/books/kb/llms.txt

Use this file to discover all available documentation pages before proceeding.

[Back](./)

# How do I view records that have an empty value in specific fields?

You can use a custom view to filter records that have an empty value in a specific field. Let’s understand this better with the help of a scenario.

**Scenario:** Patricia, a purchasing manager, manages material orders for production at her manufacturing company. Upon receiving a raw material request from production, she creates a purchase order in Zoho Books, which she sends to the vendor. The vendor fulfills the order and returns an invoice, occasionally without the order number, which Patricia records as a bill. To identify such bills, Patrcia creates a custom view with the condition “Order Number is empty” in the Bills module. She then adds the Order Number to those invoices.

To create a custom view to filter records that have an empty value:

*   Go to the module for which you want to create a custom view.
*   Click the _All Bills_ dropdown (the dropdown name will change based on the module) at the top of the page and select **\+ New Custom View**.

![Click + New Custom View from the dropdown](/books/kb/images/general/new-custom-view.png)

*   Enter the name of the custom view in the **Name** field.
*   Enter the criteria in the _Define the Criteria_ section (**Order Number is empty** in this case).
*   Click **Save**.

![Enter the criteria for the custom view](/books/kb/images/general/custom-view-criteria.png)

A custom view will be created which displays records with empty values (in this case, bills not having an order number).

* * *