How to put Ax 2009 machine back to a clean state (remove the usr layer)

1. Stop the AOS (default service name is AOS50$01 for AX5).


2. Delete the user layer aod file (…\Microsoft Dynamics AX\50\Application\Appl\AXDB_App\axusr.aod) and *.aoi files.


3. Delete the metadata file in client %userprofile%\AppData\*.auc


4. Start the AOS.


5. Run AX client and do a synchronize on the Data Dictionary node on the AOT tree.

Reporting Extension Server URL Validation problem

1. 1.    Check the Reporting Services (Started or not) from the services.
2. 2.       Check the reporting services configuration manager from SQL server 2008 configuration tool and add service account as business connector account.
3. 3.       Browse the Reportserver and Report manager URL from RS configuration manager.
4. 4.       Copy the URL and paste same into the above reporting servers window.
5. 5.       (You can also check that weather your url in Reporting server is right or not.
6. Update URL https to http.

Service Tax Hotfix for INDIA localization (KB2554055)

Service tax patch affects only GLP and SYP layer.

When we run the axupdate.exe, it asks for a configuration file.

Then it auto run itself.

Even if it is successfully installed,

It always skips to import the following few classes:

1.       InventCostInputAmount
2.       InventLedgerConflictMessage
3.       InventLedgerConflictMessageTest
4.       BlackListTransfer_IT

Then we need to go to the extracted files of that patch and find the XPOs related to GLP and SYP layer.

From these XPOs Select only the above selected classes and Import them.

You may find few errors related to the following classes:

1.          InventUpd_Physical
2.           InventQuarantineUpdStartUp
3.           InventMovement

Error may say that InventUpd_Physical is not a class.

Double click that error and locate the Class.

You will find that there are some changes in the class in usr layer.

Just export and import the class.

It will solve all the related errors too.

In addition to these above classes you may get errors in following classes too:

1.        TaxSalesQuotation
2.        TaxSales

Similarly here also you need to just export and import the Tax Sales class to resolve the related errors.

Hope it helps!!!

Re Indexing of Database by Scheduling

Open studio management >> Go to Maintenace Plans Right click and select “Maintenance Plan Wizard”

    Enter the name and description of reindexing process 

   Select Rebuild Index option

   Select the database name on which you have to run Indexing process

   Select newly created maintenance plan , right click it and select “Modify” option

   

    Select the scheduling option which is having calendar symbol you will get following window

   You can Disable/Enable the reindixing  Job from Jobs node in SQL Server Agent.

Go To Main Table on Custom Field On Form

While customizing some of the forms in Dynamics Ax 2009 i come across to create a "Go To Main Table" functionality on the custom field placed on the form.
To Execute this i used following code at the design part (field>> methods>>jumpref method)

Code :

public void jumpRef()
{
    Args        args;
    FormRun     fr;
    ;

    args = new Args(formstr(SheCRTermMaster)); //TableName
    args.lookupField(fieldNum(SheCRTermMaster, TermID)); //Fields of Table
    args.lookupField(fieldNum(SheCRTermMaster, Description));
    args.lookupValue(this.text()); //Optional

    fr = ClassFactory.FormRunClass(args);
    fr.init();
    fr.run();
    fr.detach();
}

Management Reporter for Microsoft Dynamics ERP known issues

Management Reporter 2012 for Microsoft Dynamics ERP
486022 - DataMart provider does not calculate the Begining Balance correctly with BB Row Modifier
488159 - Designer crashes when you click some building block groups window buttons when application service is not available
488281 - Missing Account Analysis - Tree with @ANY does not show missing values
485632 - Missing Account Analysis - switching all (no filter) to single value after manual refresh can crash
485641 - Missing Account Analysis may crash after switching building block group
488213 - Designer crashes when user opens a report definition set to a company that the user does not have access to
488299 - MR role is incorrect after integration if the AX user has multiple roles that have different MR permissions
488201 - AX 2009 attribute filtering is not working for financial and account level for account category
488300 - Viewer crashes when you try to edit charts or comments deleted by another user
488193 - Entering incorrect logon information when you configure SL provider causes Configuration Console to crash
487079 - Entering incorrect logon information when you configure AX 2012 provider causes Configuration Console to crash
488146 - Attribute selection on Account Type or Account Category returns no data for Account when Account has no matching type/category
471771 - Double-Line together with other line formats can cause layout issues with other elements in the report
484633 - MR with Dynamics GP AA may miss data if multiple currenies are used
475203 - Dynamics GP AA report fails when AA budget and only AA dimensions are used
488364, 488370, 488371, 488286 - Dynamics AX user integration and multiple AOSs
484670 - Unchecking “Display reports with no active rows” option in Management Reporter does not suppress the printing of reporting units
484025 - IF THEN ELSE calculations do not work when specifying a result column in the THEN part of the calculation
485552 - Font color is ignored with Rolling Forecast Headers
482066 - Unable to use X:BASE for defining periods

Management Reporter for Microsoft Dynamics ERP 2.0.1700.66 (SP2 Update)
484938 - MR Performance with Dynamics AX decreases with the use of Trees.

Management Reporter for Microsoft Dynamics ERP 2.0.1700.31 (SP2)  Microsoft Forecaster Data Transfer Tool 2.0.0.0
476528 - Forecaster Data Transfer Tool throws incorrect syntax error when a database exists with a hypen character.
483850 - The Generate Report button hangs (unresponsive) when report has multiple rows.
482131 - The company calendar couldn't be retrieved from Dynamics AX 2009 when multiple years have closing periods in the same year.
484501 - Unable to run reports for companies other than the default company for Dynamics AX 2009.
483621 - Unposted data will show incorrectly with Dynamics GP for YTD columns
484631 - Wildcards in ranges return incorrect data for Dynamics AX 2012.
484460 - Unable to load the calendar in Dyanmics AX 2012 if more than one period is in the same month.
480002 - Some attribute filters with transaction detail return zero for totals with Dynamics AX.483478 - When using CPO in a "Financial Dimension + Worksheet" link the CPO will only return results for the first column.
475151 - Error logging into a company when an AA dimension has the same name as an account segment in Dynamics GP.
472368 - Error logging into a company when a User Defined field has the same name as an account segment in Dynamics GP.
470555 - When you run the Migration Wizard in Validate Only mode, cached credentials prevent validation.
470284 - Explicit dimensions are not written to the XBRL instance document.
470005 - The Designer must be restarted for style changes to take effect.
427786 - XBRL notes and footnotes are not written to the XBRL instance document.

 
Microsoft Forecaster Data Transfer Tool 2.0.0.0
476528 - Forecaster Data Transfer Tool throws incorrect syntax error when a database exists with a hypen character.