Saturday, September 15, 2018

Transaction Saved Search Formula That Pulls Last Fiscal Year's Invoices To Date Minus 1 Day

1. Navigate to Reports > Saved Searches > All Saved Searches > New.

2. Click on Transaction.

3. Under Criteria tab of the Transaction search, set the following filters (Assuming that last fiscal year's start date is 11/2/2008 and current date is 11/5/2009):

- Type = Invoice
- Main Line = T
- Formula (Date); Description = is on or after 11/2/2008; Formula = {trandate}
- Formula (Date); Description = is not after 11/4/2009; Formula = {trandate}  

4. Hit Save or Preview.

No comments:

Post a Comment