Installation of Management Reporter 2012 for AX 2012

Installation of Management Reporter 2012 for AX 2012

Reference Link

This post will take you through the basic steps of installing, configuring and a basic test of Management Reporter 2012 for AX 2012. This tool is now easily available after AX 2012 R2 CU7 as part of the Dynamics AX Setup and the tools has also been translated and made available for multiple languages.

The Reporting tool has a lot of features and Microsoft has release several videos to cover some of the functionality. Technet also describes in detail how to install and setup this tool, and you can also download a comprehensive set of whitepapers and documents covering a lot of ground for this tool.

For the sake of simplicity, I will run you through the setup with some screen shots. I am assuming you're the tech guy which has been given the task by the financial consultant to get this tool installed as soon as possible.
As with all UI, there might be minor changes in the upcoming versions.

The guide will be in three sections:

1. Installing the Server components
2. Installing the Client components
3. Testing!

Before you begin you should have prepared a new domain user which will be used by the service to connect and collect data from AX. I will assume you have full access to the AOS and SQL Server and that you are on AX2012 R2 with CU7 (or higher). Needless to say, but you can obviously do all the three steps above on the same machine - if that is your swag.

Estimated installation time? We should be done within an hour. :-)

1. Installing the Server Components

Run AXSetup and choose to install "Management Reporter"

Type in the details for the AOS you want to the Management Reporter Service to connect to. This is neat if you want to diversify what AOS you want to handle any load.

Select the SQL Server Instance and Database holding the business data. In my example setup threw an error before I was able to select an actual server running a SQL Server Instance. Maybe they'll fix that in some update.  

Enter the credentials for the service account which the Management Reporter Service will run as. I chose to use the same service account as the AOS.

Type in some additional details for the Management Reporter Service. Default port is 4712. The first database entry points to the configuration database. The second to the data mart database, which will hold report data. I just added a suffix so I can test installing multiple instances later on. 

Finally type in the credentials for the domain user which will be used to connect to AX and collect data. Either let the installer set it up or choose an existing AX User ID.

Done!

Before we continue, let us check some things. You should have a new shortcut named "Configuration Console" on the Start menu. Open the Console, locate  "Data Mart Integration" and hit Refresh. Observe that things look promising. It might take a few minutes before data has been collected fully to the Data Mart Database. 

Oh, and if you wonder how that link from AX works, you should also have an entry in LedgerParameters.ManagementReportUrl for the company that has an active integration. Setup should have added that. If not, you will have to do some manual steps from this Configuration Console, but that is not the scope of this post.

2. Installing the Client Components

Run AXSetup and chose to install "Management Reporter Report Designer". This will install both the Designer and the Viewer. You can install these on the terminal server if that fits your requirements. 

Done!

3. Testing!

Let us do some testing now that we have things installed!

The Designer

First, let's test the Designer. Locate the shortcut "Report Designer" under the Start menu. 

Enter the url to the server and port where the Management Reporter is running and connect. This is a one time per user per machine thing (as far as I know).

Select a company and hit the "Set As Default".

Select the first report and hit "Generate" on the toolbar.

Observe while the report is generated. Let it complete and wait for the report to be launched in a new window.

And the report should open. Yea, I hid some of the numbers from my demo.

The Viewer

Now for the Viewer. Locate the shortcut "Report Viewer" under the Start menu.

This tool might also need to have its connection properly set. The setting is under Tools, Connection.

Double click the generated report located in the Report Library and observe it loads an integrated view of the report.

And that is it. Now tell me, did it take you more than an hour to get this up? Next up is to inform the financial consultants that you're done and they can start hammering the tool for awesome reports. 

Final note

Have someone with access to the customer license (VOICE) download the license for the Management Reporter. It is its own license file, and you only have to copy+paste its content into the Registration form under Tools. If you don't do this step, you are limited to less than a handful of users, which is fine for testing, but not the real deal.

Also, don't bother to add users manually. These will be populated from AX dependent on what users have access to what. This is all documented in the Installation Guide for the AX provider.

Data are being held up to date by using SQL Server Change Tracking. If you however notice data not being refreshed and updated properly, you will find steps to resolve this in the already mentioned guide.

I hope this little guide helped you get going with Management Reporter 2012 for Dynamics AX 2012 R2 (CU7 and upwards). There are plenty of guides out for both installing, configuring and using this Reporting tool - I just felt like making one myself as well.

Report to display current record in the Form in ax 2009

Report to display current record in the Form in ax 2009

Reportàmethodsà initFromCaller

public void initFromCaller(Args _args)

{

    BiddingMainCostSheetTable     _BiddingMainCostSheetTable;

    BidServiceCostSheetTable _bidServiceCostSheetTable;

  //  BidSvcsBOQSectionTable _bidSvcsBOQSectionTable;

    QueryBuildDataSource    qbds;

    ;

    if (_args.caller())

    {

        if (! _args.record().RecId)

            throw error(strfmt("@SYS22338",funcname()));

        switch (_args.dataset())

        {

            case tablenum(BiddingMainCostSheetTable):

                _BiddingMainCostSheetTable  = _args.record();

                qbds = element.query().dataSourceTable(tablenum(BiddingMainCostSheetTable));

                qbds.clearRanges();

                SysQuery::findOrCreateRange(qbds, fieldnum(BiddingMainCostSheetTable, MainCostSheetId));

                if (_BiddingMainCostSheetTable.MainCostSheetId)

                {

                    SysQuery::findOrCreateRange(qbds, fieldnum(BiddingMainCostSheetTable, MainCostSheetId)).value(_BiddingMainCostSheetTable.MainCostSheetId);

                }

                break;

            case tablenum(BidServiceCostSheetTable):

                _bidServiceCostSheetTable = _args.record();

                qbds = element.query().dataSourceTable(tablenum(BiddingMainCostSheetTable));

                qbds.clearRanges();

                SysQuery::findOrCreateRange(qbds, fieldnum(BiddingMainCostSheetTable, MainCostSheetId));

                if (_bidServiceCostSheetTable.MainCostSheetId)

                {

                    SysQuery::findOrCreateRange(qbds, fieldnum(BiddingMainCostSheetTable, MainCostSheetId)).value(_bidServiceCostSheetTable.MainCostSheetId);

                }

                break;           

            default:

                throw error(strfmt("@SYS23396",funcname()));

        }

    }

}

AX Report 2009 displaying only on the last page

AX Report 2009 displaying only on the last page

Hi, 
Normally developers need the term and condition or other stuff to be displayed only on the last page .To insert the footer only on the last page of Axapta report do the following stes.
1. Declare a boolean variable (pageFooter) in report class declaration method .
             public class ReportRun extends ObjectRun
            {
                 boolean pageFooter;
            }
2. Override the report fetch method with query 
          public boolean fetch()
          {
               boolean ret;
               ret = super();
               printPageFooter=false;
                while(queryrun.next())
                {

                }
               printPageFooter=true;
               return true;
          }

3. Override the executeSection method of footer 
      
          public void executeSection()
          {
                if(printPageFooter==true)

                super();
           }

Report to display current record in the Form On button click in ax 2009

Report to display current record in the Form On button click in ax 2009

Report to display current record in the Form On button click in ax 2009

·         In click method (First Method)

void clicked()

{

    Args                    args;

    ReportRun               reportRun;

;

    super();

    args = new Args();

    args.name(reportStr(NSGEmplVacations));

    reportRun = new ReportRun(args);

    reportrun.report().interactive(false);

    reportrun.query().interactive(false);

                                                                SysQuery::findOrCreateRange(reportrun.query().dataSourceTable(tablenum(EmplTable)),

                  fieldnum(EmplTable, EmplId)).value(Vacations.EmplId);

    reportRun.init();

    reportRun.run();

}

·         In the click method(Second Method)

1.       void clicked()

{

    Args        args;

    ReportRun   reportRun;

    NASVacationTransId      _VacationTransId;

      ;

    args = new args();

    args.name(reportstr(NSG_VacationRequestReport));
    args.record(Vacations);

    args.parm(Vacations.NASVacationTransId);

    reportRun = classFactory.reportRunClass(args);

    reportRun.init();

    reportRun.run();

}

2.       public boolean fetch()

{

    boolean ret;

this.query().dataSourceTable(TableNum(Vacations)).addRange(FieldNum(Vacations,    NASVacationTransId)).value(_VacationTransID);

    ret = super();

    return ret;

}

3.       public void init()

{

    _VacationTransID    = element.args().parm();

    _vacTable           = element.args().record();

    super();

}

AX 2012 | Cash On Delivery

1- First, setup the cash on delivery payment terms. Go to Accounts receivable > setup > Payment > Terms of payment. Click New then enter the code and description then make sure to select COD form payment method also make sure to clear the cash payment checkbox.

2- Next, Create sales invoice. Go to accounts receivable > common > free text invoices > all free text invoices. Click New then select the customer and enter the details.

3- Next, switch to header view go to payment tab then select the cash on delivery from the Terms of payment list.

4- Next, post the invoice.

5- Verify the invoice has been posted.

6- To track the cash on delivery outstanding sales invoices go to to accounts receivable > Inquiries > COD outstanding. Make sure to select the Show Open Only. note that the outstanding COD invoices has been listed.

7- To track the expected COD receipts you can use the COD report. Go to accounts receivable > reports > Transactions > Customer > COD. Select the report criteria then click OK.

8- The report illustrate the expected COD receipts grouped by Mode of delivery.

AX 2012 | Importing purchase orders using DIXF

In this post we will illustrate how to import purchase orders through data import export framework. we will use one excel file which contain purchase order header in first sheet and purchase order details in another sheet.


to import the purchase order please do the following steps:

1- Go to Data import export framework --> Setup --> Data import / export framework Parameters.

2- Click browse to select shared working directory then click Validate button then close the form.

3- Go to Data import export framework --> Setup --> Source Data format, Create new source name and make sure to chose File in the Type field then select the file format in my example i will use excel. 

4- Go to Data import export framework --> Common --> Processing Group, Create New Group then Click the Entities Button.

5- in the entities form select the Purchase Order Header Entity,select Excel in the Source data format, then Click the generate source file button.

6- In the wizard click next then Make sure to select the following fields:
CurrencyCode
InvoiceAccount
LanguageId
OrderAccount
PurchId
VendGroup
PurchName
PurchaseType
PurchStatus
DocumentState
DeliveryDate

Then click Generate sample file.

7- when the excel file is opened, change the sheet name to POH.

8- Select the second sheet in the Excel, Change the sheet name to POL then add the following field names:

CurrencyCode
VendAccount
VendGroup
PurchId
ShippingDateConfirmed
LineNumber
ItemId
Name
PurchQty
PurchUnit
PurchPrice
InventSiteId
InventLocationId
PurchaseType

09- Go back to POH sheet, enter the purchase order header details.

10- select the POL sheet, Enter the purchase order lines details. in this example i will add two lines

10- when you finish make sure to save the file in the shared folder that we specified in step 2.

11- Go back to the processing group --> entities---> Select the "Purchase order header" entity, specify  the Excel file path then from the sheet lookup select POH$, click generate source mapping button.

12- Click New, Select Purchase order line entity, select Excel from source,specify the Excel file path then from the sheet lookup select POL$, click generate source mapping button then close. 

13- To preview the Purchase header details select purchase order header entity then Click the Preview source file button.

14- To preview the Purchase lines details select purchase order line entity then Click the Preview source file button. 

15- Close the form

16- In the processing group select the group name then click the Get staging data button to copy the file data to staging table.

17- Click OK to create job.

18- Click Run in the staging data execution form.

19- Click OK. (sorry, i forget to capture the screenshoot. its looks exactly like the following screenshot but with different name   )

20- The records will be inserted in the staging.

21- In the processing group select the group name then click Copy Data to target button.

22- Select the Job ID that we created in step 17 then click OK.

23- Click Run to import data.

24- Click OK.

25- The data will be written to target.

26- To view the imported purchase order go to the all purchase order list form, you will found that the purchase order was imported successfully.