Posts

Showing posts from April, 2012

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.