Scenario
The user wanted to identify Customer Deposits that are applied to Invoices. However, since only Deposit Application records are directly linked to the Invoice and appear under the Related Records tab, the user is having difficulty identifying the exact Customer Deposits applied to each Invoice.
Solution
To create a Saved Search that will show Customer Deposits applied to Invoices, follow the steps below:
- Navigate to Report > Saved Searches > All Saved Searches > New > select Transaction as Search Type
- Add a Search Title
- In Criteria tab > Standard subtab, add the following:
- Type is Deposit Application
- Main Line is False
- Applying Transaction: Type is Invoice
- In Results tab > Columns subtab, add the following:
- Name
- Applied To Transaction: Date
- Applied To Transaction (set Custom Label as Invoice)
- Created From (set Custom Label as Customer Deposit)
- Applied To Link Amount (set Custom Label as Applied Amount)
- Click Save
You can further customize the report and add additional fields from the Results tab as needed.
-----
If you find this information useful, let us know by reacting or commenting on this post!