Eric Anderson
  • Male
  • Salt Lake City, UT
  • United States
Share

Eric Anderson's Friends

  • Andy Bruner
  • Lloyd Smith
  • Michael Brennan
  • Craig Juta

Eric Anderson's Discussions

Incorrect size descriptor in Blowfish decryption
3 Replies

Receiving an error when trying to distribute reports.  Sage 100 version 2014 (upgrade from 2013).  Yes, the error actually references a Blowfish!  Also, Distribution Settings opens a blank screen -…Continue

Tags: Blowfish

Started this discussion. Last reply by Eric Anderson Sep 22, 2014.

pass through variable invalid sql query
9 Replies

Have created a very simple PTV and trying to use it in a union report.  Works fine on initial report (pulling from container with PTV). But when I add the filter to the second report in the union…Continue

Tags: SQL, query, Invalid, Variable, Through

Started this discussion. Last reply by Peter Scully Jul 25, 2014.

BI Tools missing
5 Replies

Sage 100, excel 2013 - 32-bit, can't get the BI Generator under COM Add-ins to check.  When…Continue

Tags: Generator, Tools, BI

Started this discussion. Last reply by Sandra Smith Jun 27, 2014.

Modify Drill-Down Trans Detail Columns - Sage 100
9 Replies

I've read about the drill-down but still can't figure out how to modify the columns that appear with a pre-defined drill down.  When I drill down from the main report to the account level, I end up…Continue

Tags: down, drill, modify

Started this discussion. Last reply by Colby Rampton Sep 11, 2014.

 

Eric Anderson's Page

Latest Activity

Karen Smart replied to Eric Anderson's discussion This workbook does not have valid data to use in the Report Designer add-in
"Here are all of the possible fixes for this message in one concise area. Also, you may need to re-do the workstation installation. http://www.tandemtechnologiesllc.com/blog/sage/sage-300/sage-300-business-intelligence-workbook-not-valid-data/"
Jul 12, 2016
Peter Scully replied to Eric Anderson's discussion Complex Filters kill my Parameter
"Hi Judy. Right click on the Home object in the navigation pane on the left of the Report Manager. You can the select Switch Output Mode.  "
Aug 17, 2015
judy wallace replied to Eric Anderson's discussion Complex Filters kill my Parameter
"I know this is an old post, but I am having the same problem.  However, I am unable to figure out how to run the SQL debug.  I have no option to switch to a debug mode. Help screen says to right click on Report Manager Home, but nothing…"
Aug 11, 2015
Eric Anderson replied to Beth Bowers's discussion Report Designer Add-In skipping some accounts
"interesting - I haven't worked much with 500 data so I'm not sure what would be happening"
Mar 23, 2015
Eric Anderson replied to Beth Bowers's discussion Report Designer Add-In skipping some accounts
"can you run an auto-connect (nonconsol) report for each of those three companies?  Also, sometimes I've had to change the case of the company code from upper to lower to get the connection to work."
Mar 21, 2015
Eric Anderson replied to Sinead Briscoe's discussion Report Filters - not saving selections in Pivot tables
"this worked for me Stephen - thanks! Interesting, i swear I had it set up the exact same way on two different reports (same client, same version of excel, etc.) - just two different SI reports. The sales order report has the filter in the fitlers…"
Nov 19, 2014
Jim Smith replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"Thanks. Is there a document that outlines the process of verifying whether I have the correct VSTO apps installed and how to update them, if necessary?"
Nov 14, 2014
David Bryant replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"Okay Eric No worries Let us wait and see what the client says about upgrading. Thanks"
Nov 10, 2014
Eric Anderson replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"Thanks David - they are on an older version of MAS 200 and Sage intelligence.  I finally opened a case with Sage tech support and Sage told me they wouldn't have access to report distribution functionality on version 4.4, so I passed that…"
Nov 10, 2014
David Bryant replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"Hey Eric, Have you found a solution to this? i would like to see if i can remote in and take a quick look. Let me know Thanks"
Nov 10, 2014
nanah replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"HI JIM, what version of excel are you working with? I would also repair excel and insure that the solver add-in is disabled as well. also just make sure that the VSTO for office runtime 3.0 is installed if you have office 2010/2013 insure that VSTO…"
Nov 7, 2014
Jim Smith replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"Thanks. How do I do that? I've already uninstalled and reinstalled Intelligence. Also, the Report Designer functionality doesn't work, either (no layout generator buttons on the BI Tools tab)."
Nov 6, 2014
Sandra Smith replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"Hi Mike and Jim,   Not sure if this will help but can you try running a repair of intelligence? I had the same issue and repairing fixed it but I have 2014 non-XP.  I'm also inquiring on my end if that does not…"
Nov 6, 2014
Jim Smith replied to Eric Anderson's discussion No Report Distribution Options under BI Tools
"Hi Mike. I'm having the same problem. I have the BI Tools tab, but no Distribution Settings. It was previously there, but now it is not. I have Sage 300 on a stand alone machine, and I have not changed anything. Do you know how I can get my…"
Nov 6, 2014
Eric Anderson replied to Jane Hawthorne's discussion I found a way to hide zero rows!
"are you absolutely sure that is the correct worksheet name (2 Copy of Inventory_Order_Tool_sku411_y_V1)?  It thinks that the worksheet name tied to the ZeroinII macro doesn't exist.  I've had that error before and just had…"
Oct 14, 2014
Eric Anderson replied to Eric Anderson's discussion Incorrect size descriptor in Blowfish decryption
"unfortunately, that didn't seem to do the trick"
Sep 22, 2014

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage MAS Intelligence
Website
http://www.sgstech.com
About Me:
MAS 90/200 consultant
How long have you been using the above solution?
12 months

Comment Wall

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

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service