Valerie hagen
  • Canada
Share

Valerie hagen's Friends

  • Carmen Griessel

Valerie hagen's Discussions

Updating BI Publish instructions Monthly for filename and file directory
4 Replies

We have over 40 instructions that are role based.  Each month when we generate the statements, we want to udpate the filename and directory for publishing.  We can go and edit the instructions one at…Continue

Started this discussion. Last reply by Valerie hagen Nov 27.

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.

 

Valerie hagen's Page

Latest Activity

Valerie hagen replied to Valerie hagen's discussion Updating BI Publish instructions Monthly for filename and file directory
"ok I just wanted to confirm i wasn't missing anything.  I am writing a little tool that will apply the change to the .rul file which i think will work.   But before I did that i wanted to confirm"
Nov 27
David Bryant replied to Valerie hagen's discussion Updating BI Publish instructions Monthly for filename and file directory
"Oh I see what is going on here.  You are trying to the get the name and location of the file to update according to the months. The internal workings of sage intelligence won't let you do this unfortunately.  Essentially, if you want…"
Nov 27
Valerie hagen replied to Valerie hagen's discussion Updating BI Publish instructions Monthly for filename and file directory
"Pic 1 attached show the fields I am trying to change monthly through the software.   Pic 2 shows what tags are changed in the .rul. IN the attachments I am showing how at the end of March I need to update these two things to all…"
Nov 27
David Bryant replied to Valerie hagen's discussion Updating BI Publish instructions Monthly for filename and file directory
"I am sorry i am not too clear on the question and explanation. Can we have some screenshots?"
Nov 27
Valerie hagen posted a discussion

Updating BI Publish instructions Monthly for filename and file directory

We have over 40 instructions that are role based.  Each month when we generate the statements, we want to udpate the filename and directory for publishing.  We can go and edit the instructions one at a time but we are wondering if there is a more efficient way. I note that there is a .rul file for each instruction in the  \bxdata\SQL\distribution directory.   I note that there are two tags in that file that are updated if I make the change through distribution instructions to file name and…See More
Nov 20
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

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