Changes are coming to the Sage Intelligence Community

Soon the Sage Intelligence Community will be moving to become part of Sage City—a centralized community for all Sage solutions around the globe—and we want you to be part of it.

What does this mean?

In late June, you will no longer be able to create new posts or comment in the current community. All historical information will still be visible, but it will be in read-only mode so we can migrate the legacy content to Sage City. Beginning 27 June, 2019, you will be able to actively ask and answer questions, as well as share tips and tricks with fellow industry peers, partners and Sage pros in Sage City. Think of it as moving to a new, bigger home.

What needs to be done to get ready?

There is nothing to do now. We’ll let you know as soon as Sage City is ready. We’re very excited and hope you will be too.

Hope to see you in Sage City!


Sincerely,

Sage Intelligence Team

Forum

Data Type not recognized by VBA 11 Replies

Started by Donna Trautmann in Sage 50 - U.S. Edition. Last reply by Desree Schravesande 12 hours ago.

Consolidated Connector

Started by Parnel E. LaLonde IV in Sage 50 - U.S. Edition on Wednesday.

Committed (outstanding PO) and Actual vs Budget per GL Code 1 Reply

Started by Joany Hanson in Sage 300. Last reply by Mariano Catalano on Wednesday.

No Repository Folder specified

Started by Sanda in Sage 300 Jun 11.

Changes are coming to the Sage Intelligence Community

Started by Melentha Bisetty in General Jun 11.

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."
12 hours ago
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…"
Thursday
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"
Thursday
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…"
Wednesday
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service