Donna Trautmann
  • Female
  • Garden Grove, CA
  • United States
Share

Donna Trautmann's Discussions

Data Type not recognized by VBA
11 Replies

I created 2 pass through variables to accept date parameters in a SQL connector.  I set the date variable types as DBDate.  I receive an error message that the automated data type is not recognized…Continue

Started this discussion. Last reply by Desree Schravesande Jun 17.

SAGE 50 Prem Acctg US - Custom Container - Report Mgr Error
4 Replies

Hello,I am trying my hand at the SQL Query Container type in the Connector Module. I repeatedly get the error "The specified display field(s) [Jrnlhdr.TransactionDate, Jrnlhdr.JournalEx] do not exist…Continue

Started this discussion. Last reply by Donna Trautmann May 30.

 

Donna Trautmann's Page

Latest Activity

Desree Schravesande replied to Donna Trautmann's discussion Data Type not recognized by VBA
"ok, above code seems correct. Discovered that the field JournalEx is the cuase of the problem due to its data type. Cast it to an INT in the SQL Query in the Select statement, not necessary to do it in the where clause. That worked my side."
Jun 17
Donna Trautmann replied to Donna Trautmann's discussion Data Type not recognized by VBA
"SELECT Employee.EmployeeName 'Rep Name',JrnlHdr.TransactionDate 'SO Date', JrnlHdr.Reference 'SON', JrnlHdr.MainAmount 'SO Amt', JrnlHdr.MainAmount 'PO Amt',JrnlHdr.TransactionDate 'Inv…"
Jun 13
Desree Schravesande replied to Donna Trautmann's discussion Data Type not recognized by VBA
"Try casting the date in the where clause:(JrnlHdr.TransactionDate Between CAST(@FromDate@ As DATE)  And CAST(@ToDate@ as DATE)and JrnlHdr.CustomerSONo<>'')otherwise please send your full query"
Jun 13
Donna Trautmann replied to Donna Trautmann's discussion Data Type not recognized by VBA
"I have tried that.  Is your connector a SQL Query?  I can't figure out why other reports run, but this does not.  The only variable with another report is that this connector is a SQL Query.  I went ahead and retried to run…"
Jun 13
Desree Schravesande replied to Donna Trautmann's discussion Data Type not recognized by VBA
"Try changing the data type, then set it back to DBDATE again, if that doesn’t reset the lookup, remove the expression then recreate it."
Jun 12
Donna Trautmann replied to Donna Trautmann's discussion Data Type not recognized by VBA
"See attached, it will not allow a blank value."
Jun 12
Desree Schravesande replied to Donna Trautmann's discussion Data Type not recognized by VBA
"No, you actually do not need to, I often use it like this:"
Jun 12
Donna Trautmann replied to Donna Trautmann's discussion Data Type not recognized by VBA
"I have tried that, it doesn't work.  You actually have to have the lookup type to display the calendar."
Jun 12
Desree Schravesande replied to Donna Trautmann's discussion Data Type not recognized by VBA
"Donna try this,Set your date format back to normal in the containerOn your pass through variable expression, remove the lookup type and the lookup SQL Select statement. (they can be blank) This will force the date calendar to display on the…"
Jun 12
Donna Trautmann replied to Donna Trautmann's discussion Data Type not recognized by VBA
"Desree, Those are the settings that I am using with the Pass Through Variables' Data Types set at DBDate, and Field Variable Data Types of DBDate, VarChar and Numeric. I found the Date Format that I mentioned earlier, it was in the…"
Jun 12
Desree Schravesande replied to Donna Trautmann's discussion Data Type not recognized by VBA
"Hi Donna,The error in your attachment is becuase you were using direct query to run a set of code containing variables instead of the actual value. If in direct query, you have to replace your values with, in this case, the actual dates.Going back…"
Jun 12
Donna Trautmann posted a discussion

Data Type not recognized by VBA

I created 2 pass through variables to accept date parameters in a SQL connector.  I set the date variable types as DBDate.  I receive an error message that the automated data type is not recognized by Visual Basic.  I also tried setting it as variable type 'date', with the same error.  I tried running a direct query to extract the data and receive the error in the word doc attached.  If anyone has resolved this issue and would like to share. …See More
Jun 11
Donna Trautmann replied to Donna Trautmann's discussion SAGE 50 Prem Acctg US - Custom Container - Report Mgr Error
"I did. I think Sage is storing this variable as yyyymmdd and Excel does not recognize that format.   I don't remember where I found that data type reference in Sage and I can't seem to recreate the steps to find  the data…"
May 30
Desree Schravesande replied to Donna Trautmann's discussion SAGE 50 Prem Acctg US - Custom Container - Report Mgr Error
"Hi Donna,This is most likely a data type issue. Did you set your pass through variable with a data type of DBDate like this? See attached screenshot"
May 25
Donna Trautmann replied to Donna Trautmann's discussion SAGE 50 Prem Acctg US - Custom Container - Report Mgr Error
"Thank you, Des. Sorry for the delay, got pulled in another direction. I established the 2 pass through variables and all is well. There is a new issue, but I don't think it is Sage related if anyone can advise.  I found this article…"
May 24
Desree Schravesande replied to Donna Trautmann's discussion SAGE 50 Prem Acctg US - Custom Container - Report Mgr Error
"Hi Donna,Data fields cannot be added as parameters in a SQL Query container that is why they are not available on your param tab. 1.You need to add  a Pass through variable to your container, as per your example you want one for the date so…"
May 11

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 50-U.S. Edition Intelligence Reporting (Formerly Peachtree)
How long have you been using the above solution?
1 year
Where did you hear about us?
Sage Intelligence YouTube Channel

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

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service