Scenario
A user needs to create a saved search that displays Deposit transactions together with their associated Customer Deposit payments. While reviewing deposit transactions, the user noticed that the related payment information is visible on the transaction itself but was unable to replicate this relationship in a saved search.
The user was able to successfully create a saved search showing the payment transaction and its associated deposit using the Applying Transaction field. However, the reverse requirement, displaying the Deposit transaction along with its related payment, could not be achieved.
Solution
Create a Transaction Saved Search using the following setup:
- • NetSuite: Go to Reports > Saved Searches > All Saved Searches > New
• NetSuite Next: Click Explore (hamburger icon in the bottom left corner beside the home button). In the menu, go to Reports and analytics > Saved Searches > All Saved Searches > New Saved Search
- Select Transaction as the search type.
- In the Criteria tab:
- Add Type is Deposit
- Add a Date filter to limit the number of results returned
- In the Results tab:
- Add the field Applied To Transaction
This configuration will display the Deposit transaction together with the associated payment transaction.
-----
If you find this information useful, let us know by reacting or commenting on this post!