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

Doug Walker's Friends

  • Gregory Sosnowski
  • Vincent Esposito
  • sky yan
  • Rich Berkey
  • Donna McIntosh
  • John Jackson
  • Darleen Borgella
  • Kelly Childress
  • Brian Buck
  • Anuja Patel
  • Denyse Miller
  • Michele Bottino
  • Rick Steder
  • Ann Murphy
  • Jesse Braun

Doug Walker's Groups

Doug Walker's Discussions

Sage 100 SQL Syntax Help
1 Reply

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 Doug Walker Dec 26, 2017.

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

Gregory Sosnowski left a comment for Doug Walker
"Nice to meet you Doug"
yesterday
Doug Walker replied to SteveP's discussion Task Pane display issues and Manage trees display issues
"Steve - I don't think Office 365 is supported. You may want to check with Support."
Sep 14
Doug Walker replied to Beth Bowers's discussion Report Designer Component required error on report, yet another RD report successfully running
"You're welcome"
Sep 12
Doug Walker replied to Beth Bowers's discussion Report Designer Component required error on report, yet another RD report successfully running
"What I would do is open the Template the works in Design Mode. Open the Template that doesn't in Design Mode. Copy the worksheets from the bad one to the good one. Make a copy of the Report in the Report Manager and link this template to it.…"
Sep 12
Doug Walker replied to Beth Bowers's discussion Report Designer Component required error on report, yet another RD report successfully running
"If you run the one that works and keep the template open and then run the doesn't will it still show the error?"
Sep 12
Doug Walker replied to Beth Bowers's discussion Report Designer Component required error on report, yet another RD report successfully running
"When you say both run Okay on the server is this you running the reports on the clients server?"
Sep 12
Doug Walker replied to Yin Chen's discussion Accounts receivable
"Here is a list of the Free Reports for Sage 100 https://www.sageintelligence.com/report-utility/sage-100/"
Aug 20
Doug Walker replied to D M's discussion Multiple reports in a chain
"This community is for Sage Intelligence. There is a forum on the Sage City site to ask Questions re:Crystal Reports Sage City"
Jul 27
Doug Walker replied to D M's discussion Multiple reports in a chain
"Is this for Sage Intelligence or Crystal Reports?"
Jul 27
Doug Walker replied to Doug Hart's discussion Incorrect syntax near ')'
"Go into the Container and click on the FiscYearPer field. On the Properties tab click on the ellipse next to Expression Source. Click on the Execute button. Does it error out? If it does copy and past the SQL code here."
Jul 24
Doug Walker replied to Carol Lord Openhym's discussion Report Utility Times Out
"Does it work if they try to download just 1 report?"
Jul 23
Doug Walker replied to D M's discussion Basic Questions
"What it is? It is a report tool that allows you to create reports that export directly to Excel. How it works? You create reports (Financial & No-Financial) that will send the data to Excel. In Excel you can use the Report Designer Add-In to…"
Jul 20
Doug Walker replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Dan - Attached is an example on how to get the Current Pd/Year and the Prior Pd/Year. It's a Union report that has 2 sub reports. One for Current Pd/Year and one for the Prior Pd/Year. There are 2 Pass-Thru Variables setup in each for Invoice…"
Jul 16
Doug Walker replied to Dan St. John's discussion Non-Financial Current month/year vs. prior year comparison
"Are you looking to get Summarized Sales Totals or Detail (i.e. Invoice) Totals"
Jul 12
Doug Walker replied to Sue Moore's discussion Adding a subreport to an existing union report
"Yes cause it outputs to the position and the report expects position 2 be the parameters. :)"
Jun 29
Doug Walker replied to Sue Moore's discussion Adding a subreport to an existing union report
"Here are the steps I do: Export the report Create a new folder in Report Manager Import the report using a different name i.e. adding Rev 2 to the end Run the report Add a Sheet for the new sub report to use and link back. Add the sub report to the…"
Jun 29

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