NetSuite - How to create a Saved Search / report that will show Cash Sales Dates and Deposit Dates

Cash Sale transactions are setup to go to un-deposited funds. The deposits are done once a month at a later date. There are instances that the user in error enters a deposit date that could go to a past date or a future date that makes the bank reconciliation difficult.

1. Navigate to List> Search> Save Searches > New 

2. Select Transactions

3. Navigate to Criteria tab > Standard subtab

4, Select Type > Select Deposit > Click Set

5. Select d From > is any > Select Cash Sale (you will need to choose a specific cash sale or a range from the list of cash sales) > Click Set

6. Navigate to  Results tab

7. Select Date

*This is the Date when the Cash Sale was deposited.

8. Select Applied to Transactions Fields > Select Date > Click Add

*This is the Date of the Cash Sale

9. Click Preview