Monday, September 17, 2018

Create a Create a report that will show Cash Sales Dates and Deposit Dates.

Cash Sale transactions are setup to go to undeposited 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 Lists > Search > Save Searches > New 

2. Select Transactions

3. Navigate to Criteria tab > Standard subtab
4, Select Type > Select Deposit > Click Set
5. Select Created 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

No comments:

Post a Comment