Recent Posts

Pages: 1 [2] 3 4
11
The below code for Passing parameters to SSRS using X++ code.



    MenuFunction SSRS_MyReport;

    Args Args;

    str parmId ="";

    ;

  // create reference to menu item “OverTime” which is in AOT
    SSRS_MyReport = new MenuFunction(menuItemOutputStr(OverTime),MenuItemType::Output);

To read full article please go to link below
http://dynamicsaxforum.com/blog/how-to-pass-parameter-to-ssrs-report-from-dynamics-ax/
12
Dynamics Jobs / Dynamics AX Developer
« Last post by ForumAdmin on November 06, 2014, 09:06:06 AM »
Solvait is hiring Dynamics AX Developer
Solvait is hiring a full time AX Developer/Technical Consultant based in Amman, Jordan or remotely from where he/she is. The successful candidate will have experience in MorhpX, X++, SSRS, & EP, bachelor degree in Computer Science/Engineering, MIS, or similar. If you are (or you know someone would be) interested, please send resume to: info@solvait.comless
13
Dynamics Jobs / Hiring for Axapta Technical Consultant
« Last post by ForumAdmin on November 02, 2014, 09:17:54 AM »
Hiring for Axapta Technical Consultant for Contract to Hire for Bangalore location !!!
IT Recruiter at Janya IT Technologies
Should have experience in Microsoft Dynamics AX Axapta with Microsoft Dynamics AX 2012 Installation and Configuration , SSRS Reports , X++ Coding , SQL Server 2005/2008/2008 R2 , Morph X . Interested , Please send responses to Johnson.m@janyatech.com References would be appreciated . Thanks & Regards , Johnson
14
Dynamics Jobs / Dynamics AX - Technical Specialist Job For a Customer in Kuwait
« Last post by ForumAdmin on October 28, 2014, 04:00:12 PM »
Dynamics AX - Technical Specialist Job For a Customer in Kuwait


ERP Consultant at Enhanced Engineering & Multi-technologies Co.
We Need a Dynamics AX Technical Specialist will be responsible for managing all technical aspects during the full lifecycle of a Dynamics AX implementation and support. This includes converting functional requirements into customizations using .NET and AX native programming languages. This will also include estimation, business requirement analysis, technical design and on-going activities related to build and deployment. This person will have a strong overall knowledge of technical aspects of Microsoft Dynamics AX 2012 and exposure to the functional aspects of the solution.

If interested please send you c.v to : russrodz@gmail.com
15
InventJournalTable              inventJournalTable;
        InventJournalTrans              inventJournalTrans;
        InventJournalNameId            inventJournalName;
        InventDim                            inventDim;
        JournalCheckPost              journalCheckPost;

        //Below code creates journal header       
        inventJournalTable.clear();
        inventJournalName =  InventJournalName::standardJournalName(InventJournalType::Movement);
        inventJournalTable.initFromInventJournalName(InventJournalName::find(inventJournalName ));
        inventJournalTable.insert();

        //Below code creates journal lines
        inventJournalTrans.clear();
        inventJournalTrans.initFromInventJournalTable(inventJournalTable);
        inventJournalTrans.TransDate = systemDateGet();
        inventJournalTrans.ItemId = "MDJ0001";
        inventJournalTrans.initFromInventTable(InventTable::find("MDJ0001"));
        inventJournalTrans.Qty = 2500;
        inventDim.InventSiteId  = '12';
        inventDim.InventLocationId = '1201';
        inventDim.wMSLocationId = 'BULK-001';
        inventJournalTrans.InventDimId = inventDim::findOrCreate(inventDim).inventDimId;
        inventJournalTrans.insert();


        //The below code posts the journal
        journalCheckPost = InventJournalCheckPost::newPostJournal(inventJournalTable);
        journalCheckPost.run();
16
[b]Common Keys Steps for The Planning integration process Between AX and Other Applications.[/b]

1. In a typical integration scenario, users who have business expertise first determine the document exchange needs. These are requirements from a business perspective. The business users work with the Implementation team to specify:
a. What data is to be exchanged.
b. Any business logic related to that data.
c. The external systems with which data is to be exchanged.
d. The conditions under which data is sent from or received by Microsoft Dynamics AX.

[url=http://dynamicsaxforum.com/blog/common-keys-steps-for-the-planning-integration-process-between-ax-and-others-application/]read more[/url]
17
General / Generating an AIF web service
« Last post by ForumAdmin on March 29, 2014, 02:28:17 AM »
we can generate services right from Dynamics AX that will be available for use. Services can be created by developers but Dynamics AX 2009 comes pre-packaged with several services, depending on your licensing scheme. In this section, we will go over the process of generating services.

[url=http://dynamicsaxforum.com/blog/dynamics-ax-generating-an-aif-web-service/] read more[/url]
18
General / How to Integrate AX 2012 with Other Applications
« Last post by smahdy on March 24, 2014, 06:51:22 PM »
You can use the following methods to integrate Microsoft Dynamics AX with other applications:


1- Services and the Application Integration Framework

Services are the preferred option for integration with Microsoft Dynamics AX. Services in Microsoft Dynamics AX are used to expose its functionality through WCF-based services. Microsoft Dynamics AX code and external applications can consume Microsoft Dynamics AX services. AIF supports the processing of inbound and outbound messages such as message transforms and value lookups. Together, services and AIF provide the programming model, tools, and infrastructure support for XML-based integration with external applications and data

2- .NET interop to X++

You can use the .NET interop to X++ feature to call X++ code using C# or another managed language. A proxy is an automatically generated .NET class, in C# or another managed language, that mimics an X++ class of Microsoft Dynamics AX.

3- .NET interop from X++

The .NET interop from X++ (also known as the CLR Interop in the previous release) provides interoperability with external .NET components and you can execute managed-code components from within X++ code. .NET interop from X++ is useful when you want your X++ code to access functionality provided by a CLR-managed assembly. This includes assemblies that are installed with the .NET Framework and any assemblies that you create with a language such as C# or Visual Basic.NET.

4- Consume external web services

You can use the Microsoft Dynamics AX programming model to consume external web services from within X++ code. To consume an external web service from X++, you must first create a reference to the web service. After creating a reference to the web service, you can invoke it from X++
and view the available methods with IntelliSense. Calling and managing external web services is done completely within Microsoft Dynamics AX.

The following figure shows how the AIF integration components interact with Microsoft Dynamics AX through the AOS.

image
19
General / How to: Override the fetch Method to Filter Data for Reports (MorphX Reporting T
« Last post by smahdy on March 24, 2014, 01:25:31 AM »
You can override the fetch method to filter the data that is displayed in a report. This override does not reduce the number of records that are returned by the query of the report. Instead it prevents some records from being sent to the final report. Each record is examined by the branching logic you add to the fetch method. Branching determines which records to give to the send method. Those records appear in the final report.
NoteNote
Do not call super() when you override the fetch method in a report.
By default, each record that is returned by the query appears in the report. To reduce the number of records returned, add range restrictions to the query. Report ranges are more efficient than overriding the fetchmethod; however, report ranges are less expressive. For information about adding ranges to queries, see Query Elements in the AOT.
Example
The following code example loops through each record that is returned by the query. The code tests a field in each record and branches to a send method call for records that belong in the report.
In this example, the BankAccountTable table is the only data source for the report. The fetch method in the report is overridden with the following code.


public boolean fetch()
{
    boolean retCode = false;
    BankAccountTable bankAccountTableRec;
    QueryRun qrun;
    ;
    // Use the queryRun object that is associated with the
    // report; element refers to the report.
    qrun = new QueryRun(element);

    // Verify that the report dialog works.
    if (! qrun.prompt())
    {
        return retCode;
    }

    // Loop through each record from the data source query of the report.
    while (qrun.next())
    {
        // Get the BankAccountTable fields from the query record.
        bankAccountTableRec = qrun.get(TableNum(BankAccountTable));

        // Exclude ODDBANK from the visible report.
        if (bankAccountTableRec.AccountID != "ODDBANK")
            {
                // Include the current record in the report.
                element.send(bankAccountTableRec);
            }
    }
    retCode = true;

    // retCode = super(); // Do not call super() when you override the fetch method.
    return retCode;
}
20
AX BI and Reporting / Deploy reports for the new Reporting Services instance [AX 2012]
« Last post by smahdy on March 24, 2014, 01:11:58 AM »
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Microsoft Dynamics AX includes many default reports that you must deploy. You can deploy these reports by using Windows PowerShell. The following procedures can help you deploy the reports.

Before you begin

Before you can deploy the reports by using Windows PowerShell, you must complete the following tasks:

Verify that Windows PowerShell 2.0 is installed on the computer that you are using.

Verify that your Windows domain account is a member of the Administrators group on the server that is running Microsoft SQL Server Reporting Services.

NoteNote

If your Windows domain account is assigned to a group that is a member of the Administrators group, it may take some time to validate that you are a member of the Administrators group. If you experience a delay when you deploy reports, consider adding your Windows domain account directly to the Administrators group.

If Reporting Services is running in native mode, verify that you are assigned to the System Administrator role on the Report Manager website.

If Reporting Services is running in SharePoint integrated mode, verify that you have been granted Contribute permission to the document library where you plan to deploy the reports.

NoteNote

SharePoint integrated mode is supported if you are using Microsoft Dynamics AX 2012 R2.

Open Windows PowerShell and view a list of reports

Complete the following procedure to open Windows PowerShell and view a list of the reports that are included with Microsoft Dynamics AX.

Open Windows PowerShell as an administrator by following these steps.

Click Start > Administrative Tools.

Right-click the Microsoft Dynamics AX 2012 Management Shell option.

Click Run as administrator.

Retrieve a list of the reports that are included with Microsoft Dynamics AX, and store the list in a local variable by entering the following command:

Windows PowerShell

$reports = Get-AXReport -ReportName *
For more information about the Get-AXReport command, see Get-AXReport.

View the list of reports by entering the following command:

Windows PowerShell

$reports
Filter the list of reports

In the previous procedure, you displayed a list of all the reports that are included with Microsoft Dynamics AX. To modify and filter the list, you can use the following commands.

To modify the list so that only the Name and ChangedDate fields are displayed, enter the following command:

Windows PowerShell

$reports | Select-Object Name,ChangedDate
To filter the list so that only specific reports are listed, enter keywords or report names. For example, to filter the list so that only reports that contain the word CustTrans are listed, enter the following command:

Windows PowerShell

$reports | Select-Object Name,ChangedDate | Where { $_.Name -like "CustTrans*" }
Deploy the reports

After you have retrieved a list of reports, you can deploy the reports. The Publish-AXReport command is used to deploy the reports. The following examples show how to use this command. For more information, see Publish-AXReport.

NoteNote

In the following examples, SSRSConfigID refers to a configuration ID that was defined in Microsoft Dynamics AX. To view these configuration IDs, open Microsoft Dynamics AX and then open the Report servers form. (ClickSystem administration > Setup > Business intelligence > Reporting Services > Report servers.) To deploy reports to the new Reporting Services instance, enter the configuration ID that is associated with that instance.

To deploy a specific report, enter the name of the report. For example, to deploy the CustTransList report, enter the following command:

Windows PowerShell

Publish-AXReport –Id SSRSConfigID -ReportName CustTransList
To deploy two or more specific reports, enter the names of the reports. For example, to deploy the CustTransList and CustTransOpenPerDate reports, enter the following command:

Windows PowerShell

Publish-AXReport –Id SSRSConfigID -ReportName CustTransList, CustTransOpenPerDate
To deploy all reports, enter the following command:

Windows PowerShell

Publish-AXReport –Id SSRSConfigID –ReportName *
Pages: 1 [2] 3 4