Wednesday, August 17, 2011

Power of ERP + Simplicity of Excel = AX 2012

I was reading an article about a Survey result shows how the ERP users are more eager to use MS Excel more than ERP application, because most/all ERP software in many times are cumbersome and not easy to use, especially if they are old, complex, and have tons of function such as SAP and Oracle.

in the same context i was thinking about the huge effort that Microsoft is doing to Marrying AX 2012 (which contains structure data) and MS Excel (contains unstructured data and make this marriage simple and Easy) (Watch the link Inside Microsoft Dynamics AX 2012 - Office )

This makes you feel that "Dynamics AX 2012 Powerful. Agile. Simple." slogan is not just slogan for marketing consumption, but it’s a true fact!!

That’s why I’m convinced: Power of ERP + Simplicity of Excel = AX 2012

Mahmoud Anass

Monday, July 25, 2011

Some benefits of AX SSRS over MorphX reports

- SSRS support Graphics, Charts, while MorphX is poor in that area.
- SSRS Reports could use the OLAP Cubes, while MorphX Cannot
- SSRS Can Access any other Database while it’s difficult for MorphX
- SSRS employee WYSIWYG (What you see is what you get).
- SSRS Could be accessed from Client or EP
- SSRS supports email subscriptions, and snapshots.
- SSRS could be exported directly to Excel & xps format
- SSRS supports drilldown and sub report.


Thursday, June 23, 2011

How to run AX 2012 VPC

I've found an interesting link about how to run AX 2012 VPC on Windows 7 withouth the need for Windows 2008 Hyper-V. Thanks for the blogger.

How to run AX2012 HyperV on Virtualbox (Step by step guide)

Monday, June 20, 2011

Opening Balance Uploading

The best method for uploading opening balance for GL/AP/AR is to use the General Journal by preparing a Journal contains the Trial Balance and replace its Ledger Accounts that are connected to the posting profile of Sub module/Sub ledger by their respective Sub ledger Accounts, to make it more clear let me show you an illustration.
Ledger Account No. 21001000 represent Accounts Payable and its balance = $ 1,000 which is a result of 2 invoices, one for Ven001 = $300 and the other for Ven002 = $700.

In the Journal that contains the Trial Balance that you are preparing for the uploading, you will remove the Ledger Account 21001000 line, and replace it with the two lines of type Vendor for both the Vendors Ven001 & Ven002, you could also specify the document date (to maintain the ageing information) and the Invoice# .
Other benefits you could gain from this method by specifing the actual currency of the Invoice and its exchange rate (Note: Invoice Amount in other that company primary currency must be equal to the AmountMST, and this is achieved by the proper exchange rate).

By this way you won’t need the 999 Ledger Account (You will use “999” account only in the uploading of Inventory opening Balance).


Saturday, June 18, 2011

Is Microsoft Dynamics AX6 - SAP-Killer?

I read this post and I liked the way the blogger is trying show that SAP could be #1 because of the "Law of perception" but in fact AX could outperform SAP (depending on facts & numbers), Current SAP market share %31 and Dynamics Market share is %15 althought 5 years back SAP was %47 and Dynamics was %3. (to read the full article)

Sunday, February 6, 2011

Why Microsoft did an fundamental change to AX 2012 (AKA AX 6) architecture?

In this post "Engineering the future, our next milestone…" that was done by Kees Hertogh, Director, Product Management, Microsoft Dynamics AX, Kees is trying to highlight how Microsoft is driving the Generational Shift in ERP by its next release of AX 2012.

This is a loud message from Microsoft express its determination to position itself to be #1 in the ERP market. It reminds me when Microsoft entered into Cloud Computing technology even many companies precede it such as Amazon, IBM, and Google but by its persistence and determination (thanks to the huge R&D budget and its pioneers’ minds) it succeeded to across them and to be ranked as #1.

Mahmoud Anass