Wednesday, April 25, 2012

Convert/Upgrade MorphX Report to SSRS in Dynamics AX

One of the major change in Dynamics AX 2012 is related to reporting services. Though we were able to develop some SSRS reports in AX 2009 as well with limitted framework functionality. However, in AX 2012 SSRS reporting framework is much more enhanced. Currently, you can import your AX traditional reports of MorphX in 2012 with no change. However, you cannot develop new MorphX reports in 2012. So this is the right time to move all your MorphX reports to SSRS as in future releases of AX MorphX framework will be completey removed.

In order to migrate AX reports to SSRS report following are some important points
        1.       Create a new query and make exactly the same query used in X++ report.
        2.       Move all your business logic to RDP (Report data provider) class.
        3.       AutoDesign reports of X++ will be replaced by AutoDesign in SSRS reports.
        4.       Generated Design on X++ report will be replaced by PrecisionDesign in SSRS reports.

         Please have a look on the guidance to upgrade report here.

           Enjoy DAX !!!

Tuesday, April 24, 2012

Bar Code Setup in AX 2009

   In this post we will be discussing about How to setup barcodes in AX 2009 as many companies use barcodes for different purposes like:
Tagging Items – To identify items
Tagging pallets – To identify pallets
Tagging locations – To identify locations

Microsoft Dynamics Axapta 2009 supports use of bar codes which can be setup using very simple steps. This article contains two main setups:
STEP 1: The first step is to set up the bar code to be used using AX Barcode setup form.
STEP 2: The second step is to associate the bar code with the item

STEP 1: Set up the bar code to be used using AX Barcode setup form.
1. From Dynamics AX client navigate to:
Basic > Setup > Bar code setup
2. On the overview tab, Click New and enter details:

3. In the General Tab enter Minimum and Maximum length.

Bar code setup
Type the name of the bar code.
Enter a description of the bar code.
Bar code type
Select the bar code type from the list.

Select a font for the bar code from the list of available fonts installed in Microsoft Windows.
Specify the font size of the bar code.
Minimum length
Specify the minimum length allowed for the bar code.
Maximum length
Specify the maximum length allowed for the bar code.

STEP 2: Associate the bar code with the item
1. From Dynamics AX 2009 Client navigate to:
Inventory management > Items > Setup button > Bar codes

Use this form to set up multiple bar codes for each item, in addition to setting up bar codes according to item configurations and dimensions. Bar codes identify items and register inventory information.
For example, you can set up bar codes for each color of an item, and then for every sale you register the item and the item color. In this way, you know the number of items on stock by color.

Overview tab
Get an overview of the bar codes that are associated with an item. You can also create, modify, or delete the bar codes.
General tab
View specific information about an item and the bar code that is associated with it. The information is grouped into four areas, such as information about the Item, Bar code, Setup, and Item dimension. On the General tab, you can also create, delete, or modify a bar code.
Item number
This is a unique user-defined code that is assigned when items are created. It is recommended that special characters or spaces not be used in the item number.
Item numbers can be generated by the system by linking the item number to a Number sequences (form).
Select an item configuration to specify an item with specific attributes.
Specifies the size of the item.
Specifies the color of the item.
Bar code setup
Select the bar code type that you would like to apply to the item.
Used for scanning items with us.
To be printed
Used when printing.
Bar code
Bar code digits.
Dimension No.
Identification of dimensions for the item.
Quantity in the inventory units of the item.
Brief description of the transaction.
Enter the warehouse in which you store your items.
Batch number
Enter the batch number dimension. If you select Edit lines and Explode lines in the upper section of the Shipment /Receive form, you can edit the batch number for the transfer order line.
Location inside a warehouse. If you select Edit lines and Explode lines in the upper section of the Shipment /Receive form, you can edit the location number for the transfer order line.
Pallet ID
Unique ID for the pallet (Serial Shipping Container Code).
Serial number
Serial number dimension. If you select Edit lines and Explode lines in the upper section of the Shipment/Receive form, you can edit the serial number for the transfer order line.
Inventory Button
Click Inventory > Dimensions display to select the inventory dimensions to appear in the Item - bar code form.

Enjoy DAX !!!

Wednesday, April 4, 2012

Discard USR Layer Changes in AX 2012

With the advent of model management in Dynamics AX 2012, Microsoft has gotten rid of the ax.aod files which in previous versions of DAX constituted the layers.
In DAX 2012 adjustments for the meta data model and code are stored in the modelstore in the database.

In previous version deleting a layer containing adjustments to the standard application consisted of delete the ax.aod file and synchronizing and compiling.

How is this done in DAX 2012 ?

The answer is a command-line tool called AxUtil.

To delete e.g. the usr-layer in the application do the following:

1) Shut down all AOS-servers but one (applicable only if you have more than one AOS running).
2) Go to command line interface on the server where the last AOS is running.
3) Go to the folder where DAX's management utilities are placed, e.g.
C:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities
4) Run the Axutil like this:
Axutil delete /layer: /db:

To delete the usr-layer in the MicrosoftDynamicsAx database:
Axutil delete /layer:usr /db:MicrosoftDynamicsAxBelow an example is shown:

5) Restart the AOS
6) Start the DAX client.
7) In the process of starting up, DAX will detect that something has happened with the modelstore, and prompt you with:

Choose the action appropriate for your situation.
8) Start the remaining AOSes.

Enjoy DAX!!!