SSRS Report Development & Deployment For Dynamics AX 2012

An Excellent post by Syed baber Owais on SSRS installation, Configuration & report development for Dynamics AX. You can have the complete document here ( Word File).


It Covers the following topics

·        SSRS Installation and Configuration          

·        Editing existing SSRS Reports       

·        Developing a new SSRS report     

·        Developing Query Based SSRS reports using VS

o   Previewing SSRS reports from Visual Studio

o   Viewing SSRS report on browser

o   Opening SSRS report from AX

§  Filtering a report with an specific parameter

·        Developing RDP based SSRS reports          

·        Using Controller Class    

o   Examples of controller class usage           

§  HcmEmployeeLeaveController    

§  BankDepositSlipController           

·        Data Contract class for SSRS Reports       

o   Defining label and help text for parameters 

Dynamics AX 2012 - Data Import Using Excel Add IN

With the release of Dynamics AX 2012, a very important thing was to import data in AX2012 using the Excel add in. This involves a lot of planning, and technical work.

Just to ease the whole process, there are bunch of articles by  Alex Anikiev On his blog which are quite detailed with step by step procedure for importing data in AX2012 using Excel Add in. The list is as follows 

1. Import Customers
2. Importing Vendors
3. Importing Main Accounts
4. Importing Products
5. Importing Customer Transactions/Balances
6. Importing Vendor Transactions/Balances
7. Importing Ledger Transactions/Balances
8. Importing Inventory Transactions/Balances
9. Importing Sales Orders
10. Importing Free Text Invoices
11. Importing Purchase Orders

Have a look. Happy Data Conversion :-)

Microsoft Forecaster & It's Future

There has been lot of questions on Microsoft Forecaster, will it remain? Or will get discontinued? What will be the future?   

 In simple this is the simple update for Microsoft Forecaster.

“We’ve extended the mainstream support for Forecaster until July 2014, with extended support through July of 2019 “

You can check the details on Microsoft Product Lifecycle for product support life cycle information.

Read the complete details of the original post on Dynamics Corporate Performance Management blog here.

Dynamics GP 2010 Reporting Ledgers Usage In Fixed Asset Module

A detailed Post by Mr. Sivakumar on his blog “Interesting  Findings & Knowledge Sharing ” about usage of Reporting Ledgers in Fixed Asset modules.

Check out the complete details on his post HERE.

Dynamics GP Project Accounting Error - The Project Is Being edited By another User

 One of our clients recently reported the following error while the user tries to open the Project Card.

 “The Project Is Being edited By another User, please select another project/contract number"

 We checked all the users and no one was accessing this project. Then we found there are invalid entries under “PA Proj Contr Activity Master table”.

 Resolutions

Note: Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.

To resolve this problem yourself, follow these steps:

1. Have all users exit Microsoft Dynamics GP.
2. Remove the invalid record from the PA000001 table. To do this, follow these steps:

1. Back up the company database.
2. Open one of the following query tools, depending on the version of Microsoft SQL Server that you are using:
• SQL Query Analyzer
• SQL Server Management Studio
• Support Administrator Console
3. Run the following statement against the company database.

Select * from PA000001

Note The PA000001 table works as an activity table. Therefore, if no user is in the system, you do not expect any records to exist in this table. If a record still exists in this table, the record is an invalid record.

4. Run the following statement against the company database to remove the invalid record from the PA000001 table.

Delete PA000001

 

Alternatively, there is also an automated solution on partner source which can do the same for you.

Happy Consulting!

Dynamics GP 2010 & Integration Manager 11 Error

 We have situation where we upgraded one of our client to Dynamics GP 2010 with Integration manager 11. The client was using Integration manager extensively to upload all sorts of transactions and after the upgrade process the users started facing different error messages while running integration

“The destination could not be initialized due to the following problem: ActiveX component can't create object”

“The destination could not be initialized due to the following problem:  Cannot create Active X Component.  Cannon create Active X Component”

“The RPC Server is unavailable “

We tried re-installing integration manager many times but the issue remains unsolved.

Resolutions

After checking all the details we found that the “Dynamics.exe” file was not registered properly for those clients under windows registry. We manually registered the file and it worked

To register “Dynamics.exe” manually, follow the below steps

-      Log on to the computer with the user who is receiving the error message while doing integration.

-      Reregister the Dynamics.exe file, To reregister

o    Click Start,

o    Then Click Run,

o    Then Type "\FileName.exe “/REGSERVER, and then click OK.

        = Represents the full path of the folder that contains the file, and the placeholder

FileName.exe = Represents the name of the file.

For example, type the following string:

“C:\Program Files\Microsoft Dynamics\GP2010\Dynamics.exe” / REGSERVER

Once registered successfully, integration manager will start working properly.

Happy Integrations.