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

Doug Walker's Friends

  • 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
  • Rich Berkey
  • James O'Curran

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 Terris's discussion Delete union reports quickly
"Nope."
Wednesday
Doug Walker replied to Kevin Acorace's discussion Formulas broke in connector
"How I got it to work for me was to create a new Data Expression for "WkBudgetAmt" using the same formula and replacing the old one with this new one. The Data Expression maybe corrupt?"
Mar 11
Doug Walker replied to Kevin Acorace's discussion Formulas broke in connector
"Try this one"
Mar 8
Doug Walker replied to Kevin Acorace's discussion Formulas broke in connector
"Is this for Sage 100? If it is do you want to export the report so I can look at it?"
Mar 7
Doug Walker replied to Kevin Acorace's discussion Formulas broke in connector
"Remove the Data Expression from the report. Run the report. Then go to the sheet and manually add it and see if Excel approves of it."
Mar 7
Doug Walker replied to Kevin Acorace's discussion Formulas broke in connector
"Looks like there is a space before the decimal. Strip out the .00 and try it."
Mar 7
Doug Walker replied to Clark Walliser's discussion Installed 64bit MS ofc, now Sage 100 Intelligence gives error
"Have you tried rerunning the Workstation setup?"
Mar 7
Doug Walker replied to Sinead Briscoe's discussion Report Filters - not saving selections in Pivot tables
"This has worked for me before. Go to the Pivot Table Options. On the Data tab change "No of items to retain per field" to None. Link the template back to the report and see if it works."
Feb 26
Doug Walker replied to LYNN RUSHING's discussion Sage 100 Free Reports Tables
"Lynn - I had some time and revised the Sales Rep report to use the Salesperson name assigned to the Customer. Import the attached and see if it's what you were looking for."
Feb 26
Doug Walker replied to Sara M's discussion Reporting Tree
"You're welcome"
Feb 22
Doug Walker replied to Sara M's discussion Reporting Tree
"Sara - to accomplish what you are looking for you will need to setup a Parent-Child relationship like this:"
Feb 21
Doug Walker replied to lanette felsch's discussion Sales report less disounts
"What flavor of Sage are you using?"
Feb 21
Doug Walker replied to Matthew Anthony's discussion Inventory Valuation Trend
"I believe Craig's report was built for Sage 100."
Feb 18
Doug Walker replied to Michele Beckett's discussion quarter to date income statement
"You're welcome."
Feb 4
Doug Walker replied to Michele Beckett's discussion quarter to date income statement
"Michele - The Report Designer Add-In does not have a QTD formula. To get the QTD numbers you can do the following: You will need to create 4 columns for each Qtr. Create 1 column and Use the GLActual formula. In a row at the top of the each…"
Feb 4
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…"
Jan 14

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