FIXED ASSET FILTER (AX2012)

This question is not answered

I have multiple assets in a Fixed aset group.

In the fixed asset menu, I enter the first part of a fixed asset number in the filter field. AX brings me the list of all the assets "that start with" (the filter I entered).  When I select one of the assets in the shown group of assets, AX opens the first asset of the shown group instead of the asset I'm double clicking on.    

Is this a bug or is this the way it is supposed to work ?

Note: by default, when entering in the fixed asset menu, the Sort is on the "Fixed asset group" column.

The only workaround I found is that I need to sort by the "Fixed asset number" column in order to get to the right fixed asset when I double click on it.

Anyone experimenting the same issue ?

Thanks

Suzanne Gosselin    (gosselins@grics.qc.ca)

All Replies
  • Suzanne,

     

    If you click on the grid and press Ctrl+G you can specify filter criteria for each field in the grid.

    For example, if you want to show only the records starting with 5051, you can type 5051*.

     

    Kind Regards,

    Velislav Marinov

  • Velislav,  

    I tried what you suggested, I get the same problem (see image)

    (if you don't see the image, please let me know by emai at gosselins@grics.qc.ca

     

  • This is definitely a bug, I will write it up.

    -----------------------------------
    David Kidder
    Senior SDET | Microsoft Dynamics AX
    This posting is provided "AS IS" with no warranties and confers no rights

  • Suzanne,

     

    Thank you for clarifying the issue. The reason for this behaviour (as you correctly noted) is that the records in the FA form are ordered by fixed asset group.  

    One possible solution to this would be to apply a filter to the FA list page and then use the Next/Previous records on the FA form. The keyboard shortcuts for these actions are Ctrl+PgDwn and Ctrl+PgUp, respectively.

    If you think that this is not practical enough, a quick & dirty fix would be to add the code below to the AssetTable form in the AOT. It is also a good idea to have a technical person take a look at it.

    public void run()

    {

        super();

        if(this.args() &&

           this.args().menuItemName() == menuItemDisplayStr(AssetTable) &&

           this.args().dataset() == tableNum(AssetTable) &&

           this.args().record().RecId)

        {

            assetTable_ds.findValue(fieldNum(AssetTable, RecId), int642str(this.args().record().RecId));

        }       

     

    Please note that this code should be removed once MS resolve this problem.

     

    Kind Regards,

    Velislav Marinov