Tuesday, December 18, 2012

Dynamics AX Tools from InformationSource


Hi All,
        Please have the below list for Dynamics AX tools available for Presales,Sales,Analysis,Upgrade & more...


1.   Application analysis Tool (Beta): The Application Analysis tool is designed to enable developers to easily understand how the application has been constructed. The tool can analyze X++ code, create UML sequence diagrams of the data model using progressive discovery.

2.   Data Migration Framework Tool (Beta): The Data Migration Framework (Beta) is an extension to Microsoft Dynamics AX that provides a way to migrate data from external sources to source Microsoft Dynamics AX 2012.

The framework also supports exporting and importing data (for entities defined in the Data Migration Framework) from a Microsoft Dynamics AX 2012 instance to another one.

3.   Combine XPO Tool (Beta): The Combine XPO Tool (Beta) 1.0 is a command line program that combines a set of interdependent XPO files into a single XPO. For example, if a team of developers is making code changes to different aspects of an application, use this tool to merge those changed files into one file.

4.   Security Development Tool (Beta): The Security Development Tool (Beta) is intended to simplify the creation and maintenance of security artifacts such as roles, duties and privileges. It displays entry point permissions for a given role, duty or privilege and allows you to create new security artifacts on the basis of access through various entry points. The tool allows you to test newly a created\modified security role, duty or privilege from the same interface without using a different test user account. In addition, the tool also allows you to record business process flows and identify the entry points used.

5.   Code Upgrade Service Tool (Beta): The Code Upgrade Service Tool (Beta) is designed to help Microsoft Dynamics AX developers upgrade their X++ code to Microsoft Dynamics AX 2012. The service analyzes X++ code patterns and automatically fixes some patterns, provides suggestions on how to fix other patterns, categorizes upgrade tasks, and enables developers to add their own patterns to be analyzed.

6.   Security Upgrade Advisor Tool (Beta): The Security Upgrade Advisor Tool (Beta) is intended to help simplify the process of upgrading security settings from an earlier version of Microsoft Dynamics AX to Microsoft Dynamics AX 2012. It compares entry point and permissions between systems and generates a list of matching privileges that can be used a particular role. The role-to-privilege mapping is based on the user group-to-access right mapping in earlier versions of Microsoft Dynamics AX systems. The tool is designed as an aid for upgrading security settings and is not one click solution. Developers are advised to review each suggestion carefully before making any changes.

7.   Intelligent Data Management Framework Tool: The Intelligent Data Management Framework Tool is designed to help system administrators optimize the performance of Microsoft AX installations. The Intelligent Data Management Framework assesses the health of the Microsoft Dynamics AX applications, analyses current usage patterns, and helps reduce database size.

Enjoy DAX!!!

Monday, December 10, 2012

AX 2012 R2 in 25 Clicks

Hi All,
      As you know the much awaited AX 2012 R2 is launched so lets have a install/upgrade overview on AX 2012 R2 in just 25 clicks :

1) Start the Setup Program.

 2) Click "Microsoft Dynamics AX Components" under Install.
 3) Click Next.
 4) Select "I accept the license terms" *.
 5) Choose Appropriate Option.
 6) Processing will start.

 7) Choose "Add or modify components".
 8) Select Options to install/upgrade.
 9) Review the Errors/warnings and click on "Configure" check box for the applicable errors. and click "Configure".
 10) Click "Start" to start configuring components as per AX needs.
 11) Select "Configure existing database (for upgrade scenarios)".
 12) Specify your existing databases.
 13) Choose models to upgrade.
 14) Specify the "Temp" location for setup files.
 15) Specify the SSAS details.
 16) Specify credentials (we just have used the dummy account) for learning purpose only. Use your AD authenticated account details.
 17) Specify .net BC account (if its not already there in AX)
 18) Choose your Languages (en-US) in this demo.
 19) Specify Data Crawler Account details.

 20) SSRS Database details.
 21) User Account for SSRS Access.

22) Click Install.
23) Verify the installation.

Enjoy DAX !!!

Monday, November 5, 2012

AX 2012 : Data Migration Framework(DMF)


The Data Migration Framework for Microsoft Dynamics AX 2012 is an extension that helps you migrate data into Microsoft Dynamics AX. Examples of the data that you can migrate include master data, open stock, and balances.

The Data Migration Framework is available from the InformationSource services download page.

The Beta 2 version of the Data Migration Framework includes support for the following new features:
  • ODBC connections as a data source.
  • Microsoft Dynamics AX databases as a data source. You can now export and import Microsoft Dynamics AX, and copy company information by using Data Migration Framework entities.
  • Direct table and composite entity types.  
    • direct table entity enables you to migrate data from a source to a target Microsoft Dynamics AX table directly, without going through a staging table or applying any business logic.Unlike other entities, data cannot be pushed from one source table to multiple target tables. The direct table entity must be a one to one mapping from source to target.
    • composite entity groups multiple related entities together. An example of a composite entity is a Sales Order and Sales Line entities combined together.
      Parallel execution of threads to move data from staging to target tables.
  • Using the Data Migration Framework as a service. The framework can now be executed by external applications.
  • Error-handling enhancements. The Data Migration Framework provides more detailed logs, and can skip rows that contain errors.
  • Number sequence support.
  • Remote installations of Microsoft SQL Server Integration Services. It is no longer necessary to install Integration Services on the same computer as the Application Object Server (AOS).



Data Migration Framework User Guide : Click here for Source

Data Migration Framework Installation : Click here for Step by Step

Data Migration Framework Demo Files : Click here for Files


Enjoy DAX!!!

Friday, July 27, 2012

Office 15 Customer Preview


Microsoft Office 15 Customer Preview is now available for trial to enable you to experience the revolutionary features of Office 15 applications.
It will provide a diverse range of services including Office ProPlus, Office 365 Small Business Premium and Office 365 Enterprise for diverse business requirements.
Tapping the Market Opportunities with Office 15
Business in Cloud-Office 15 will bring in considerable opportunities in cloud as more and more customers purchase software through the cloud.

Capture the Market Opportunity-Analysts predict that delivering software-as-a-service (SaaS) will continue to offer tremendous revenue-generating opportunities.

Differentiate your Business-By understanding the capabilities of Office 15, you can provide the best business productivity experience for your customers.

Sign up now to try Office 15.



Source : Microsoft

Friday, July 13, 2012

AX 2012 : Delete All Transactions

Hi,
    Today we will look at, How to delete all transactions from AX 2012. Previously we were using SysDatabaseTransDelete class to do the same but as of now we need to modify that class to work properly with AX 2012 due to DB changes :


We need to modify the SysDatabaseTransDelete.handletable method with the below code :

void handleTable(SysDictTable sysDictTable)
{
    TableGroup      tableGroup;

    if (tableSet.in(sysDictTable.id()))
        return;
    tableSet.add(sysDictTable.id());

    if (sysDictTable && !sysDictTable.isTmp() && !sysDictTable.isMap())
    {
        tableGroup = sysDictTable.tableGroup();

        // Handle company specific tables to be deleted
        if (sysDictTable.dataPrCompany())
        {
            switch(tableGroup)
            {
                case TableGroup::Transaction:
                case TableGroup::WorksheetHeader:
                case TableGroup::WorksheetLine:
                //FIX - Support new AX2012 transaction table types
                case TableGroup::TransactionHeader:
                case TableGroup::TransactionLine:
                    this.handleTransTable(sysDictTable);
                    break;
                default:
                    this.handleNonTransTable(sysDictTable);
                    break;
            }
        }
        else
        {
            // Handle global tables to be deleted
            switch(tableGroup)
            {
                case TableGroup::Transaction:
                case TableGroup::WorksheetHeader:
                case TableGroup::WorksheetLine:
                //FIX - Support new AX2012 transaction table types
                case TableGroup::TransactionHeader:
                case TableGroup::TransactionLine:
                    this.handleGlobalTransTable(sysDictTable);
                    break;
                default:
                    break;
            }
        }
    }
}


Enjoy DAX!!!

Wednesday, June 20, 2012

Site Services & Commerce Services in AX 2012


Site Services

Organizations can use Sites Services for Microsoft Dynamics ERP to easily build web sites that extend their business processes to the Internet and integrate smoothly with Microsoft Dynamics AX, often with no need for IT support. Before you can use Sites Services, you need to sign up for an account. In many organizations, the IT department or a partner sets up, customizes, and maintains Sites Services.

Microsoft Dynamics AX includes four Sites Services solutions:
  • Online case request – Customer support representatives can accept feedback and questions for case management.
  • Human resources recruitment – Human resources staff can display ads for job openings online and receive applications from candidates.
  • Request for quotation – A purchasing agent can post purchasing needs online and vendors can review them and respond with quotations.
  • Unsolicited vendor registration – The purchasing department can accept unsolicited vendor registrations.
You can also create your own Internet-based solutions. Following are some examples:
  • Marketing - Create a marketing campaign that collects and tracks sales leads.
  • Customer service - Publish customer service information and collect customer feedback.
  • Product registration - Provide a convenient site for customers for product registration.

    For more information please click here.

Commerce Services

Organizations can use Commerce Services for Microsoft Dynamics ERP to sell products online easily through established marketplaces such as eBay and online stores that the organizations themselves create.
Catalogs and product listings are centrally managed, and sales orders flow seamlessly back into Microsoft Dynamics AX for processing.
Using Commerce Services provides the following benefits:
  • Sell through multiple channels by extending your sales presence to your own online store and online marketplaces, such as Amazon, eBay, and others.
  • Provide seamless inventory management between Microsoft Dynamics AX and the online store. Changes in stock levels are automatically reflected in the online store.
  • Provide seamless payments between Microsoft Dynamics AX and the online store. With Commerce Services payment processing is integrated between an organization’s online shopping cart and its back office software.
  • Provide seamless order management between Microsoft Dynamics AX and the online store: Commerce Services ties together online customer acquisition efforts with back-office order fulfillment.

For more information please click here.


Enjoy DAX!!!

Friday, June 15, 2012

HcmWorkerImportService to create/import worker into AX 2012

Hi All,
         Today we will be having a look at the AIFDocumentServices to create Worker (Contractor/Employee) into AX 2012 using HcmWorkerImportService.

Pre-requisites:
1) AX 2012 with CU2
2) Demo Data
3) Visual Studio Dev Tools

Scenario:
Wants to create/import worker into AX 2012 from an external application.

Solution:

  1. Create a Service Group in AOT
  2. Rename it to HcmWorkerImportDemo
  3. Drag the "HcmWorkerImportService" into your newly created service group.
  4. Right Click on the "HcmWorkerImportDemo" & click on Deploy Service Group.
  5. Go to System Administration -> Setup -> Services & Application Integration Framework -> Inbound Ports
  6. Find your "HcmWorkerImportDemo" Inbound port & Copy the WSDL Address.
  7. Create a C# Console Application.
  8. Right click on your solution -> add Service Reference -> Paste the WSDL Address
  9. Type the Reference Name like "ABC"
  10. Include ABC as a namespace.
  11. Modify the main() method with the below code :
            HcmWorkerImportServiceClient proxy = new HcmWorkerImportServiceClient();
            CallContext context = new CallContext();
            context.Company = "ceu"; //Company Name

            AxdHcmWorkerImport worker = new AxdHcmWorkerImport();
            AxdEntity_HcmWorker hcmWorkerTable = new AxdEntity_HcmWorker();

            AxdEntity_DirPerson_DirPerson party = new AxdEntity_DirPerson_DirPerson();
            party.NameAlias = "Kuldeep";
            party.Gender = AxdEnum_Gender.Male;
            party.MaritalStatus = AxdEnum_DirPersonMaritalStatus.Married;

            AxdEntity_DirPersonName personName = new AxdEntity_DirPersonName();
            personName.FirstName = "Kuldeep";
            personName.MiddleName = "Singh ";
            personName.LastName = "Godara";
            party.DirPersonName = personName;

            hcmWorkerTable.DirPerson = party;

            AxdEntity_HcmEmployment personEmployment = new AxdEntity_HcmEmployment();
            personEmployment.EmploymentType = AxdEnum_HcmEmploymentType.Contractor;
            personEmployment.LegalEntity = "ceu"; //Company Name

            hcmWorkerTable.HcmEmployment = new AxdEntity_HcmEmployment[1] { personEmployment };

            worker.HcmWorker = new AxdEntity_HcmWorker[1] { hcmWorkerTable };

            try
            {
                proxy.create(context, worker);
                Console.WriteLine("Success");
                Console.ReadLine();
            }
            catch
            {
                throw;
            }
12. Run the Application.
13. Cross Check your worker into AX 2012.


Enjoy DAX !!!