Sage Accpac V5.6 error using "Period" parameter

Hi all,

 

I have created a standard report with Sales Master container and want to set a parameter for "Period" using Sage Accpac V5.6 and AI V5.6.  The Period shows as YYYY-PP and when we run the report it complains that it has to be a 2 digit entry.  We change the value to 2 digits and we get a SQL error. 

 

Has anyone seen this??  TIA for any help.

 

Terry

Views: 37

▶ Reply to This

Replies to This Discussion

Permalink Reply by Terry Gair on February 10, 2012 at 9:43pm

Crap, that should be as a "Parameter" not a filter.  I get the error as a parameter.

 

 Sorry about that.

Permalink Reply by Terry Gair on February 11, 2012 at 12:05am

Here is there error about 2 digits.  And here is the SQL error.Thanks

RSS

Follow Alchemex on twitter

Like Alchemex on facebook

This Weeks Top Content 

1 Problem - Grouping by Custom Account Groups

Problem - Grouping by Custom Account Groups
2 Picklist for Accpac SQL databases

Picklist for Accpac SQL databases
3 Possible to Rename DB name in Pervasive SQL DB Name Manager?

Possible to Rename DB name in Pervasive SQL DB Name Manager?
4 ODBC Driver selection when entering data connection details

ODBC Driver selection when entering data connection details
5 Combining Accounts in SMI financials

Combining Accounts in SMI financials

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!