Account Categories are groupings of General Ledger accounts that are typically reported on together. Account Categories were available in FRx, and also are available in Management Reporter. However, they have changed for the better!
If you were new to designing reports in FRx would you know what C:/19 means? Anyone? It could mean for this row use the Sales category defined in GP, but a new user to designing reports wouldn’t know that (Heck, I didn’t! I had to ask!) . No worries if you didn’t either, because in Management Reporter, that’s not how categories are defined. There are a two different ways that categories can be used when designing your reports.
First, when defining your GP company you can have them included as one of your dimensions. Management Reporter treats it just like any other dimension and it can be used not only in rows, but columns and reporting trees as well.
Figure 1: Including Account Categories for Report Building
Once Account Categories are added as an available dimension to a company, they are available for use in rows, columns, and reporting trees. In the following example, the Profit and Loss statement is built entirely on Account Categories. The benefit to using Account Categories in your report design are as new accounts are added in the General Ledger and saved to an account category, the will automatically be included on any existing reports. This helps reduce the maintenance of report design.
Figure 2: Profit and Loss with Account Categories
Figure 3: Account Category as a Row Modifier
Account Categories are another way Management Reporter tightly integrates with Microsoft Dynamics GP, providing ways to quickly build reports and reduce maintenance.
So what does this mean for those that use categories today in FRx? Since they are treated so differently in Management Reporter than FRx, categories are not migrated from FRx to Management Reporter. While this may mean re-designing reports, it also gives you the opportunity to think about how to use categories in different ways when designing your reports.