Error: Invalid Date Range while running the vendor year to date analysis report.

When running the vendor year-to-date analysis report, when setting the date field for specific date in any date other than the current year, we receive the error : invalid date range.
We are currently investigating this issue and will update this article.

We can create a query to pull this information instead.
  1. Go to Query and click New
  2. Select Vendor for the type and Dynamic for the format
  3. Click OK
  4. On the Criteria tab, expand on the Summary section
  5. Select Total Payment Amount and another window should open
  6. Select Greater Than for the operator and $0 for the value
  7. Go to the Filters tab
  8. Select Payment Date and another window should open
  9. Select Between for the operator and 1/1/2017 - 12/31/2017 as the date values
  10. Click OK
  11. Go to the Output tab
  12. Expand on the Vendor section and select Vendor Name (or any other vendor fields that you'd like to see)
  13. Expand on the Query Fields section and select Total Payment Amount_1
  14. Click Run to view the results

Steps to Duplicate

1. Login to FE, go to AP.
2. Reports, Vendor Reports
3. Start a new  vendor year-to-date report. 
4. On the general tab, change the calculate vendor year to date totals as of from "today" to <specific date>
5. In the date box set any day in a previous year, and click Preview. The error will pop up instantly.


 Financial Edge

Was this article helpful?