Unique Business Challenges and General Discussion

[lunaraven]

I am trying to print open sales orders, and/or sales order reports and get this error message

Query Engine Error 'S0000[ProvideX][ODBC Driver][FILEIO]InvalidDate content'

What does this mean?

[BShockley]

It probably means you have data in a date field that is not in the correct format.

[connex]

Have you modified the sales order form?  Have you added a non-ODBC source?

[lunaraven]

We haven't modified any of our forms and haven't selected any different dates or formats. We are going through all our open sales orders, back orders and quotes. Not sure what created so many or why some are still open but it won't let us print a report. When I try to print individual sales orders it gives me that error message, BUT if I click "Quick Print" it prints out just not in my normal sales order format.

...I wonder if its possessed?

[BigLouie]

When your reseller comes on site, what does he say about it?

[jcnichol · Accepted solution]

Hello,

The error message is indicating that there is invalid data in a date field in one or more the records in the report.  Use the ODBC Admin and access the User SOTAMAS90 data source -  on the Options Tab there is a check box titled NULL date - check it and apply the change.  The ODBC driver will now return a NULL (blank) value for any invalid dates in the query.

John

[rsifontes]

I've check the null date box and did not fix my issue.