Clark Walliser
  • Male
  • Scotts Valley, CA
  • United States
Share

Clark Walliser's Friends

  • Doug Walker

Clark Walliser's Discussions

Publish to File with static values copies values in rows 1-4 into body of financials
2 Replies

I'm on Sage 100 2018 PU5 with the SI update SI5200-T. When I publish a financial report to file with static data values, the values in rows 1-4 appear to get copied about every 10 rows down the…Continue

Started this discussion. Last reply by Clark Walliser Mar 18.

Publish to File with static values copies values in rows 1-4 into body of financials

I'm on Sage 100 2018 PU5 with the SI update SI5200-T.When I publish a financial report to file with static data values, the values in rows 1-4 appear to get copied about every 10 rows down the…Continue

Started Mar 8

Installed 64bit MS ofc, now Sage 100 Intelligence gives error
2 Replies

I had MS Ofc 32bit, then uninstalled and installed Ofc 64bit. Now when I open Excel it gives me a message:The file format and extension of 'Sage.BI.ExcelFuntion1.1.xll' don't match. the file could be…Continue

Started this discussion. Last reply by Clark Walliser Mar 7.

Financials: Hiding zero value lines on multiple sheets - what's the current solution?
4 Replies

I've seen the posts about the report manager add-in "zeroinggl" that enables you to configure an algorithm for each individual sheet. My issue is that the report I'm working on has about 90 sheets,…Continue

Started this discussion. Last reply by Clark Walliser Jan 25.

 

Clark Walliser's Page

Latest Activity

Clark Walliser replied to Clark Walliser's discussion Publish to File with static values copies values in rows 1-4 into body of financials
Mar 18
Sandra Smith replied to Clark Walliser's discussion Publish to File with static values copies values in rows 1-4 into body of financials
"Hi Clark,  I've not see this but I checked with one of our top Sage Intelligence partner consultants from and he suggested that it could be some corruption in the template.  Or maybe it has to do with freezing the panes? Maybe make a…"
Mar 14
Clark Walliser posted discussions
Mar 8
Clark Walliser replied to Clark Walliser's discussion Installed 64bit MS ofc, now Sage 100 Intelligence gives error
"Yes, re-ran workstation setup, no change. I have uninstalled Sage 100 (it's my laptop demo system) and disabled the BI Tools and designer add-ins from Excel. I'll see what that does. "
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
Clark Walliser replied to Clark Walliser's discussion Financials: Hiding zero value lines on multiple sheets - what's the current solution?
"I came up with a layman's solution for filtering out zero qty rows. I created a calculated cell at the end summing up all the columns in the layout for that row. Formatted the font to be white so it did not appear, then filtered on only that…"
Jan 25
Sandra Smith replied to Clark Walliser's discussion Financials: Hiding zero value lines on multiple sheets - what's the current solution?
"Good question.  The Tips and Tricks are found on our website which is a different platform than our Community. Go to  www.sageintelligence.com  then select the Resources tab and you will see Tips and Tricks in the menu among other…"
Jan 25
Clark Walliser replied to Clark Walliser's discussion Financials: Hiding zero value lines on multiple sheets - what's the current solution?
"Thank you for the links Sandra. Why is it that when I searched the community for "hide rows" none of these resources displayed?"
Jan 25
Sandra Smith replied to Clark Walliser's discussion Financials: Hiding zero value lines on multiple sheets - what's the current solution?
"Hi Clark,  We have a couple options in the Tips and Tricks section of our website:  How to hide zeros using Excel -…"
Jan 25
Clark Walliser posted a discussion

Financials: Hiding zero value lines on multiple sheets - what's the current solution?

I've seen the posts about the report manager add-in "zeroinggl" that enables you to configure an algorithm for each individual sheet. My issue is that the report I'm working on has about 90 sheets, and they might change regularly over time. I don't want to tell the customer that they must go into the report manager and change configurations every time they add or delete a sheet.Are there any other user friendly solutions out there?See More
Jan 24
Clark Walliser replied to Clark Walliser's discussion Reporting Tree Units don't display on Rpt Tree list in task pane. The list just runs out...
"I learned from another colleague that Sage has a hotfix for this issue. SI5200-T.  I downloaded and installed it. 3 minutes later, all the reporting units show! Note, it is installed on each client using SI."
Jan 23
Clark Walliser posted a discussion

Reporting Tree Units don't display on Rpt Tree list in task pane. The list just runs out...

I'm in the Excel Template assigning worksheets to different rpt tree units from the task pane. But the list only goes down about 8 units, and there are 5 more units in that branch.The branch lines and units just fade out to nothing.I've tried resizing the screen, thinking it's only a video display. But I can't get the other units to show. I'm on Excel 2013.Has anyone else out there seen this?…See More
Jan 23
Clark Walliser replied to Clark Walliser's discussion When select certain reporting tree units no data shows in amount cells, only text "Reporting Tree"
"This is what I found in the .TRE document: ' Apparently these characters got pulled in via a copy / paste routine. I did a search and replace on the .TRE file which appears to have worked. But now my issue is that in the excel template, when…"
Jan 22
Sandra Smith replied to Clark Walliser's discussion When select certain reporting tree units no data shows in amount cells, only text "Reporting Tree"
"Hi Clark,  I've not see this before.  Make sure there are no characters like dashes or periods that within the account number or range.  Here is more information on how to using masking within trees…"
Jan 21
Clark Walliser posted a discussion

When select certain reporting tree units no data shows in amount cells, only text "Reporting Tree"

I have a reporting tree with about 145 units on it.I've created separate worksheet tabs for each reporting tree unit that gets distributed, about 120.I did this by using the Move/Copy tab function to copy a working tab to the end of the list, then assigning the reporting tree unit.The first 9 reporting units (tabs) work fine.Some of the first 9 are roll up units, some are actual acct mask unitsBut when I get to the 10th Reporting unit, the cells for the actuals and budgets don't show numbers,…See More
Jan 17
Debbi Silberberg replied to Clark Walliser's discussion Financials Report Title - how to show company name and fiscal period end calendar date like FRx
"You're welcome. You can use a vlookup as well, but I've found the choose formula to be much easier."
Jan 14

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage 100 ERP Intelligence Reporting (Formerly MAS)
How long have you been using the above solution?
> 20 years

Comment Wall (1 comment)

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

Join The Sage Intelligence Community

At 9:21am on January 9, 2019, Ahmed Maris said…

Good Day,
How is everything with you, I picked interest on you after going through your short profile and deemed it necessary to write you immediately. I have something very vital to disclose to you, but I found it difficult to express myself here, since it's a public site.Could you please get back to me on:( mrsstellakhalil5888@gmail.com ) for the full details.

Have a nice day
Thanks God bless.
Stella.

 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service