"I figured out the prior year current syntax problem. Yay me! I changed ActivityPeriod01... to PYActivityPeriod01... and am getting the correct results now. Thanks again for the template.
The sign issue I have is that I apparently…"
Debbi Silberberg's Groups
-
Free Report Templates Gr…
116 members
-
Sage ERP MAS Intelligence
137 members
Debbi Silberberg's Discussions
Adding Text to a Row
3 Replies
I have custom groupings. Id like to add text for Revenues, Operating Expenses, etc. How can I do that?Thank you.Continue
Started this discussion. Last reply by Doug Walker Mar 2.
Create and Link does not save account mapping
2 Replies
I've created custom account groups using the video posted here. Worked great except that when I create and link my template,…Continue
Started this discussion. Last reply by Debbi Silberberg Feb 22.
Debbi Silberberg's Page
Latest Activity
Debbi Silberberg replied to Stephen Coull's discussion MAS 90/200 Financial Report Designer - Current Month and Year to Date Layout in the group Free Report Templates GroupDebbi Silberberg replied to Stephen Coull's discussion MAS 90/200 Financial Report Designer - Current Month and Year to Date Layout in the group Free Report Templates Group"As I suspected, the prior and current are the same number.
How do I tell excel or SMI to reverse the signs on revenues in the budget?"
Debbi Silberberg replied to Stephen Coull's discussion MAS 90/200 Financial Report Designer - Current Month and Year to Date Layout in the group Free Report Templates Group"Oh! Well that was easy. I don't see any syntax difference in formula between CurrentPeriod and…"
Debbi Silberberg replied to Stephen Coull's discussion MAS 90/200 Financial Report Designer - Current Month and Year to Date Layout in the group Free Report Templates Group"That's awesome Stephen, thanks! Is there a way I can get these variables into an existing report? I have one that has custom groups that I need to create an additional report layout using these variables.
Thanks again!"
Debbi Silberberg replied to Stephen Coull's discussion MAS 90/200 Financial Report Designer - Current Month and Year to Date Layout in the group Free Report Templates Group"Does this report format work for 4.5?
I need to create a report with current month, current ytd, prior year month, prior year ytd - actual and budget.
"
Debbi Silberberg joined Admin's group
Free Report Templates Group
To get your Free Report Templates, be sure to join this Group in the BI Community.If you have Free Report Templates feel free to share them here.See More
Doug Walker replied to Debbi Silberberg's discussion Adding Text to a Row"Yes you're right. That's why you have to do the 0+0.
"
Debbi Silberberg replied to Maricela Cancino's discussion BI Tools in Excel"I don't know if this will help, or if it's still a problem, but it happened to me too. I had the BI Tools tab in Excel (I'm using 2010 32 bit) but no access to functionality. After much trial and error with the good folks…"
Debbi Silberberg replied to Debbi Silberberg's discussion Adding Text to a Row"Thanks for the reply Doug. I tried to add formula, but it wouldn't allow blank formulas. I guess I'll just add the text to the spreadsheet and hope I don't have to make any more changes."
Doug Walker replied to Debbi Silberberg's discussion Adding Text to a Row"I don't believe there is a way to add a 'Text' field as in a Report Heading to use in the Report Designer.
What I do is in the Report Designer I add a New Row Formula. The formula is 0+0.
I then can add it in the Rows.
It will,…"
Debbi Silberberg posted a discussionAdding Text to a Row
I have custom groupings. Id like to add text for Revenues, Operating Expenses, etc. How can I do that?Thank you.See More
Debbi Silberberg replied to Debbi Silberberg's discussion Create and Link does not save account mapping"Thanks for your reply Allan. Because there are custom groupings in my report, you actually have to save the excel spreadsheet to your desktop then go back to Designer and create and link. It appears, based on doing it several…"
Allan Brown replied to Debbi Silberberg's discussion Create and Link does not save account mapping"Try this, After mapping your accounts and saving. Run the report than minimize it, go back the report writer and high lite the report, right click and that save and link to template. I am a new user of MI. I had to map…"
Debbi Silberberg posted a discussionCreate and Link does not save account mapping
I've created custom account groups using the video posted here. Worked great except that when I create and link my template, it's not saving my mapping! I've done it twice so far, and created my financials...now it's all gone and I have to start again.I am using MAS90 v 4.5.2 and SMI v 4.5 and Excel 2010 32-bit. I don't think I've installed any of the updates for 4.5. Am I doing something wrong?Any help would be…See More
Debbi Silberberg replied to Diana M Laughner's discussion Combining Accounts in SMI financials"Hi, was this issue resolved? I am about to start creating a custom report for a client using their data on my computer. I'd hate to import it to the client site and have it not work.
Thanks"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Sage MAS Intelligence
Comment Wall (1 comment)
- At 1:15pm on August 13, 2011,
Ruth Gray said…
- Welcome to the BI Community Debbi
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
