Christine Williams
  • Female
  • New Berlin, WI
  • United States
Share

Christine Williams's Groups

Christine Williams's Discussions

Report Execution Error
19 Replies

Would someone know what this error means? My container consist of 5 tables, expressions directly from the tables and a few SQL expressions.Continue

Started this discussion. Last reply by Doug Walker Oct 31, 2017.

Simple SQL expression?
10 Replies

I would like to take advantage of using the SQL Expression in the connector. The Advance course training material only states “although you can create a SQL expression from scratch it is often…Continue

Started this discussion. Last reply by Christine Williams Jan 20, 2017.

SQL expression that references another SQL expression
4 Replies

 Sage 100 ERP. I’m currently figuring out how to use SQL expressions in the connector. However, I’m stuck creating the CTS CALC COST expression since I need to reference the CTS DAYS SQL expression.…Continue

Started this discussion. Last reply by Christine Williams Nov 10, 2016.

SAGE 100 ERP- Filter Field is not available
2 Replies

I have created an excel expression in the container using the LEFT function. The new column name is "RSN" and returns 3 digit numbers.It works great. Since the report uses a lot of data, I would like…Continue

Started this discussion. Last reply by Christine Williams Oct 3, 2016.

 

Christine Williams's Page

Latest Activity

Doug Walker replied to Christine Williams's discussion Report Execution Error
"Let me know what happens."
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"This sure makes sense. I will work on your suggestion in the next couple of days. Thank you for all your help. Christine"
Oct 31, 2017
Doug Walker replied to Christine Williams's discussion Report Execution Error
"I did a Google search on the error message "Arithmetic overflow error converting expression to data type smalldatetime" and got a lot of hits. They all seem to indicate that the date fields in the expression may have some sort of…"
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"I'm using Sage 100 Standard 2017 and Sage 100 ERP Intelligence Reporting 2015."
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"We are using the ODBC Driver SQL Server that pulls the data from Fastrack which is our Integrated System were orders get entered and processed."
Oct 31, 2017
Doug Walker replied to Christine Williams's discussion Report Execution Error
"What module do these files come out of? You did say you are running Sage 100 2017 correct? I ask because I don't recognize the file names of "ar or "Productm"?"
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"I removed the SQL expressions and it actually worked. I don't think I'm using an Add On. Here is an example of a SQL expression. CASE WHEN (CASE WHEN [ar].[RP_OR_S]='P' THEN DATEDIFF (day,[ar].[DELIVERY_DATE],[ar].[SERVICE_DATE])…"
Oct 31, 2017
Doug Walker replied to Christine Williams's discussion Report Execution Error
"Are the files you are using from an Add On? I would make a copy of the report and remove the SQL Data Expressions from the Columns in the report and run it for all and see what happens."
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"I check/tested all SQL expressions and it was successful."
Oct 31, 2017
Doug Walker replied to Christine Williams's discussion Report Execution Error
"Logically the amount of data shouldn't give you this error. What it maybe is that there is some issue with the data and when you ran it for less days the SQL Data expressions didn't have to run on the records that have an issue?"
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"I just ran the report again for 5 days vs. YTD and it worked. I'm just wondering why it is not able to handle the data?"
Oct 31, 2017
Doug Walker replied to Christine Williams's discussion Report Execution Error
"I've never heard of a limit? The next thing I would do is run the Check/Test on each of the SQL Data Expressions to make sure they are set correctly."
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"it succeed. Here is a screen print of my connector with the tables and expressions. Is there a limit on how many tables can be added?"
Oct 31, 2017
Doug Walker replied to Christine Williams's discussion Report Execution Error
"Go to the Container in the Connector. Right Click on the Container and select "Check Test" Let me know if it Succeeds?"
Oct 31, 2017
Christine Williams replied to Christine Williams's discussion Report Execution Error
"Standard"
Oct 31, 2017
Doug Walker replied to Christine Williams's discussion Report Execution Error
"Is it Sage 100 Advanced or Premium?"
Oct 31, 2017

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 100 ERP Intelligence Reporting (Formerly MAS)
How long have you been using the above solution?
2 weeks
Where did you hear about us?
Other

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