Do you mean the Standard General Ledger Transaction Detail 3-4 (AE-SQL)?

This report is version simple.  

Have you modified something in container?

I created my own report and used this container.   I added a couple of parameters, select fiscal year and select fiscal periods.

I just ran the canned report - no changes and it gave the same error when selecting fiscal 2019

Understand. Please double check your parameters. Or Expression (Excel type).
You may use as compare between Sage Date (yyyymmdd, String) with a Date value.

The parameters are fine - Select year - option is to select one fiscal year based on the fiscal years of history in the GL.   Select a starting period, select an ending period - 01 to 12.   What I can't understand is the report runs out if I select 2018 but errors if I select 2019?

You can email me your report to [email protected]

Thanks for the offer Marius.   I found the problem, it was a corrupt record in the database - the date format was wrong.   Not sure how it happened but once I found the record, updated it with the correct format in SQL, then re-ran the report it worked fine.   Now I just have to do the same fix on the client's live data.

Thanks again.