JUICE is a unique blog site that delivers compelling
content to those that influence and drive the Technology, ERP Systems, Food,
Retail and Microsoft Dynamics AX marketplaces
So in the last piece we looked at various analyses you could do through dimensions. In this section we’re going to specifically explore profitability statements, such as Item/Family/Brand; Customer/Group/Market Segment; Region/Territory, etc.
Ok, way back in Part 1 I mentioned that the General Ledger (GL) was the place where we dumped every piece of financial data because it was really the only place we trusted. Now, I realize a few of you snickered when you read that line. But if you think about it, the GL offered a few things:
So today we’ll explore three potential systems with which you can do profitability reporting:
Here is a good chart that lists pros and cons of each potential system. In the interest of space I won’t describe these in detail. But feel free to question any point in the comments section and I’ll explain further.
So, here are some things to consider in choosing between these systems.
1. What do you want to include in the P & L?
Below is a handy little checklist you can use to determine what to put in your P & L. I’ve done all of these at one point or another, including a few companies that had EVERY P & L line item allocated to Brands. That was definitely done in the GL. However, by completing this check list, you can begin to gauge what kind of tool you might need.
So to get you started, I’m gonna go out on a limb and guess a few of these that you’ll want in your P & L. I’ll check them off for you, the rest is up to you.
Now, how many check boxes do you have? If you have a lot of checks, then score one for the GL.
2. What BI tools and expertise do you have in house? How much time do you have?
I actually thought about putting BI as the first decision criteria. All things considered, it is MUCH more powerful than the GL or sales analysis reporting. In fact, I’ll probably get some serious hate mail from BI purists who scoff at the idea of comparing business intelligence to these clearly inferior, dated tools. It’s probably like comparing Sir Laurence Olivier to Keanu Reeves.
But if you have a lot of check boxes above, there will be investment of time, money and/or resources to do it. There are some good blogs on Business Intelligence on our Blog JUICE site, so I’ll leave the details to the experts.
By the way, you can build your cubes off of the GL data, so it’s not necessarily an either/or.
3. What level of detail are you looking for?
If you are looking at incorporating sales order transactional data, you’ll likely have to make comprises in going with the General Ledger. It’s doable…but tricky. You can also potentially do macro-level statements in the GL and a subset of this through sales margin reports.
So, hopefully this will at least get you started. As always, questions, opinions (and hate mail) are always appreciated. And by the way, Keanu Reeves is a fine thespian. No…really.
Part 4 – Account Structures: Implementation Considerations
The post Dynamics AX 2012 General Ledger Dimensions Part 3 – Profitability Statements: GL vs. Alternate Systems appeared first on J.U.I.C.E.
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics