Dynamics Blogger

Someone was asking me recently how to remove Analytical accounting completely from Dynamics GP 10 or 2010 for all companies. Here comes the detailed mechanism to do that. 1. Go to Add/Remove Programs 2. Select Microsoft Dynamics GP 10.0 (or Microsoft Dynamics GP 2010) from the list of programs and click change 3. Click Add/Remove Features 4. You’ll see Analytical Accounting is marked in select features window. Click Do not Install feature in AA Click Next and click finish. 5. Download the following scripts from Partner source or Customer source SQL Script 1 SQL Script 2 6. Run the above scripts in SQL Server Management Studio against DYNAMICS database. 7. Run the following statement against DYNAMICS Database in SQL Server Management Studio Delete DB_Upgrade where PRODID='3180' Delete DU000020 where PRODID='3180’ IMPORTANT: Please take backups of both databases and application folders prior to the uninstall process. ...

In Analytical Accounting, the dimensions and corresponding codes are always linked to the General ledger accounts. Analytical transaction are triggered only when a GL distribution is being made in any of the modules of GP which is supported by AA. Hence, We cannot post to AA without actually posting to GL Accounts. What if we have a situation to enter AA negative balances? We know that AA does not support entering negative balances. In this post we will see in which scenarios we will encounter the possibility of entering negative balances and how we can achieve this functionality through a workaround while respecting the business logic of AA. Scenario A client is migrating their balances to GP and as part of the migration, the account framework is changed to a new structure. As part of the new structure, they would like to maintain their employee loan balances in AA linked to 1 main GL Account for Employee Loans & Advances. In their old system on the contrary, each of the emplo...

Macro to enter new dimension codes in Analytical accounting module is provided below. TypeTo field aaTrxDimCode , ' CODE '   MoveTo field Inactive  # 'FALSE'   MoveTo field aaTrxDimCodeDescr   TypeTo field aaTrxDimCodeDescr , ' CODE DESCRIPTION1 '   MoveTo field aaTrxDimCodeDescr2   TypeTo field aaTrxDimCodeDescr2 , ' CODE DESCRIPTION2 '   MoveTo field aaNode   MoveTo field 'Lookup Button 3'   ClickHit field 'Lookup Button 3' NewActiveWin dictionary 'Analytical Accounting'  form aaTreeNodeLookup window Main   DblClickHit field '(L) TreeView' item 1  # ' NODE ' 1 NewActiveWin dictionary 'Analytical Accounting'  form aaTrxDimensionCodeMnt window Main ActivateWindow dictionary 'Analytical Accounting'  form aaTrxDimensionCodeMnt window Main   MoveTo field 'Save Button'   ClickHit field 'Save Button' ...

Say you have Analytical Accounting installed in your system and assume you have multiple companies within the Dynamics GP Application. Now, You have activated Analytical Accounting in one or some of the companies and not all the companies. However, You’d see that Analytical Accounting Posting Journal prints every time you post a transaction in companies for which Analytical Accounting is not activated though installed. This is not an issue or a bug and it is by design. In order to avoid this coming up every time we post the transaction, we can go to Posting setup and unmark the AA Posting Journal in each series we’d want to avoid the same. Next time, you post a transaction, it’d not appear.

In Dynamics GP10, When we uninstall Analytical Accounting feature in Add/Remove programs, we might get the following error while trying to open default Smart lists like Accounts, Customers, Vendors,Items. The same error will be displayed in the smart list lookups in the Cards windows for Accounts, Customers and Vendors. “ This Favorite Contains a column from a product(3180) not installed on this workstation. The following columns will not be displayed:Node ” Resolution : To avoid this message, Go to Administration => Setup => System Setup => Smart list Options, Select Accounts in Category drop down, Unmark the Node column. Continue the same for Customers,Vendors, Items categories if the same error is popping up in smart list lookups or smart list views. Note: This error was replicated on Dynamics GP V10 SP3 (10.00.1193)