Tuesday, July 29, 2014

Lookup Ways in Ax 2009

Lookup:  A lookup form is a small form that you use to select a value for a control. To open a lookup form, click the lookup button (Lookup button) that appears with the control. To select a value, double-click the record that you want to appear in the control.

1.By Autolookup


 2. By Method(SysTableLookup)
     DataDictionary/Tables/KMAction/actionTypeIdsysTableLookup
     


 create a lookup form to a control
    http://msdn.microsoft.com/EN-US/library/hh185372.aspx

3.  By EDT


  in AX-2012

1. First create New EDT.

2.Create New Table Name is "TestParent" Table, then drag and drop the newly created EDT in "TestParent" Table

3.Create Index for new created EDT in "TestParent" Table , the properties on index is AllowDuplicates to No and Alternativekey to Yes.

4. Then select the "TestParent" Table and right click on it select properties sheet set the "PrimaryIndex" property i.e. the newly created index.

5. Then go to EDT and right click on it, select property sheet then go to "ReferenceTable" property set it to "TestParent" Table Name.

6. Create a Second Table i.e “ChildTable”.

 7. Then Drag and drop the EDT, then it will prompt the one dialog box, in that dialog box click Yes button then lookup will created on that field.


4. By TitleField1 and TitleField2

5. By Relations

Friday, July 25, 2014

"You are not a recognized user of Microsoft Dynamics AX. Contact your system administrator for help".

i have restored a database from one environment to another environment. after that i am trying to open Ax showing a error ""You are not a recognized user of Microsoft Dynamics AX. Contact your system administrator for help".  "


solution:

http://blogs.msdn.com/b/axsupport/archive/2011/09/02/steps-to-restore-an-ax-database.aspx


find out SID:

go to run-->type regedit


 

Thursday, July 3, 2014

software and hardware requirements for ax 2012

Network Requirements:
Microsoft Dynamics AX can operate on networks that use Internet Protocol Version 4 (IPv4) or
Internet Protocol Version 6 (IPv6).
network response time:
Client to AOS: 100 megabits per second (Mbps)
AOS to DataBase: 100Mbps

Domain requirements

  1. Computers that run Microsoft Dynamics AX components must belong to an Active Directory domain,and Active Directory must be configured in native mode.
  2.  Computers that run Microsoft Dynamics AX components must have access to other computers in Active Directory. These computers may be either in the same domain or in another trusted domain.
  3. The domain controller must run in Windows 2008 mode or later.
  4. To support e-mail alerts in Microsoft Dynamics AX, an SMTP (Simple Mail Transfer Protocol) server must be present in the environment.
Hardware Requirements:

Hardware that is required to install and run the AOS and the Microsoft Dynamics AX client.
Processor: Intel Pentium/Celeron family or compatible Pentium III Xeon or higher processor. We
recommend a processor speed of 1.1 GHz or higher.
RAM: 4 GB or more of RAM for server computers.
            2 GB or more of RAM for client computers.
Monitor: Super VGA (1024x768) or higher resolution monitor
Other: A DVD drive is required for an installation from a DVD.

S/W requirements for all computers:
The following software must be present on a computer before any Microsoft Dynamics AX components
can be installed:
  • Microsoft .NET Framework : Most Microsoft Dynamics AX components, including the Setup wizard, require .NET Framework 3.5 with Service Pack 1.
For those components that require .NET Framework 4.0 or .NET Framework 4.5, it is listed as an
additional requirement in this document.
  •  Microsoft Windows Installer 3.1 or Windows Installer 4.0
Supported server operating systems: 
The server operating systems that are supported for Microsoft Dynamics AX 2012 components.
Windows Server 2012 Standard Edition or Datacenter Edition
Windows Server 2012 is supported by default with Microsoft Dynamics AX 2012 R2. To use Windows Server 2012 with an earlier version of Microsoft Dynamics AX 2012, you must install cumulative update 5 for Microsoft Dynamics AX
Windows Server 2008 R2 Standard Edition,Enterprise Edition, Web Edition, or Datacenter
Edition
Windows Server 2008 Standard Edition, Enterprise Edition, Web Edition, or Datacenter Edition, with
Service Pack 2 (Only 64-bit versions of Windows Server 2008 are supported.)
Software requirements for server computers:
  1. Databases
  2. Application Object Server (AOS)
  3. Enterprise Portal
  4. Enterprise Search
  5. Help Server
  6. Microsoft SQL Server Reporting Services extensions
  7. Microsoft SQL Server Analysis Services configuration
  8. Web services on Internet Information Services (IIS)
  9. Synchronization proxy for Microsoft Project
  10. Synchronization service for Microsoft Project
  11. Management utilities
Software requirements for database servers
Microsoft SQL Server 2012, Standard Edition, Enterprise Edition, or Business Intelligence Edition.
Service Pack 1 (http://www.microsoft.com/enus/download/details.aspx?id=35575) for Microsoft SQL Server 2012 is supported with the following updates:
 Cumulative update 1 for Microsoft Dynamics AX 2012 R2
 Cumulative update 5 for Microsoft Dynamics AX 2012
SQL Server 2008 R2, Standard Edition, Enterprise Edition, or Datacenter Edition.
Service Pack 1
(http://www.microsoft.com/download/en/details.aspx?id=26727) is supported, but it is not required unless you are installing Reporting Services extensions.
Service Pack 2
(http://www.microsoft.com/download/en/details.aspx?id=30437) is supported with cumulative update 4 for Microsoft Dynamics AX 2012
SQL Server 2008, Standard Edition or Enterprise Edition, with Service Pack 1.
Service Pack 3 is supported with cumulative update 4 for Microsoft Dynamics AX 2012.
Application Object Server (AOS)
 .NET Framework 4.5 is supported by default with Microsoft Dynamics AX 2012 R2, and with cumulative update 5 for Microsoft Dynamics AX 2012
–or–
.NET Framework 4.0, with the hotfix from Knowledge Base article 2390372
 SQL Server 2008 Native Client
Enterprise Portal
1 .Web server role
2. IIS 7.0, IIS 7.5, or IIS 8.0 (supported only with Microsoft Dynamics AX 2012 R2)
3. ASP.NET 2.0
4.Microsoft SharePoint Foundation 2013 (supported only with Microsoft Dynamics AX 2012 R2) 
   –or–
  Microsoft SharePoint Server 2013, Standard Edition or Enterprise Edition
  (recommended) (supported only with Microsoft Dynamics AX 2012 R2)
  –or–
 SharePoint Foundation 2010 
–or–
SharePoint Server 2010, Standard Edition or Enterprise Edition (recommended)
5. SQL Server 2008 R2 Analysis Management Objects (AMO)
Reporting Services extensions
1.Microsoft SQL Server Reporting Services 
To create a PowerView report that displays data from an analysis cube, you must use SQL Server 2012
Reporting Services with Service Pack 1 and cumulative update package 4
(http://support.microsoft.com/kb/2833645) or a later update for SQL Server 2012. Reporting Services
must be installed in SharePoint integrated mode.
 If you are using SQL Server 2008 Reporting Services, Service Pack 2
(http://support.microsoft.com/kb/2498535) or a later update for SQL Server 2012 is required.
2.Windows PowerShell 2.0
Analysis Services integration
To create a PowerView report that displays data from an analysis cube,you must use SQL Server 2012
Analysis Services with Service Pack 1 and cumulative update package 4
(http://support.microsoft.com/kb/2833645) or a later update for SQL Server 2012.
 If you’re using SQL Server 2012 Analysis Services, you must install cumulative update package 1
 SQL Server Management Studio
 SQL Server Business Intelligence
Development Studio (BIDS) if you are using SQL Server 2008 or SQL Server 2008 R2
–or–
SQL Server Data Tools (SSDT) if you are using SQL Server 2012
Management utilities:
Windows PowerShell 2.0 (http://support.microsoft.com/kb/968929)
Software requirements for client computers
  1. Windows client
  2. Office Add-ins
  3. Remote Desktop Services integration
  4. Debugger
  5. Microsoft Visual Studio Tools
  6. Trace Parser
  7. .NET Business Connector
Supported client operating systems
Windows 8, Windows 8 Pro, and 
Windows 8 Enterprise Edition
Windows 8 is supported by default with Microsoft Dynamics AX 2012 R2.
To use Windows 8 with an earlier version of Microsoft Dynamics AX 2012, you must install cumulative update 5 for Microsoft Dynamics AX 2012
Both 32-bit and 64-bit versions of Windows 8 are supported
Windows 7 Professional Edition,Ultimate Edition, or Enterprise Edition
Both 32-bit and 64-bit versions of Windows 7 are supported.
Windows Vista Business Edition,Ultimate Edition, or Enterprise Edition, with Service Pack 2
Both 32-bit and 64-bit versions of Windows Vista are supported.
Software requirements for the Microsoft Dynamics AX client
1. .NET Framework 4.5 is supported with
Microsoft Dynamics AX 2012 R2, and with cumulative update 5 for Microsoft Dynamics AX 2012
–or–
.NET Framework 4.0
2. Internet Explorer 10.0
–or–
Internet Explorer 9.0
–or–
Internet Explorer 8.0
–or–
Mozilla Firefox 11.0 (supported only with Microsoft Dynamics AX 2012 R2)
–or–
Mozilla Firefox 3.5
–or–
Safari 5.1.2
3. Office 2013
 –or–
Office 365 
–or–
2010 Microsoft Office release
–or–
2007 Office release, Service Pack 3
4. SQL Server 2008 R2 Analysis Management Objects (AMO)
Components for Ax-2012
 

update_recordset with joins

 update_recordset with joins update_recordSet storeTransfer         setting      TransactionId = transfertable.TransferId     join transfert...