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

Doug Walker's Friends

  • Andrew Hagenbach
  • Tracey Hayes
  • Aracelis McAloon
  • Laura Loper
  • Timothy Turner
  • Paula Park
  • Gregory Sosnowski
  • Vincent Esposito
  • sky yan
  • Rich Berkey
  • James O'Curran
  • Donna McIntosh
  • John Jackson
  • Darleen Borgella
  • Kelly Childress

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.

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 Debbi Silberberg's discussion Can't read task pane or access manage reporting trees
"I remembered that I actually had this issue with a client. I was doing some remote work on his computer. They access the Sage 100 thru RDP. One day it was working just fine. A few days later when we accessed the RDP Desktop the Screen Resolution had…"
Monday
Doug Walker replied to Debbi Silberberg's discussion Can't read task pane or access manage reporting trees
"What version of Excel?"
Jan 12
Doug Walker replied to Clark Walliser's discussion How long should it take to open a template to edit it?
"Once you run the report the template contains everything you need to work with it. You can run the report and save the template to your Desktop. Make changes and if you want to stop for the day save it back to the Desktop. When you are done open…"
Dec 29, 2018
Doug Walker replied to Clark Walliser's discussion Importing SI .tre metadata into Excel to view, getting error (Internal error: Data at the root level is invalid. Line 4, position 1.)"
"I use a program called Notepad ++ Notepad ++ download It allows you to edit the .tre files. You can see how the exiting trees are defined. You can copy and paste the sections and then just change the GL Account."
Dec 29, 2018
Doug Walker replied to Clark Walliser's discussion How long should it take to open a template to edit it?
"Hi - The Report Designer report is a Union report that runs 9 sub reports. These sub reports output are hidden. 2 of the reports Actual & Opening Balances outputs all of the history from the GL_PeriodPostingHistory file. Depending on how many…"
Dec 29, 2018
Doug Walker replied to Bastian's discussion Wildcard Characters in Sage Intelligence
"Okay"
Dec 27, 2018
Doug Walker replied to Bastian's discussion Wildcard Characters in Sage Intelligence
"Not sure but don't think so. Any chance you can get the output of 1 of the reports and upload here or email me? I can take a look to see if there is an easier way."
Dec 26, 2018
Doug Walker replied to Bastian's discussion Wildcard Characters in Sage Intelligence
"Were the reports created with the old Financial Report setup or with the Report Designer Addin"
Dec 26, 2018
Doug Walker replied to Bastian's discussion Wildcard Characters in Sage Intelligence
"What version of Sage Intelligence are they coming from?"
Dec 26, 2018
Doug Walker replied to Bastian's discussion Wildcard Characters in Sage Intelligence
"What are you looking to accomplish?"
Dec 26, 2018
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, 2018
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, 2018
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, 2018
Peter Scully replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"Sure thing."
Oct 26, 2018
Doug Walker replied to Doug Walker's discussion Sage 100 SQL Syntax Help
"That did it! Thanks for looking into this."
Oct 25, 2018
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, 2018

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