Posts

Showing posts from 2012

Dynamics AX 2012 Overview

Image
It's quite some time that we have Dynamics AX 2012 into the market and it is no surprise that it's creating history with respect to wide market adaptability and acceptance of the fact that it is truly a global solution. In this piece of article  I present a bird's eye view of Dynamics AX 2012.   Microsoft Dynamics AX 2012: Overview Microsoft Dynamics AX 2012 is a complete ERP solution that offers comprehensive and core ERP functionality for financial, human resources and operati ons management. It's truly a global solution that is scalable and agile. The solution is made industry focused by embedding core functionality for manufacturing (process, discrete and lean), distribution, public sector, retail and service industries.   Dynamics AX 2012 Functionality In a nutshell, Dynamics AX 2012 focuses on the following functionality Financial Management & Compliance Business Intelligence & Reporting Collaboration Supply Chain Management Sales

Dynamics AX 2012 Modules

General Ledger Dynamics AX 2012 provides robust consolidation of financials for several subsidiaries. It is not necessary that the subsidiary databases must be separate and can reside within the same database. In Dynamics AX 2012, Allocation or distribution of monetary amounts can be made to one or more accounts or account and dimension combinations based on a preset allocation rules. AX 2012 permits two types of allocations. Fixed Allocation Variable Allocation Settlement of transactions between ledger accounts is available in Dynamics AX 2012  Year-end closing can be performed within the system so as to update the opening balances for the next year. Tools for forecasting cash flow and currency requirements to estimate company future cash needs exist in General ledger functionality of Dynamics AX 2012.  Financial statements can be extracted from within Dynamics AX 2012 or using Management reporter tool. Accounts Payable 1.  In Dynamics AX 2012, vendor

Analytical Accounting Transaction Dimension code lookup error

Image
I was confronted with a strange Analytical Accounting error in one environment where Microsoft Dynamics GP 2010 with service pack 2 is deployed. Except for "sa" user, the rest of the users get an error whenever they try to open the dimension code lookup window. No results are displayed into the Dimension code. The error is " cannot drop the table ' ##Validate TrxDimRelUser.CDB' " where User is to be replaced by the user name and CDB is the comany database ID. There is no issue with the dimension relationships and user security is also taken enough care to be setup properly. I tried the service pack 3 to see if I can be lucky on this one. Yes, It did resolve the issue and the users could access the dimension code lookup window as normal.

GP2010 Upgrade Error

Image
The GP2010 upgrade from Dynamics GP 10 (SP4 >> 10.0.1368 Build) failed during tables update in a recent upgrade process. The upgrade was failing while updating the following tables. 1. GL10110 2. GL10111 3. GL70500 4. GL70501 This issue is resolved in the following manner 1. As soon as the upgrade fails with the above errors, Drop each of the tables above by going to SQL using DROP Table statement 2. Continue the upgrade 3. When the upgrade comes to the stage of creating views, it fails again because it cannot find these tables based on which certain views are to be created 4. Close the Dynamics GP utilities. 5. You can copy the Create Table scripts from any running GP2010 version for the above tables and create these tables in the current company. If you cannot do that, no issues. Find the download option here for the 4 tables. Just execute the scripts against the company database. http://www.box.com/s/3v5rmd7v7epc9fyvgto9 http://www.box.com/s/hi5sjpntiecfdgru4u7g htt

Service Call Management Process Chart

Image
A sample service Call Management process chart is provided below