How to generate serial number only visible records in SSRS Report

S.NO> function

=RunningValue( IIf(Fields!Payable.Value <= 0, Nothing, Fields!Payable.Value)
    , CountDistinct
    , "Tablix1")

Comparing insert and insert_recordset

Comparing insert and  insert_recordset 

insert()

static void prodinsert(Args _args)
{
 EcoResProduct                           ecoResProduct;
 EcoResProductIdentifier                 ecoResProductIdentifier;
 
 ttsBegin;
 while select ecoResProduct
      
  {
   ecoResProductIdentifier.Product = ecoResProduct.RecId;
   ecoResProductIdentifier.ProductNumber = ecoResProduct.DisplayProductNumber;
   ecoResProductIdentifier.insert();

    }
     ttsCommit;
    

}

insert_recordset()

static void Ecoresprodinsert(Args _args)

{ 

EcoResProduct        ecoResProduct; 

EcoResProductIdentifier        ecoResProductIdentifier;
;   

insert_recordset ecoResProductIdentifier(Product,ProductNumber)


  select RecId,DisplayProductNumber from ecoResProduct;      

   {           

    info(strFmt("%1",ecoResProductIdentifier.ProductNumber));
   }

  }

by using joins

https://msdn.microsoft.com/en-us/library/aa635694.aspx

Morphx Tools and Other Components in Ax 2012

Morphx Tools and Other Components :

How to Add Find/Filter on Display method

https://community.dynamics.com/ax/b/matrishmangal/archive/2010/05/14/adding-find-92-filter-functionality-on-display-method


http://dynamicsaxsolutionsworld.blogspot.fi/2011/09/how-to-add-search-find-filter.html

DMF

DMF Installation

https://axnmaia.wordpress.com/2013/04/10/data-importexport-framework-walkthrough-installation/

WalkThrough

https://axnmaia.wordpress.com/2013/05/11/data-importexport-framework-walkthrough-importing-data/

Find and exist methods

Find() :
Each table with a key should have a static find method. The method is used to find a record that fulfills the specified key.

The find method must:

• Be static because it is used to find a record among all the objects of the table class.
• Return an object of the type of the table (or null if not found).
• Be named find.
• Have a parameter of the same type as the key of the table or a list of parameters if the key consists of more than one field. If there is a list of parameters, they must be in the same order that the key fields are listed in the index that supports the key of the table.
• Have a Boolean parameter with a default value of false.  If true, the record should be selected for update.
• Have an optional parameter to enable the default Concurrency Model behavior specified on the table to overruled. The default value for the parameter should be ConcurrencyModel::Auto.
• Make the most effective select operation for the single record from the table and return it. Use an index that matches the required field, and use the firstOnly keyword (see the following example).
• Run on both the client and the server. This is the default behavior. You can also make it explicit by putting "client server" in the declaration, but do not specify a single tier in the declaration (either the client or the server).
• Declare find methods as Public. If you do not, a best practices warning appears if the method is not used in the application. (The warning suggests that you declare the method as private because this is the most restrictive level of access.)

Example :

static CustTable find(CustAccount   _custAccount, boolean   _forUpdate = false)

{

    CustTable          custTable;

    if (_custAccount)

    {

        if (_forUpdate)

        {

            custTable.selectForUpdate(_forUpdate);

        }

        select firstonly custTable

            index hint AccountIdx

            where custTable.AccountNum == _custAccount;

    }

    return custTable;

}

Exist() :

Each table with a key should have a static exist method. Use it to check if a record that fulfills the specified key actually exists.

The exist method must:

• Be static because it is used to check if any table object (record) exists among all the objects of the table class.
• Return a boolean value.
• Take an argument of the type of the key of the table or a list of arguments if the key consists of more than one field. If there is a list of arguments, they must be in the same order as the fields in the index that are used for the table's key.
• Check for the most effective, existing index in the record against the supplied key, and then return true if it is in the table. If not,false.
• Run on both the client and server. This is the default behavior. You can also make it explicit by putting "client server" in the declaration, but do not specify a single tier in the declaration (either the client or the server).

The method must be used whenever one record should be checked that is exists based on its key.

Example :

public static boolean exist(VendAccount   _vendAccount )

{

    boolean   found;

  ;

found = (select firstonly  RecId  from vendTable

             where

                 vendTable.AccountNum == _vendAccount).RecId != 0;

    return found;

}

How to make dimension mandatory in ax 2012

I want customer dimension mandatory when creating a new customer

Form> CustTable > Method

public boolean checkcustomer(RecId _ledgerDimID)
{
    DimensionAttribute                  dimAttr;
    DimensionAttributeValue             dimAttrValue;
    DimensionAttributeValueSetItem      dimAttrValueSetItem;
    RefRecId                            defaultDimension;
    boolean                             ret;
    ;

    defaultDimension    =   _ledgerDimID;

    dimAttr             =   DimensionAttribute::findByName('Customer');

    select firstonly RecId, DisplayValue from dimAttrValueSetItem
                where dimAttrValueSetItem.DimensionAttributeValueSet == defaultDimension
            join dimAttrValue
                where dimAttrValue.RecId == dimAttrValueSetItem.DimensionAttributeValue &&
                dimAttrValue.DimensionAttribute == dimAttr.RecId       &&
                dimAttrValue.IsDeleted == false;

    if (!dimAttrValueSetItem.DisplayValue)
    {
        ret  = checkFailed("Customer dimension must be specified.");

    }
    else
    {
        ret = true;
    }

    return ret;
}

go to form level custtable datasource  validateWrite method 

 if(element.checkcustomer(CustTable.DefaultDimension) )

    {

       ret = true;

    }

    else

    {

        ret = false;

    }