Doug Walker
  • Male
  • Lakeville, MN
  • United States
Share

Doug Walker's Friends

  • Timothy Turner
  • Paula Park
  • Gregory Sosnowski
  • Vincent Esposito
  • sky yan
  • Rich Berkey
  • James O'Curran
  • Donna McIntosh
  • John Jackson
  • Darleen Borgella
  • Kelly Childress
  • Brian Buck
  • Anuja Patel
  • Denyse Miller
  • Michele Bottino

Doug Walker's Groups

Doug Walker's Discussions

Sage 100 SQL Syntax Help
15 Replies

I created a Pass Thru Variable for a date to enter at run time.I need the SQL syntax to create the 2 digit month from Pass Thru Variable to use as a comparison.The date comes out as "26 December…Continue

Tags: Providex, SYNTAX, SQL, 100, SAGE

Started this discussion. Last reply by Peter Scully Oct 26.

Excel 2010 Record Macro in Pivot Table "Run-time-error '1004'"
8 Replies

Running Excel 2010. Have a Pivot Table that I want to use a Macro to Filter a value. I start the recording click on the field filer - select Value Filters - Greater Than or Equal To - The Value…Continue

Started this discussion. Last reply by Peter Scully Jul 24, 2016.

Sage-100 Sales Order Promise Date Report

Added another Free report in the Free Report GroupThe report ages Open & Back Ordered Sales…Continue

Started May 21, 2015

Free Sage-100 Intelligence Report
2 Replies

Added a new report to the Free Report Template Group.The report is a Purchase Order Expected Delivery Report.The report is based off of the report with the same name in the Purchase Order Report…Continue

Started this discussion. Last reply by Doug Walker Apr 1, 2015.

 

Doug Walker's Page

Latest Activity

Doug Walker replied to Sandra Smith's discussion how to change blank date fields
"I've tried to figure it out for many years and never found a "fix". If you find a fix let me know."
Oct 31
Doug Walker replied to Sandra Smith's discussion how to change blank date fields
"Instead of using 1/0/1900 try using 12:00:00AM Just tested it out and that works."
Oct 31
Doug Walker replied to Sandra Smith's discussion how to change blank date fields
"I use Conditional Formatting on the column that holds the Date to change the font color to white. I'm assuming this is in a Pivot Table Create a New Rule Format Only Cells That Contain Cell Value Equal to 1/0/1900 Click on Format Under the…"
Oct 31
Peter Scully replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Sure thing."
Oct 26
Doug Walker replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"That did it! Thanks for looking into this."
Oct 25
Peter Scully replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Hi Doug. So it turns out that passthrough variables are case sensitive.  I changed the one in your SQL source to @DateTest@ and it pulls through the date I entered in the correct format.  I also suggest checking Allow Lookups under the…"
Oct 25
Doug Walker replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Here a copy of the report if your bored and what to play with it."
Oct 24
Doug Walker replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Timothy - I'm relying here because I can't reply to the other one. I changed the Pass Through to "Date" and still get the error: Here is a screen shot from the SQL Debugger showing how the Where comes out and the error when I…"
Oct 24
Timothy Turner replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Doug in the example above are you getting any error message or are those some how suppressed. If possible I would change the datatype on the pass through to date not varchar if possible. I believe the function month() and year() function with…"
Oct 24
Doug Walker replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Peter - I posted this last year and couldn't find the report that I had the issue with the way the Pass Through displayed the date. I just tested it and it does come thru as yours "YYYY-MM-DD". However I still have an issue trying to…"
Oct 24
Timothy Turner replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Yes the YEAR scalar function is a way of doing this.  Here is can example. select top 10 customerno, {fn YEAR(DateCreated)} from AR_Customer"
Oct 24
Peter Scully replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Yes, it was 100 Advanced.  I also checked and the YEAR function works for the year as well."
Oct 24
Doug Walker replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Peter - Thanks for checking on this. My aim was to just get the 2 digit month. For example with the Date 2018-10-23 I want to pull "10". Also looking to just pull the Year i.e. "2018" PS - Are you testing it with Sage 100…"
Oct 23
Peter Scully replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Hi Doug. I tried this and could get it to work using the MONTH function with the UQE turned on.  In my query however the date for my passthrough variable came through in the following format: {d '2018-10-23'}.  So…"
Oct 23
Doug Walker replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"I appreciate it."
Oct 19
Peter Scully replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Hi Doug. I'll take a look at this and see if I can come up with anything."
Oct 19

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 100 ERP Intelligence Reporting (Formerly MAS)
Website
http://doc102208.wix.com/drw-consulting
About Me:
Independent Report Writer specializing in Sage Intelligence Reports for the Sage 100 Product for over 7 years

I have built hundreds of Financial Reports using the Report Designer Add-In. Non Financial Reports for AR,AP,IM,JC,PO & SO.

If interested in a price quote please DM me or email: doc102208@gmail.com
How long have you been using the above solution?
01/2011
Where did you hear about us?
Other

Comment Wall (4 comments)

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

Join The Sage Intelligence Community

At 2:33pm on September 21, 2018, Gregory Sosnowski said…

Nice to meet you Doug

At 8:02pm on October 22, 2015, Rusty Eldridge said…

Thanks Doug!  I look forward to learning about Sage Intelligence!  This is all new to me, but I hear SI will do great things for our reporting!  Thanks again. Rusty.

At 3:54pm on April 25, 2014, Anna-Lisa Hunter said…

If the Roll Up Codes are not even exported out of Sage 100 into Intelligence, how can you incorporate them into a report using Add-In?

At 8:08am on April 7, 2011, Ruth Gray said…

Hi Doug

 

Welcome to the BI Community. I look forward to assisting you in becoming the best SMI support consultant.

 

have a great day

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service