Christopher Tame
  • Male
  • Ottawa, Ontario
  • Canada
Share

Christopher Tame's Friends

  • Mary Zimmerman

Christopher Tame's Groups

Christopher Tame's Discussions

ODBC SQL Server Driver Error
1 Reply

For two different clients the attached error is being shown when running the report.For one client the report does not occur on my machine with their DataAny thoughtsI have escalated to Sage Support…Continue

Started this discussion. Last reply by Chloe Nov 5.

SQL Date Conversion Error
8 Replies

Below is the error that is arising when I run any of the PJC reports in a clients Company.Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or…Continue

Started this discussion. Last reply by Christopher Tame Dec 1, 2017.

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'
1 Reply

Continue

Started this discussion. Last reply by Keeveshin Naidoo Dec 2, 2016.

More than one optional field per Data Line
6 Replies

In Accounts Payable two optional fields have been added per detail line of information.  The reason for adding two fields is to use them as fields to sort in a Pivot table.  The problem is that…Continue

Started this discussion. Last reply by Christopher Tame Mar 29, 2016.

 

Christopher Tame's Page

Latest Activity

Chloe replied to Christopher Tame's discussion ODBC SQL Server Driver Error
"Hi Christopher, I came across this article around working with Optional Fields in Sage Intelligence. Hope this…"
Nov 5
Christopher Tame posted a discussion

ODBC SQL Server Driver Error

For two different clients the attached error is being shown when running the report.For one client the report does not occur on my machine with their DataAny thoughtsI have escalated to Sage Support but no joy yet.See More
Oct 31
Christopher Tame replied to Christopher Tame's discussion SQL Date Conversion Error
"Thank you it turns out it was an unusual error in the Data"
Dec 1, 2017
Christopher Tame replied to Christopher Tame's discussion SQL Date Conversion Error
"Thank you I have got a query from Sage and we seem to have found the error and now it is just a question of Data Repair"
Dec 1, 2017
Shwu Hua Gan replied to Christopher Tame's discussion SQL Date Conversion Error
"Hi,  I think the problem occurs when the date = 0, especially when it is not a mandatory field. In the container, if you put in the date formula as  CASE when transactiondate = 0 else CAST(CAST(trasactionsdate as varchar) as datetime)…"
Dec 1, 2017
Keeveshin Naidoo replied to Christopher Tame's discussion SQL Date Conversion Error
"Hi Christopher, Thanks for the info. You could try running the query in SQL server directly to look for data that might be inconsistent or corrupt, although this is quite a tedious task. I know Crystal reports work a bit different compared to Sage…"
Nov 27, 2017
Christopher Tame replied to Christopher Tame's discussion SQL Date Conversion Error
"Hi Keeveshin Sorry I misunderstood your orginal message above.  It never gets to the point that it acctually creates the excell work sheet.  So there is nothing to correct.  I have attached a file that shows the point at which this…"
Nov 24, 2017
Keeveshin Naidoo replied to Christopher Tame's discussion SQL Date Conversion Error
"Hi Christopher, Just to clarify - When Excel gives you the error, a "semi-run out workbook" would be the result. The data in the "semi-run out workbook" would be the key to identifying which column needs to be changed to…"
Nov 21, 2017
Christopher Tame replied to Christopher Tame's discussion SQL Date Conversion Error
"Hi Keeveshin Sorry I should have made it clearer.  This error is when running the Intelligence report not upon the Excel import.  The imports worked fine.  Or are you saying that Excel converted a number to a date but that would have…"
Nov 21, 2017
Keeveshin Naidoo replied to Christopher Tame's discussion SQL Date Conversion Error
"Hi Christopher. This usually occurs when Excel identifies a number (this could be an account balance or even an account number: 110117 or 11-01-17 could be converted to 11 January 2017) as a potential date. Excel tries to convert the number into a…"
Nov 21, 2017
Christopher Tame posted a discussion

SQL Date Conversion Error

Below is the error that is arising when I run any of the PJC reports in a clients Company.Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.Number : -2147217913Source : Driver Error : 241SQL State : 22008The PJC Detail Cost Report was the one used.  If this report is run using the client company then this error arises.  However if this report is run against Sample Company it runs fine.The Contracts in PJC were…See More
Nov 20, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Accpac Intelligence
Website
http://www.da.ca
How long have you been using the above solution?
2 years
Where did you hear about us?
Alchemex Site

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service