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 10 Replies

Started by Donna Trautmann in Sage 50 - U.S. Edition. Last reply by Donna Trautmann on Thursday.

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 on Tuesday.

Changes are coming to the Sage Intelligence Community

Started by Melentha Bisetty in General on Tuesday.

Latest Activity

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
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."
Wednesday
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service