Axapta 2012 Developer point of view

View

• Use tables and views to model data in perspectives
• Modeling data using views and tables makes it easier to customize cubes.

Analysis Services Project wizards

• Deploy default cubes.
• Use the Analysis Services project wizard to deploy an existing Analysis Services project. Choose the default cubes from the AOT.
• It is easier to deploy the default cubes.

Configure an Analysis Services project

• Use the Analysis Services project wizard to remove measures, dimensions, and KPIs that you do not have access to according to the license and configuration keys in Microsoft Dynamics AX.

Analysis Services project.

• It is easier to update an existing Analysis Services project.

ValidTimeStateFieldType

• select statement , validTimeState keyword to filter rows by date or date range, like ValidTimeStateFieldType property

Application programmers no longer have to track every detail of foreign key relationships when they perform a set of data modification calls. The UnitOfWork class helps enforce transaction integrity.

Prerequisite for Microsoft Dynamics Axapta 2012

Start with check of prerequisite for business intelligence components, select reporting services extension and click on validate

You notice the existing prerequisites that had been installed in this computer as well as missing, click on below error link

Error link showing error indicate I need to update Microsoft SQL server, I would need to have install cumulative update package3 for SQL Server 2008 r2

Also I would need to have Visual C++ 2008 SP1, Required Cumulative update 3 or higher if you are installing on Microsoft SQL Server 2008 r2 (You can download Cumulative Update package 3 for SQL Server 2008 r2 from http://go.microsoft.com/fwlink/?LinkeID=205864)

The reporting service integration not support to report server that is complicated one in SharePoint integrate, from start menu click on Reporting Services Configuration manager from configuration tools menu under Microsoft SQL Server 2008 r2 start menu

By launching this configuration utility we can verify to see whether or not the reporting service integration is set to SharePoint integrated or not

I select connect and choose Database

As seen below report server mode set to SharePoint integrated, we can either choose the AX database or another database selecting change Database

Axapta 2012 required Database could be on a dedicated box or on the same machine, for production environment it is recommended dedicated server

For the server components, needs Application Object Server (AOS) either installed in same box or on dedicated server, having multiple AOS speed up the operation and also allow to have a cluster environment.

Web server components and Enterprise Portal (EP) give you similar functionality to the client application over the web

Enterprise Search give you the capability to find different information in your environment either a client utility or Enterprise Portal (EP)

Business Intelligence components required reporting service extension to gives you the capability to create reports using visual studio

Analysis Services Configuration gives you capability to use OLAP and OLTP

Client components are necessary for dynamic AX users to able to access the Dynamic Features

Office Add-ins gives you the interaction between Microsoft Office products like excel and Dynamic

Remote Desktop Service integration gives you the capability to run dynamic AX client to use terminal services on operating system

For developer you need to install the developer tools, you have

Debugger

Visual Studio tools which gives capability to create visual studio project in C# and same into the AOT also to create Enterprise Portal using Visual Studio

Trace Parser gives you capability to troubleshooting to find out exactly how many problems do you have in regards to client to server and server to database communication also give you benchmark utility to allow you to find out performance related to those communication

For Integration Components

Web Services on IIS which is based on wcf

.NET Business Connector is a gateway between dynamics AX and Visual Studio or any third party language which allows you to run AX command from visual studio application or vise a versa between dynamics AX using X++ or MrophX called the .NET library Application

Synchronization proxy for Microsoft Project Server if you are going to manage your projects Microsoft project server is one of the products that Microsoft offers Dynamics Ax has the capability to synchronized all the project and associated task within Dynamics Ax , you can also provide project accountant in regards to manage in the cost of running the project.

Manage utilities uses the window power shell 2.0 to maintain the Dynamic Ax 2012 using the power shell options

Go ahead and check per-requisite for business intelligence components

 

 

 

 

 

 

 

 

 

Microsoft Messenger Queuing (MSMQ) server should be per-installed, it enables application running at different times to communicates across heterogeneous networks and system that may be temporarily offline. MSMQ provides message delivery Routing Security and priority-based messaging. It can be used for both asynchronous and synchronous messaging To install this feature, use Windows Server Manager, Right click Features and Click Add Features. In the Message Queuing node, expand Message Queuing Services and select Message Queuing Server and Directory Services Integration, Click Next and then click Install, you must restart the computer for the configuration to take effect., It is the windows part of the system.

 

 

 Check the client components and Development tools components

Network Requirements

   Axapta 2012 can operate on IPv4 or IPv6

   Network Reponse Time

             Between Cilent And Application Object Server (AOS) - 100 Mbps

             Between Application Object Server (AOS) to Database - 100 Mbps

 

In axapta 2012 Terminal Service is not Required, in WAN environment that uses legacy x++   Reporting, connect by using Windows Server Terminal Services or another Remote Connection Product

Domain

• Axapta 2012 installation requirement
• computer belongs to Active Directory Domain and the same configured in Native Mode
• computer have access to other computers in active directory, computer should be in same domain or in another trusted domain
• For Email alert SMTP server present in the environment

Hardware Requirements

• Processor - Intel Pentium/Celeron 1.1 ghz Xeon or Higher (Axapta do not support Itanium 64 bit processor)
• RAM - Server - 4gb or Higher depends on concurrent users and processing of transaction
• RAM - Client - 2gb or Higher
• DVD Drive
• Monitor - VGA minimum 1024x768 or higher resolution
• (for above actual requirement may change depends on Transaction, Concurrent Users, EP Users, Remote Client Users,  etc..)

Software Requirements

 

•  .NET Framework 3.5 SP1, .NET 4.0 required depends on additional requirement
•  Windows Installer 3.1 or 4.0

 

 Axapta Components requirements

•   Database
•   Application Object Server (AOS)
•   Enterprise Portal
•   Enterprise Search
•   Help Server
•   Microsoft SQL Server Reporting Services Extensions
•   Microsoft SQL Server Analysis Services Configuration
•   Web services on Internet Information Services (IIS)
•   Synchronization proxy for Microsoft Project
•   Management Utilities

Server Operating System (OS)

•   Windows Server R2 Std., Ent., Web, Datacenter
•   (only 64bit version of Windows Server 2008 are supported)
•   Windows Server 2008 std., Ent., Web edition , Datacenter with SP2

Software requirement for Database Server

 

•   MS SQL Server 2012 Std., Ent., or BI edition            or
•   MS SQL Server 2008 R2 Std., Ent., or Datacenter     or
•   MS SQL Server 2008, Std., Ent. with SP1
•   Required Hot Fix 2680186 of MS Dynamics AX
•   Only 64 bit of of SQL Server are supported
•   for more details minimum HW requirement for SQL server check  url  http://www.microsoft.com/sql/default.mspx
•   use latest cumulative updates for SQL server
•   Microsoft Dynamics AX supports Unicode collations
•   Install native client on AOS server if AOS server is separate from the database server
•   install SQL 2008, 2012 version of Native client

Additional Requirement

 

AOS

• .net 4.0 with hotfix 2390372
• SQL Server 2008 native client

EP

• web server role
• IIS 7.0 or IIS 7.5
• ASP.NET 2.0
• Microsoft SharePoint Foundation 2010 or
• Microsoft SharePoint Server 2010, Standard Edition or Enterprise Edition (recommended)
• SQL Server 2008 R2 Analysis Management Objects AMO
• Install SQL server 2008 AMO even if you are using SQl server 2012

Enterprise Search

• Web server role
• IIS 7.0 or IIS 7.5
• ASP.NET 2.0
• Windows PowerShell 2.0
• Microsoft Search Server 2010 or
• Microsoft Search Server Express 2010 or
• Microsoft Fast Search Server 2010 or
• SharePoint Server 2010,Standard Edition or Enterprise Edition (recommended)

Help Server

• Web server role
• IIS 7.0 or IIS 7.5
• ASP.NET 4.0

Reporting Services Extensions

• SQL Server 2012 Reporting Services or with Cumulative update 3 or a later update or with SP2
• It is must to install Microsoft Dynamics AX hotfix 2680186
• Windows PowerShell 2.0

Analysis Services Integration

• SQL Server 2012 Anylysis Services or with SQK 2008 R2 services or with SQL Server 2008 services
• SQL Server Management Studio
• SQL Server Business Intelligence Developement Studio

 

Webservices on IIS

• Web server role
• .NET Framework 4.0
• IIS 7.0 or IIS 7.5
• If you use web services to exchange documents with external partners, we recommend that you install the Windows SDK
• The Windows SDK contains tools that make it easier to configure Web services.
• SvcConfigEditor.exe graphical user interface (GUI) that you can use to create and modify configuration settings

Management utilities

• Windows PowerShell 2.0

Client Operating Systems requirement

• Windows 7 Professional Edition, Ultimate Edition, or Enterprise Edition, support 32-bit and 64-bit version
• Windows Vista Business Edition, Ultimate Edition, or Enterprise Edition, with Service Pack 2, support 32-bit and 64-bit version

Microsoft Dynamics AX client Software requirements

 

       Browser is required for Client Computer to access Enterprise Portal (EP)

• .NET Framework 4.0
• Internet Explorer 9.0 or Internet Explorer 8.0 or
• Mozilla Firefox 3.5 or
• Safari 5.1.2 (Enterprise Portal does not support Safari for developer or system administrator tasks)
• Microsoft Office 2007 release SP2 or Microsoft Office 2010 Office release ( MSOffice required for Outlook,Word, Excel integrations with AXAPTA.
• SQL Server 2008 R2 Analysis Management Objects (AMO), used to administer the OLAP database.

Virtual client support

Client for Axapta is certified to work as a virtual application on Microsoft Application Virtualization (App-V) 4.6. App-V transforms applications into virtual services. When an application is virtual, it is no longer installed on a user's computer. Therefore, the application does not conflict with other applications. Updates are centrally managed, so users do not get prompt for restarts.

 

 

Microsoft Dynamics AX for Retail

 

Software requirements to implement

 

• Retail Headquarters
• Retail POS (point of sale)
• Retail Store Connect
• Retail Transaction Service
• Retail Store Database Utility
• Retail POS Plug-Ins

Supported peripheral devices for Retail

• Cash drawers
• Receipt printers
• Line or pole displays
• Dual displays (with a second monitor that faces the customer)
• Magnetic stripe readers (MSRs)
• Bar code scanners
• Scales
• Keylocks (keyboard locks for manager override keys)
• Keyboards
• PIN pads

OPOS Common Control Objects, version 1.13, are required for peripheral devices

 

64-bit operating system support

• Application Object Server (AOS) - (Run on 32 bit is not recomanded)
• Windows client
• Office Add-ins
• Remote Desktop Services integrationVisual Studio Tools
• Enterprise Portal (no support to run on 32 bit)
• Reporting Services extensions (not recomanded to run on 32 bit)
• Visual Studio Tools



Comparison between IF and SWITCH statement in Axapta

X++ code for IF and SWITCH


IF Statement

static void Job1(Args _args)
{
    int itemid = 1001;

    if (itemid == 3005)
    {
        print "Product 3005";
    }
    else if (itemid == 5001)
    {
        print "Product 5001";
    }
    else if ((itemid == 1001) || (itemid == 1002) || (itemid == 1003)
    {
        print "Product in range of 1001-1003";
    }
    else
    {
        print "Product nothing";
    }
    pause;
}
SWITCH Satement
Required break otherwise depends on the value it may select appropriate case, so break exit the pointer out of the switch case statment, you can see switch statement work batter in some of the situation than if statement

static void Job2(Args _args)
{
    int itemid = 1001;
    switch (itemid)
    {
        case 3005:
            print "Product 3005";
            break;
        case 5001:
            print "Product 5001";
            break;
        case 1001, 1002, 1003:                                  // it work like 1001 OR 1002 OR 1003
            print "Product in range of 1001 - 1003";
            break;
        default:
            print "Product nothing";
            break;
    }
    pause;
}

Product Master in Microsoft Dynamics Axapta 2012

What's new ?

1. Product creation process is centralised
2. Reduced managing master data with use of shared product data
3. New introduction of Process Oriented Product Defination Task Framework

Step by Step

1. Create a product Master in Axapta 2012 
2. Create Product Variants
3. Release Product Variants to legal entities
4. Finalise Release product
5. Create Released product -Streamlined

Select all product and product Master

Click on Product

Create a new product, type Product Number, Name, Search name

Select Product subtype as "Product Master"whichwill show more fields

Fill in the product details and select OK

Now will get the entered details in grid

To create Product Variance click on Product Dimention, create new Size dimention

Create new dimention under colour

Create Product Variants

Now can see below complete details for "Prod1"

Now Product to be released to the selected companies, select release product

Select "Select Companies"

Now finally you can see below on right hand side the name of the company DAT. with left hand side Prod1.

now select Release Product

Apply Template this this Product

Select prod1 product and click on validate

 Thank you.

Array in Axapta

Array hold same type of variable
arrya can be access thru integer indexes, Index begins with 1
Declaration of Array variable can be Table or Object
One dimention of array can be declare


Three type of Array

1.  Dynamic
     It is declared without integer index value, just put square bracket [ ],
     If you are not sure of row and column size of index use this
     int    myarrya[];

2.  Fixed - Length
      it can hold 30 items
      int    myarray[30];


3.  Partly on Disk
      dynamic integer arrya hold 30 elements in memory
      int   myarray[,30];
    
      string arrya hold 10elements and 30 in memory
      str   myarrya[10,30];
     
to reset all element in myarray do
myarray[0];
 

ADO connection string in Axapta

To do the Integration Job in Microsoft Dynamics Axapta use following Connection string

Create a JOB in Axapta and do the follwing

CCADOCommand         command;

CCADOCRecordSet       recordseta;

CCADOFields                Fields1;

Com                                Coms;

Str                                   Sql;

Str                                   Provider = "192.x.x.x";   // enter here your public ip address of the database server

Str                                   DataBase = "mydatabasename"; //enter here your sql database name

Str                                   UserID = "Myname";  // enter here sql user name like SA etc..

Str                                   PWD = "mypw"; //enter here your sql password

Str                                   ConnectionString = strfmt("Provider=SqlOledb;server="+ Provider + ";trusted_Connection=false;" + "Initial catalog=" + DataBase + ";User id=" + userid + ";password='" + PWD + "';");

sql = "select * from emp";

Connection = new CCADOConnection();

Connection.open(CCADOConnection);

command = new CCADOConnection();

command.commandText(sql);

recordseta = new CCADOConnection();

recordseta = command.execute();

Coms = recordseta.recordset;

if (!recordseta.EOF())

{

//here you can do your further work

}

Truncate decimal value in Axapta

How to Truncate Decimal Value