Error: "Invalid date - the start date must be between ..." when trying to run a general ledger report between two fiscal years.

Summary

You would like to have a report of the general ledger between two fiscal years.

Description


Cause

  • By design, you can only run the general ledger report for 1 fiscal year at a time

Resolution

Workaround:

  1. Go to Reports and click on General Ledger report under Financials.
  2. Enter the Start date and put the last fiscal year ending date as the Finish date.
  3. Open the report and select the option to Export or Open in Excel.
  4. Go to Reports and click on the General Ledger report under financials for a second time.
  5. For the dates, enter the Current Fiscal Year Start and Finish dates.
  6. Export the report into Excel using the same options as Step 3.
  7. You will need to manually combine the two reports in the Excel spreadsheet.

Solution Properties

Solution ID
230517172057053
Last Modified Date
Wed May 17 18:01:52 UTC 2023
Views
0