Thursday, March 28, 2013

Microsoft Management Reporter 2012 Integration TraceLog

Many people face a lot of issue in data integration but the errors is not enough as the data mart integration log just present error subject, in the following post we will see how to increase the data mart integration trace log level.

  1. Navigate to C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.1\Server\Services\
  2. Open the MRServiceHost.exe.config in notepad.
  3. Search for <add name="Microsoft.Dynamics.Integration.TraceLog" value="0"/>
  4. Change the 0 to a 4, so it looks like this:   <add name="Microsoft.Dynamics.Integration.TraceLog" value="4"/>
  5. Restart the MR Process Service.
The log file will capture the error and it may provide some more input to what is failing.

Wednesday, March 27, 2013

Dynamics AX 2012 purchasing posting types “Purchase Expenditure"

Purchase Expenditure for product and Purchase expenditure, un-invoiced posting types were introduced in AX2012 as part of the two voucher strategy for Purchase Distributions. The purchase expenditure for product is used for invoice posting and the Purchase expenditure, un-invoiced is used for posting of product receipts. Failure to set up these accounts will result in error when attempting to post a product receipt and/or invoice.

The purpose of the new posting accounts is to allow Microsoft Dynamics AX to write an accounting entry for the whole value of the purchase, without any variances, and thus allow it to handle the variances in a separate voucher. This new posting account temporarily records the cost in control account and then moves the cost into ledger account. Effectively, INVENTTRANS credits the Purchase expenditure account for product and then debits Inventory Receipt account.

In the scenario below, without tax or any additional costs or discounts, the following journal entries will be made. Standard cost item for $100USD, Purchased from the vendor for $115USD.

New accounting entries for Microsoft Dynamics AX2012:

Accounts used for receipt:

Voucher 1:

Debit: $115 Purchase expenditure, un-invoiced (total PO amount)
Credit: $115 Purchase, accrual (total PO amount)

Effect: Creates liability for goods received not invoiced (balanced by Purchase expenditure


Voucher 2:

Debit: $100 Product receipt (standard cost amount)
Debit: $15 Purchase price variance (for the variance amount)
Credit: $115 Purchase expenditure, un-invoiced (total PO amount)

Effect: Creates increase in value of receipted goods and records standard cost deviation (balanced by Purchase expenditure un-invoiced)


Accounts used for invoice:

Voucher 1:

Debit: $115 Purchase, accrual – for the whole PO amount
Credit: $115 Purchase expenditure, un-invoiced for the whole PO amount

Effect: Balances the 1st Product receipt voucher

Voucher 2:

Debit: $115 Purchase expenditure for product (total PO amount)
Credit: $115 Vendor balance (total PO amount)

Effect: Creates entry to Purchase Expenditure for
Product and created vendor liability

Voucher 3:

Debit: $115 Purchase expenditure, un-invoiced (total PO amount)
Debit: $100 Purchase, inventory receipt (standard cost amount)
Credit: $ 100 Product receipt (standard cost amount)
Credit: $ 115 Purchase expenditure for product (total PO amount)

Effect: Create an increase in inventory value and
standard cost variance and balances the product receipt.


The value of inventory will increase (for a normal purchase) and
where a standard cost item is being used, if there is a variance this will be
recorded in the PPV account and liability to pay the vendor will be generated in
the vendor balance account. The new Purchase expenditure for product and Purchase expenditure, un-invoiced accounts
simply make the previous process in Microsoft Dynamics AX 2009 possible in
conjunction with the new functionality for sub ledger accounting.

Friday, March 15, 2013

How to Use Command Line Scheduling with Management Reporter for Microsoft Dynamics ERP

Management Reporter for Microsoft Dynamics ERP now supports command line report scheduling with the Feature Pack 1 release. This functionality will enable automatic report generation until this functionality is built into the user interface in a future feature pack.

Command line scheduling is available for individual reports or for report groups. When these commands are executed, they are sent to the Process Server exactly like a manually generated report.

Note The command-line options are limited to what is listed here. Any other options such as output type or output location will use the value that is stored in the report definition.

There are three requirements in order to use this feature.

  1. If you are using Task Scheduler then the user who is running the task must be a valid Management Reporter user.
  2. The Windows user must have selected the save company credentials option for the company the report is being run for.
  3. The report cannot prompt for any information during generation. The option to include all units instead of select units at runtime must be selected even if no Reporting Tree is attached.

Commands available:

Note Both the – and /  switches are valid.

Command Argument Description
/generate “ReportDefinitionName” This is the name of the Report Definition
/generategroup “ReportGroupName” This is the name of the Report Group
/reportdate “01/31/2010” This will be translated to the base period and year in the Report Definition
/? Return available command line parameters

Example syntax:
ReportDesigner.exe /generate BalSheet /reportdate 3/31/2013

  • Report will run for the company the report is attached to
    Example Batch File for Task Scheduler:

    “C:\Program Files\Microsoft Dynamics ERP\Management Reporter\2.0\Client\ReportDesigner.exe” -generate BalSheet -reportdate 3/31/2016

Any error messages will be logged in the Windows Application Event Viewer under the source of Management Reporter Report Designer.

Saturday, March 9, 2013

Out-of-the-box Exchange Rate Imports with Dynamics AX 2012 R2

Keeping with the trend of connecting Dynamics AX to the outside world through web services, and even providing out-of-the-box, ready-to-use ones, Dynamics AX 2012 R2 now allows you to set up automatic exchange rate imports in just a few clicks.
You must first set up the exchange rate provider you want to use, and AX comes with 3 providers ready to use (More can easily be developed) in General Ledger >> Setup >> Currency >> Configure Exchange Rate Providers :

Once this is done, General Ledger >> Periodic >> Import Currency Exchange Rates allows you to choose which Exchange Rate Type you want to import the rates for, and using which provider. 
You can of course set one up for each rate type, and even schedule these to import periodically using the standard AX batch feature

Once this has run, your rates can be reviewed in General Ledger >> Setup >> Currency >> Exchange Rates :

This illustrates very well how Dynamics AX Web Services integration contribute to make AX 2012 powerfully simple.

Copied from       Antoine Leblanc