Update user info after restore database AX 2012

After restore the AX Database from other environment, may experience can’t log into AX issue. Run the follow SQL Query against original database and new database to update the user information.

Existing DB
select SID, NETWORKDOMAIN, NETWORKALIAS, * from UserInfo where Id = ‘Admin’

Restored DB
update userinfo
set
networkdomain = ‘YourDomainName’,
networkalias = ‘Administrator’,
SID = ‘S-1-5-21-2749077036-747833739-1932402455-500’

where ID = ‘Admin’

Read how to get SID 

How to Get SID of logged in user

It is require to get SID of the user at the time of changing user details after restrore AX database.

Open Command prompt

run command, whoami /user

AX 2012 Compile Application using axbuild command

Compile Application using command prompt

The new way to compile AX application through command prompt is introduced in AX 2012 CU7. This is much faster than the traditional way of compiling. It takes approx.. 1-2 hours to compile depends on your server

1. Run command prompt by Run As Administrator
2. go to  C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\
3. Use command to run compilation. axbuild.exe  xppcompileall /s=01 /altbin="C:\Program Files (x86)\Microsoft Dynamics AX\60\Client\Bin"

There are other options for running axbuild command refer msdn

Convert date to UTC datetime x++ AX 2012

Convert date to UTC datetime x++ AX 2012

Many times its require to convert UTC date time to the user timezone and date time to UTC

Perfect example given on the msdn in the link below:

https://msdn.microsoft.com/en-us/library/cc584924.aspx


This helped you..!! comment below: :)

Microsoft Dynamics AX 2012 R3 System Requirements

System Requirements for Microsoft Dynamics Ax 2012 R3 Updated by Microsoft. For this purpose Microsoft uploaded a new document , you can download it from this link

http://www.microsoft.com/en-pk/download/details.aspx?id=11094

Use table method in Lookup x++ AX 2012

Create lookup using table method on Dynamics AX 2012

Many time it is require to show field on lookup x++ in Dynamics AX 2012 which is not directly on the table or table field. In that case table method will be useful in lookup to show relative data. Only problem is it won’t be filtered. 

Here is the code to get data from table method in lookup.

public void lookup()

{

    Query                   qr = new Query();

    QueryBuildDataSource    qbds;

    QueryBuildDataSource    qbdsJoin;

    QueryBuildRange qbr,qbr1;

    QueryRun                qrun;

    SysTableLookup          sysTableLookup = sysTableLookup::newParameters( tableNum(ProjTable), this);

    ;

    qbds= qr.addDataSource( tableNum(ProjTable));

    qbds.joinMode(JoinMode::InnerJoin);

    qbds.relations(true);    

    

    sysTableLookup.addLookupfield( fieldNum(ProjTable, ProjId));

    sysTableLookup.addLookupfield( fieldNum(ProjTable, Name));   

    sysTableLookup.addLookupMethod(tableMethodStr(ProjTable,YourMethod));    

    sysTableLookup.parmQuery(qr);

    sysTableLookup.performFormLookup();

}

Method on ProjTable

public display str 20 YourMethod()

{

 // code 

}

This helped you..!! Then hit the ads on the page..:)

The view has been disabled. Configuration key on following table(s) is off AX 2012

Cannot execute a data definition language command on Internal organization attributes (RetailInternalOrgAttributeGroupAttribute).

The view has been disabled. Configuration key on following table(s) is off .

Solution:

1) enable the configuration key for the retail. (find the configuration key with  RetailInternalOrgAttributeGroupAttribute).

2) if this is warning and you are not using the Retail then you can skip this.

AX 2012 get the list of SSRS report in file

Open MS Dynamics AX 2012 Management Shell 

1) get ther reports 

$reports = Get-AXReport -ReportName *

2) save the list of reports to txt file

$Reports | Select-object Name, ChangedDate |out-file c:\ListAllSSRSReport.txt

Management reporter 2012 version details

Management reporter 2012 version details as below:

Release	Release date	Version #	Features	GL Versions
MR 2012	March 2012			AX 2012 AX 2009 RU8+ GP 2010 NAV 2009 SL 2011
RU1	April 2012	2.1.1028.0	Quality release	AX 2012 AX 2009 RU8+ GP 2010 NAV 2009 SL 2011
RU2	July 2012	2.1.1029.3 or 2.1.1030.2	SQL Server 2012 support Currency Translation for Dynamics GP 2010 Legacy provider	AX 2012 AX 2009 RU8+ GP 2010 NAV 2009 SL 2011
RU3	November 2012	2.1.1031.4- 2.1.1032.5	Web viewer Data mart for GP 2010	AX 2012 AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011
RU4	January 2013	2.1.1033.3- 2.1.1033.37	SL 2011 data mart AX Budget Planning support  Quick links in web viewer	AX 2012 AX 2012 R2 AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011
RU5	April 2013	2.1.1037.12- 2.1.1037.17	Collapse detailed report into summary view  Default report link location Web viewer as default viewer Management Reporter Report Designer in Dynamics AX 2012 menus (AX 2012 R2 CU5) Rework transaction detail storage Drill back to Dynamics GP from data mart in desktop viewer  Languages: Brazil,Japan	AX 2012+ AX 2012 R2 AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011
CU6	July 2013	2.1.6041.36	Full language support  Single report link for report group  Report group enhancements 1 14 default reports Vendor, customer and audit attributes	AX 2012 CU4+ AX 2012 R2 AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011
CU7	October 2013	2.1.7044.43- 2.1.7045.12	Drill back to Microsoft Dynamics with Management Reporter web viewer (AX 2012 R2 CU7, GP 2013, SL 2011)  Management Reporter in Dynamics AX 2012 install (AX 2012 R2 CU7)  Currency Translation for Dynamics AX 2012 (AX 2012 CU6 or AX 2012 hotfixes) Dimension order for Dynamics AX 2012 (AX 2012 R2 CU7)  Fixed Asset Acquisition Date attribute for Dynamics AX 2012 XBRL support for Germany	AX 2012 CU4+ AX 2012 R2 AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011
CU8	February 2014	2.1.8000.44- 2.1.8001.0	Auto text in CALC columns  Currency translation for Microsoft Dynamics GP 2013 data mart  Side by side reports  Attributes for Chinese financial statements  Line numbers on reports  Auto fit default width in columns Excel enhancements  Business Analyzer for Microsoft Dynamics AX  View web viewer reports for Azure service bus	AX 2012 CU4+ AX 2012 R2 AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011
CU9	May 2014	2.1.9001.11	View a list of previous month’s reports and open them in the web viewer Refresh a report in the web viewer  Publish a report from the web viewer Headers and footers are shown by default in the web viewer Enhanced data detection in the Configuration Console  Support for dynamically displaying currency symbol, currency code and currency description (AX 2012 CU6 or AX 2012 hotfixes, SL 2011, GP 2013)  Support for SQL Server 2014  Additional fixes for product defects	AX 2012 CU4+ AX 2012 R2 CU1+ AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011
CU10	September 2014	2.1.10001.112	Export row-based TOT formulas to Excel  An additional parameter has been added to control header and footer options for exporting to Excel in page view vs. normal view Removed account category from showing in the viewer and exported reports Improved generation and viewing performance if using SQL Server 2014 Enterprise Edition Ability to include or exclude companies for reporting in the Dynamics GP data mart Ability to exclude Analytical Accounting details in the Dynamics GP data mart  Improved integration performance for large ERP databases  Additional fixes for product defects	AX 2012 AX 2012 R2 CU1+ AX 2012 R3 AX 2009 RU8+ GP 2010 GP 2013 NAV 2009 SL 2011 SL 2015
CU11	December 2014	2.1.11000.32	Ability to select the closing period(s) you wish to include in your report for Microsoft Dynamics AX Currency Translation fixes for Microsoft Dynamics GP Improved performance for integration and report generation Ability to drill into a Total row from within the Web Viewer Companies can be enabled or disabled for reporting within Microsoft Dynamics GP 2015 Companies can be enabled or disabled for reporting within Microsoft Dynamics SL 2011 and 2015 Additional fixes for product defects	AX 2012 AX 2012 R2 CU1+ AX 2012 R3 AX 2009 RU8+ GP 2010 GP 2013 GP 2015 SL 2011 SL 2015

Add field on Purchase order confirmation report AX 2012

Add field on Purchase order confirmation report in Dynamics AX 2012

There is requirement to add field on PO lines and same for the confirmation report in Microsoft Dynamics AX. It’s not the straight away to add field on the SSRS report. It requires to add field on other objects (table/view/query).

On PurchPurchaseOrder report it uses the PurchLineALLVersions view to get the details of the PO on the PurchPurchaseOrderDP. So follow the below steps to add field on PurchLineAllVersions view.

1. Add field on the PurchLine Table
2. Add field on the PurchLineHistory Table
3. Now, Refresh or Restore the queries used for PurchLineArchivedVersions and PurchLineNotArchivedVersions as this have dynamics field property to “Yes” our new fields should be added automatically on this queries and Verify the field is added on the query.
4. Now, Restore the views PurchLineArchivedVersions and  PurchLineNotArchivedVersions.
5. Add field on PurchLineAllVersion, here you have to add field manually as the dynamics field property is set.
6. That’s it, now use the field on the PurchPurchaseOrderDP to have on report. You also have to add field on tmp table.

This helped you..!! Then comment below..:)