Sage MAS Intelligence

[MAS90Ninja]

On the categories tab, there are Accounts Groups and you link the group to a GL category.

I would like to create an income statement with the following groups without changing all of the account groups in MAS 90:

Revenue 4000-4999

Human resource Cost 5000-5099

Office Overhead 5100-5700

Operating Expenses 6000-6999

Technology 7000-7999

Total Expenses

Depreciation 8000

Amortization 8500

Operatin Income

Other 9000

Net Income

If the solution is to change the account groups in MAS, then we may as well just use the standard MAS reports.

Thanks!

[accountingnerd]

The way we were taught to do this is to create the statement using the basic SMI template, ungroup the rows, and then use Excel to move the rows of data to the place where they should be, and then regroup them once they are in the appropriate place.

SMI's groupings are just a way to get you started. Of all the financials that I've done for clients, not one has kept the vanilla SMI report. Hope that helps.

[MAS90Ninja]

What exactly do you mean by "ungroup the rows". Please eloborate.

[MAS90Ninja]

If what you mean by ungroup is to not enter an "8", "12" etc to link each group to a financial stmt category, then I must be missing something. It seems to me you must use the groups that are defined in MAS GL and then link each group category to a pre-defined category such as "revenue" (code 8).  Since there are a pre-defined # of categories, this limits the detail and formats available. 

[accountingnerd · Accepted solution]

Sorry for the delayed response. I've been out of the office for a little while. What I mean is that you ungroup items on the financial statement itself (using Excel's Group and Ungroup feature), and then you format the financials however you like. You can move things around as much as you want, and then re-link the template.

If you want to do anything else with the grouping, it sounds like we need to wait for the SMI that is coming out with version 4.5, which should have reporting trees and other grouping mechanisms.

Hope that helps.

Aaron

[MAS90Ninja]

Thank YOU! Works great for my purposes as of now. The ungrouping and the re-grouping is exactly what I needed.

[stephencoull]

You can take a look at this video posted on the BI Community that shows how to create customized groupings for financial reports using the Sage MAS Intelligence Report Designer.

http://community.alchemex.com/group/sagemasintelligence/forum/topics/how-to-convert-your-frx-reports...

[accountingnerd]

Stephen,

That was a very helpful video, and provided a lot of great insight. Thanks for sharing that. Now, I've taken quite a few of the Sage Intelligence courses that were offered through Sage, and I don't recall any of them showing the Alt+D function. Is that a documented feature?

Also, another question this raises, is how could we do this with the standard reports? The designer's great, but I have some smaller clients who don't have the desire to spend the money on the designer. I've done things manually for them in the past, but if there's a better way, I'm all for it.

Thanks again!!

Aaron

[stephencoull]

Hi Aaron,

The ALT D functionality is not currently a documented feature aside from the video post provided.

This functionality is not available in the standard financial reports, so applies only to the financial report designer. Sage have been running a promotion that bundles the SMI "Connector + Report Designer" for the price of the Connector, a saving of $1000, so worthwhile invetsigating this as an option, as it has been extended to the first QTR of fiscal 2012.

A final point, is that Reporting trees will be available to the Report Designer only, so strongly recommend that customers and partners start moving in that dorection.

[accountingnerd]

Thanks for the feedback and information. I was not aware of the extended promotion. I have a client who missed the september deadline, and they'll be happy to hear that it is still available.

Aaron