Friday, December 9, 2011

AX 2009 - Installing Reporting Extensions on Windows server 2008 steps

hi friends,

The below are the steps which i followed while installing reporting extensions on Windows server 2008.

1. Install SQL Server 2008 with Reporting Services.
2. Install Ax - 2009 Application files,AOS, Client,
3. Install All the prerequisite for Reporting Extensions
    To install these software components, see Install prerequisites on the report server.
4. Install Reporting Extensions and .Net business connector.
3. Configure Report server with the Microsoft SQL SERVER 2008 >> Configuration and Tools >> Reporting Services configuration Manager
4. Deploy Reports using the path Microsoft Dynamics Ax 2009 >> Microsoft Dynamics Ax 2009 Reports Deployment.

Tuesday, December 6, 2011

box::yesno syntax in Dynamics ax 2009

A simple way to let the user deside what is going to happen.
1
2
3
4
5
6
7
if(box::yesNo("Do you want something to happen?", 
      dialogbutton::Yes) == dialogbutton::Yes)
   {         
 
          somethingHappens = this.callTosSomeReturnMethod();
 
   }

Wednesday, November 16, 2011

Enterprise Portal Deployment



                             Enterprise Portal Deployment
Microsoft Dynamics AX 2009

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:

Blogs to help about EP Portal Deployment.


~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:

EP deployment Steps

Tuesday, November 15, 2011

Could not load file or assembly 'Microsoft.Dynamics.AX.Fim.PaymentService, Version=5.0.0.0,

While deploying SSRS , I got the below error :
Could not load file or assembly 'Microsoft.Dynamics.AX.Fim.PaymentService, Version=5.0.0.0,………….
To overcome this issue, we need to add the above mentioned dll from client\bin  folder to GAC as below :
Go to Start -> All programs -> Microsoft visual studio 2008 -> visual studio  tools -> visual studio  command prompt , right click and run as administrator :
Run the below  command :
Gacutil /i “location of dll”

Upon successfully added , you will get the message , “Assembly added to the cache”.


Hope it helps you as well.

AX 2009 Report extension installation

Hi Friends,

I am trying to install Report extension. When I run the Setup, I get the following message :

"You must install SQL server 2005 Reporting Services Service Pack 2 before installing the report extensions".

Some of the Resolution that i find out:

1. You can download regarding hofix released by Microsoft and replace dll file.
    HoFix Release By Microsoft - Click Here

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~

2.The another resolution of updating registry key as follows:

Setup does not recognize that SQL Server 2005 Service Pack 2 is installed When installing the reporting extensions, you may receive an error message that states that you must install SQL Server 2005 Service Pack 2. If you have installed SQL Server 2005 Service Pack 2 and receive this error message, complete the following steps.
1. Open the registry and find the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key.
2. Right-click the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key & choose New >Key
3. Name the key Reporting Services.
4. Right-click the Reporting Services key and choose New > String Value.
5. Name the string value Version. The Version string value will have a type of REG_SZ.
6. Double-click the Version string value and enter 9.00.3042.00 as the value data. Click OK

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~

While viewing the URL of reports if gets errors of symmetric key then change the setting in the Encryption Key (Change Action and Delete Action) as per required.
~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~

Get Single Records From Datasource and Update records

Hi Friends,

While development i came across the criteria which recommends me to insert or update the records on the basis of perticular field of table. In this case i used the getFirst and getNext methods of the datasource to fetch single records from the specified datasource.

Here is the code sample.......

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~

InventTrans     tmpInventTrans;

tmpInventTrans = inventTrans_ds.getFirst(0,false);
while(tmpInventTrans)
{
         if(tmpInventTrans.SheAmortCancel == Noyes::No)
        {
            cancelVoucher=false;
            break;
        }
        tmpInventTrans = inventTrans_ds.getNext();
}

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~

tmpInventTrans = inventTrans_ds.getFirst(0,false);
while(tmpInventTrans)
{
                select forupdate inventTransUpdate where inventTransUpdate.RecId == tmpInventTrans.RecId;
                inventTransUpdate.SheAmortCancel = NoYes::No;
                inventTransUpdate.update();
                tmpInventTrans = inventTrans_ds.getNext();
}
info("Amortization cancellation aborted");

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~