Valerie hagen
  • Canada
Share

Valerie hagen's Friends

  • Carmen Griessel

Valerie hagen's Discussions

Function Arguments Screen displaying strange
1 Reply

I run out the sample designer statement and have issues with cells.  When I go into the FX to figure out why results are not calculating I get a very strange display.  Has anyone seen this…Continue

Started this discussion. Last reply by Jim Smith Jun 7.

ActiveX component can't create object
3 Replies

Sage 2018, Excel 32 bit 922.2114 (april 25, 2018)Double click on the report manager and get this errorContinue

Started this discussion. Last reply by Valerie hagen Jun 7.

ActiveX component can't create object
1 Reply

Sage 300 2018 sp2excel 2016 build .2114Loading business intelligence report manager and I get this error.  Continue

Started this discussion. Last reply by Helen May 28.

reference a period # and Write out month and last day of the month in full
2 Replies

Is  there syntax for being able to reference a cell with the period # and write out the full date.  Example10 is in the period cell used for communicationsbut I want another cell to say 'as at…Continue

Started this discussion. Last reply by Valerie hagen May 18.

 

Valerie hagen's Page

Latest Activity

Jim Smith replied to Valerie hagen's discussion Function Arguments Screen displaying strange
"It looks like your year and period aren't coming through to the report properly. If you change the "Current Period" field (which currently has #NAME in it) to 1 (or some period you know you have data for) and the year (at the top of…"
Jun 7
Valerie hagen posted a discussion

Function Arguments Screen displaying strange

I run out the sample designer statement and have issues with cells.  When I go into the FX to figure out why results are not calculating I get a very strange display.  Has anyone seen this before.  This is a brand new installation.  2018 SP2See More
Jun 7
Valerie hagen replied to Valerie hagen's discussion ActiveX component can't create object
"this was in fact the fix.  I had not run the ws installation.   thanks"
Jun 7
Helen replied to Valerie hagen's discussion ActiveX component can't create object
"Hello, - Try set your User Account control to Never notify and try loading report Manager - Try uninstalling and re-install as Administrator If that doesn't work contact Support to troubleshoot the issue. Regards, Helen "
Jun 6
Helen replied to Valerie hagen's discussion ActiveX component can't create object
"Hello, I found this article which may be…"
Jun 6
Valerie hagen posted a discussion

ActiveX component can't create object

Sage 2018, Excel 32 bit 922.2114 (april 25, 2018)Double click on the report manager and get this errorSee More
Jun 5
Helen replied to Valerie hagen's discussion ActiveX component can't create object
"Hello, - Try set your User Account control to Never notify and try loading report Manager - Try uninstalling and re-install as Administrator If that doesn't work contact Support to troubleshoot the issue. Regards, Helen "
May 28
Valerie hagen posted a discussion

ActiveX component can't create object

Sage 300 2018 sp2excel 2016 build .2114Loading business intelligence report manager and I get this error.  See More
May 25
Valerie hagen replied to Valerie hagen's discussion reference a period # and Write out month and last day of the month in full
"thanks"
May 18
ktroestler@blytheco.com replied to Valerie hagen's discussion reference a period # and Write out month and last day of the month in full
"I'm sure you can do this with a SQL expression, but an easy way is with an Excel Expression like the following: TEXT(EOMONTH(DATE(2000,C2,1),0),"mmmm dd")  Where c2 is 10.  I just picked 2000 as the year, but it could have…"
May 12
Valerie hagen posted a discussion

reference a period # and Write out month and last day of the month in full

Is  there syntax for being able to reference a cell with the period # and write out the full date.  Example10 is in the period cell used for communicationsbut I want another cell to say 'as at October 31' where period 10 to Sage is October.See More
May 10
Helen replied to Valerie hagen's discussion Statement Publishing with formula's #NA and not values
"Hello Valerie, Just a few suggestions: Please check if there is any difference in data/formulas between Company A and Company B? Also check, for the company that isn't working, that the sheet formatting is correct.  If you select the…"
Mar 26
Valerie hagen posted a discussion

Statement Publishing with formula's #NA and not values

I have a single BI financial statement written from the consolidated template.   It has 2 tabs of detail from one company and 2 tabs of detail from the other company.  My instruction is to publish it to a excel file converting to static values.  It works great in the lab.I import it to the clients sitethe statement runs good and as expectedi publish the statement2 of the sheets from one company are all #NA and when I look closer I see that the formulas have been published.  the other 2 sheets…See More
Mar 22
Valerie hagen replied to Valerie hagen's discussion BI Connector License
"I believe i have resolved my issue with a call to tech support and Chloe's help below.  Thought I would update. Connector license is required as Chloe below replied: - doing any sort of consolidated connections - or when you want to add…"
Mar 6
Valerie hagen replied to Valerie hagen's discussion BI Connector License
"i am using this one - Consol Financial Income Statement S300SQL "
Mar 6
Chloe replied to Valerie hagen's discussion BI Connector License
"Hey Valerie to answer a few of your questions... 1. You require a connector license when you doing any sort of consolidated connections or when you want to add multiple connections to your databases ie: if you have different databases across…"
Mar 6

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Accpac Intelligence

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

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service