Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Error on GL Details Report

Posted By Howard31 over 4 years ago

Error when running the GL Details report using the current year. Whenever I run this report for the current fiscal year I get - ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. If I run it on a prior year it works fine. Any ideas?

Parents

0 Howard31 over 4 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Howard31 over 4 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 300

Error on GL Details Report

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING