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

Doug Walker's Friends

  • Darlene Snapp-Silfies
  • Bob Hess
  • Brandon Russell
  • zalmi berger
  • Susan Andrews
  • Andrew Hagenbach
  • Tracey Hayes
  • Clark Walliser
  • Aracelis McAloon
  • Laura Loper
  • Timothy Turner
  • Paula Park
  • Gregory Sosnowski
  • Vincent Esposito
  • sky yan

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, 2018.

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.

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.

Free is Good
2 Replies

Hi - Just wanted to make a note here to tell you that I uploaded a new report in the Sage-100 Free Report Group.Here's the link :…Continue

Tags: sales, free, inventory, sage-100

Started this discussion. Last reply by Doug Walker Mar 13, 2015.

 

Doug Walker's Page

Latest Activity

Doug Walker replied to Manuel Nieves's discussion pass through variable document
"Nope"
Friday
Doug Walker replied to Manuel Nieves's discussion pass through variables
"I sent a message on here maybe it will work?"
Wednesday
Doug Walker replied to Manuel Nieves's discussion pass through variables
"No attachments on the other post."
Wednesday
Doug Walker replied to Manuel Nieves's discussion pass through variables
"You don't get this:"
Wednesday
Doug Walker replied to Manuel Nieves's discussion pass through variables
"When you click reply at the bottom you will the "Upload Files" link. Click it and then use the Browse to select the export file,"
Wednesday
Doug Walker replied to Manuel Nieves's discussion pass through variables
"DIdn't see the attachment. If you can export the report and upload it here I can take a look. Pass Throughs are always tricky."
Wednesday
Doug Walker replied to Manuel Nieves's discussion pass through variables
"How did you setup the Pass Through Variable fields on the report?"
Wednesday
Doug Walker replied to Dana Halpin's discussion Sage 100 Intelligence 64/32 bit add in error
"I would call Sage Support on this one."
Tuesday
Doug Walker replied to Shara Stroschen's discussion Task Scheduled SI report emailing 1 pdf sends 8 copies of same pdf - should only send one
"I have had issues working with the Windows Task Scheduler. I found this Freeware that fixed all my issue. You may want to give it a try. System Scheduler"
May 9
Doug Walker replied to Lloyd Smith's discussion Sage 100 and Report Manager
"Open Excel and then run a report.See if it works."
Apr 27
Doug Walker replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"You can use the Pivot Table Filter on the Item Col. "Does Not Begin With"."
Apr 26
Doug Walker replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"Are you using a Pivot Table in Excel that uses the Raw Data?"
Apr 26
Doug Walker replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"The "Does Not Begin With" would be perfect for this. Do the "M" items have a unique Product Line?"
Apr 26
Doug Walker replied to Erin Roundy's discussion Report Execution Error for invalid SQL query when adding filter with comparison operator "Does Not Begin With"
"Well there is actually no solution. Because of the Providex back end you can't use "Does Not Begin With" You will have to try another way to get what you want. What are you wanting to do?"
Apr 26
Doug Walker replied to Stacey Gassett's discussion Can not use "Does Not Begin With" in my filters
Apr 20
Doug Walker replied to Pratap Nair's discussion how to add a new companyto the consolidated reports
"You will need to add the 2 new company codes to each of the Sub Reports "Database Consolidation List". Click on the ellipse and select the companies.  If they do not display in the list you have to at least once select the company…"
Mar 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

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service