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?

Thanks for your feedback! Did this solve your issue?

Comments (optional):

Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):

Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.