Sage 50 US

Welcome to the Sage 50 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.

Intelligence Reporting - Sales Analysis - Filter by Sales Order Closed

Posted By Mitch5280 over 9 years ago

I added a filter that should allow filtering by "Sales Order Closed?" and I tried using = 0, 1 but I keep getting this error:

Description : [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface]Error in assignment.
Number : -2147217913
Source :
Driver Error : Unknown
SQL State : 22005

You CANNOT use TEXT like YES/TRUE/NO/FALSE either for this data/field type.

I assume I'm using the incorrect value, does anyone know what the values are:

YES =

NO =

Thanks,

Mitch

Parents

0 Peter Scully over 9 years ago

Hi All.

This problem was recently fixed in the Sales Analysis 1-7 report and was due to an incorrect data type in the container. You can download a copy of the new report at the below link.

http://www.sageintelligencecommunity.com/forum/topics/connector-module
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Peter Scully over 9 years ago

Hi All.

This problem was recently fixed in the Sales Analysis 1-7 report and was due to an incorrect data type in the container. You can download a copy of the new report at the below link.

http://www.sageintelligencecommunity.com/forum/topics/connector-module
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data

Sage 50 US

Intelligence Reporting - Sales Analysis - Filter by Sales Order Closed

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING