Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
SSRS and SSAS Integration
I am in finance and my company is considering a Dynamics AX 2012 implementation to function as our g/l, a/p, consolidation, and financial reporting tool. I am on the forum to obtain some feedback from users of AX 2012 from the accounting/finance role to understand their experience with AX 2012.
My company is a holding company for a multiple entity structure that has some intercompany activities between many of its legal entities. I'm searching for a solution that can effectively consolidate the results as needed without being a large, complex tool (such as Hyperion). Does anyone have experience consolidating multiple entities in AX 2012 and would be able to provide feedback on that experience. The consultant that I met with last month believes it will meet our needs and the demo looked positive, but it's always good to hear 'real world experiences' to confirm our initial thoughts.
One further complication is that our org structure is decentralized from a systems standpoint. We have legal entities that use a variety of general ledger systems and they will not follow us onto Dynamics AX. Our current consolidation/financial reporting tool is an old version of Hyperion Enterprise. Our legal entities load/submit a file each month with the results into Hyperion. As we'll want to use AX 2012 for our consolidation and financial reporting, we'll want our legal entities to be able to continue to submit files into AX 2012 and consolidate these results in the tool. We do not receive transaction level information from our entities, but instead receive higher level information currently in Hyperion and expect that to continue in AX 2012. Does anyone have experience with one of their entities doing their g/l work outside of AX 2012 and submitting periodic results into AX 2012? I've been told that they can do this, but again it would be good to hear from real world folks that have successfully implemented this in practice.
Thanks in advance for any thoughts. We are not a complex enough organization to support a large, bulky SAP/Oracle type system and this seems to be a good fit, but I do want to get comfortable with the ideas described above.
So, here is some info on the topics you've touched.
1) Finance (specially consolidation) is very well thought out in ax 2012. Although the process hasn't really changed a lot from previous versions, the logic behind the whole Finance module has been well thought through. Not to mention the other modules have been significantly refined.
2) Intercompany activity between multiple legal entities within AX is nothing new. It did it in previous versions as well. However, I notice that you mention that you are only interested in bringing over periodic Summarized transactions into AX 2012. Which is cool...I've seen that at a few places. But it makes me question, why wouldn't you just do a intercompany transaction outside of AX before bringing it into AX? That way, there is no confusion to the auditors on why it was done later than when the transaction actually took place? Just some food for thought.
3) Org structure, is awesome in AX 2012. It has been created keeping in mind various business processes. You can have an org structure just for your departments/cost centers/legal entities etc. Plus, you can assign what purpose they serve, like security/centralized payments/org chart/audit control etc.
This brings me to my final assessment: you're looking to use AX 2012 as a repository and not as your primary operating software. For the purpose you are looking for, you are barely touching the tip of the iceberg and it makes me wonder, why you wouldn't want to use the FULL potential/functionality of an ERP system when it meets most (if not all) of your requirements, unless you're planning to do so in the future. AX is not too big and it's not too small. But if you're looking to keep the current business process and are not looking to make ANY changes, there's no point using a brand new (not to mention somewhat expensive) software and use it as a consolidation and reporting tool only.
I don't mean to persuade you to not use AX 2012, but I want your business to re-think whether it can use some change and perhaps improve/streamline their business processes. I hope I was able to shed some light on the bigger picture here.
Just my two cents.
Yes we have done a similar consolidating multiple entities in AX 2012 / integrating external GL data outside AX & generating reports in AX for our clients. If you are intersted please drop an email to learn more.
We have Implementd ax 2012 for a group primarily for the consolidation and this works well especially with management reporter for drill down reports
However also consider a Microsft recommended third party solution Prophix for which my company is also a certified implementation partner
Usually the decision is affected my other factors such as managing the budget process, complexity of multi level structure, joint ventures, inter company eliminations , source erp systems and COAs etc and how many users of what type are involved at what stage
Consolidation with currency conversion and complex COAs can involve significant data processing and the ability to pass correction entries back to source data is important
Tools like abdicating are also useful for detaileed reconciliations.
Hi Mark, we have a similar setup, and we have found a nice 3rd party solution. Drop me an email for more details. email@example.com
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13