Default Dimension D365FO AX-2012

Default Dimension D365FO AX-2012

Following Code will help you to create Default Dimension using X++



Default Dimension Class 

public class DefaultDimesnionHelper

{

    public static DimensionDefault createDefaultDimension(container conAttribute,container attributeValue)

    {

        DimensionAttributeValueSetStorage   valueSetStorage = new DimensionAttributeValueSetStorage();

        DimensionDefault                    result;

  

        int                     i;

        DimensionAttribute      dimensionAttribute;

        DimensionAttributeValue dimensionAttributeValue;

  

        // Note that "Item" is not one of the default dimension,

        // but DimensionAttributeValueSetStorage will handle it gracefully

        container               conAttr = conAttribute;

        container               conValue = attributeValue;

        str                     dimValue;

  

        for (i = 1; i <= conLen(conAttr); i++)

        {

            dimensionAttribute = dimensionAttribute::findByName(conPeek(conAttr,i));

      

            if (dimensionAttribute.RecId == 0)

            {

                continue;

            }

      

            dimValue = conPeek(conValue,i);

      

            if (dimValue != "")

            {

                // The last parameter is "true". A dimensionAttributeValue record will be created if not found.

                dimensionAttributeValue =

                    dimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,dimValue,false,true);

          

                // Add the dimensionAttibuteValue to the default dimension

                valueSetStorage.addItem(dimensionAttributeValue);

            }

        }

  

        result = valueSetStorage.save();

        return result;

    }

}

Support Faryal's Cusine

Create Customer using X++ D365FO & AX-2012

Create Customer using X++ D365FO & AX-2012

Following Code will help you to create customer using X++



Default Dimension Class 

public class DefaultDimesnionHelper

{

    public static DimensionDefault createDefaultDimension(container conAttribute,container attributeValue)

    {

        DimensionAttributeValueSetStorage   valueSetStorage = new DimensionAttributeValueSetStorage();

        DimensionDefault                    result;

  

        int                     i;

        DimensionAttribute      dimensionAttribute;

        DimensionAttributeValue dimensionAttributeValue;

  

        // Note that "Item" is not one of the default dimension,

        // but DimensionAttributeValueSetStorage will handle it gracefully

        container               conAttr = conAttribute;

        container               conValue = attributeValue;

        str                     dimValue;

  

        for (i = 1; i <= conLen(conAttr); i++)

        {

            dimensionAttribute = dimensionAttribute::findByName(conPeek(conAttr,i));

      

            if (dimensionAttribute.RecId == 0)

            {

                continue;

            }

      

            dimValue = conPeek(conValue,i);

      

            if (dimValue != "")

            {

                // The last parameter is "true". A dimensionAttributeValue record will be created if not found.

                dimensionAttributeValue =

                    dimensionAttributeValue::findByDimensionAttributeAndValue(dimensionAttribute,dimValue,false,true);

          

                // Add the dimensionAttibuteValue to the default dimension

                valueSetStorage.addItem(dimensionAttributeValue);

            }

        }

  

        result = valueSetStorage.save();

        return result;

    }

}

Customer Code

public class CustomerHelper

{

   

    private void new()

    {

    }

    public static CustomerHelper construct()

    {

        return new CustomerHelper();

    }

    public void createCustomer()

    {

        CustTable                    custTable;

        NumberSeq                    numberSeq;

        Name                         name ='Systems Limited Karachi, Pakistan';

        DirParty                        dirParty;

        DirPartyPostalAddressView       dirPartyPostalAddressView;

        DirPartyContactInfoView         dirPartyContactInfo;

        ;

        container      conAttribute=["BusinessUnit","CostCenter","Department"];

        container      conAttributeValue=["001","007","022"];

        /* Marks the beginning of a transaction.

        Necessary to utilize the method numRefCustAccount() */

        ttsBegin;

        custTable.initValue();

        try

        {

            //CustTable

            //numberSeq               = NumberSeq::newGetNum(CustParameters::numRefCustAccount());

            // custTable.AccountNum    = numberSeq.num();

            custTable.AccountNum    = "US-00099";

            custTable.CustGroup     ='30';

            custTable.Currency      ='USD';

            custTable.PaymTermId    ='Net10';

            custTable.PaymMode      ='CHECK';

            custTable.DefaultDimension=DefaultDimesnionHelper::createDefaultDimension(conAttribute,conAttributeValue);

            custTable.insert(DirPartyType::Organization, name);

            //DirParty

            /* Creates a new instance of the DirParty class from an address book entity

            that is represented by the custTable parameter. */

            dirParty = DirParty::constructFromCommon(custTable);

            dirPartyPostalAddressView.LocationName      ='Systems limited Karachi, Pakistan ';

            dirPartyPostalAddressView.City              ='Karachi';

            dirPartyPostalAddressView.Street            ='Shah-re-faisal alcope-house';

            dirPartyPostalAddressView.StreetNumber      ='18';

            dirPartyPostalAddressView.CountryRegionId   ='PAK';

            dirPartyPostalAddressView.State             ='Sindh';

            dirPartyPostalAddressView.IsPrimary             = NoYes::Yes;

            // Fill address

            dirParty.createOrUpdatePostalAddress(dirPartyPostalAddressView);

            dirPartyContactInfo.LocationName    ='Email Address';

            dirPartyContactInfo.Locator         ='ShaikhSohailHussain@gmail.com';

            dirPartyContactInfo.Type            = LogisticsElectronicAddressMethodType::Email;

            dirPartyContactInfo.IsPrimary       = NoYes::Yes;

            // Fill Contacts

            dirParty.createOrUpdateContactInfo(dirPartyContactInfo);

            dirPartyContactInfo.LocationName    ='Mobile Number';

            dirPartyContactInfo.Locator         ='923422722538';

            dirPartyContactInfo.Type            = LogisticsElectronicAddressMethodType::Phone;

            dirPartyContactInfo.IsPrimary       = NoYes::Yes;

            // Fill Contacts

            dirParty.createOrUpdateContactInfo(dirPartyContactInfo);

            // Marks the end of transaction.

            ttsCommit;

        }

        catch(Exception::Error)

        {

            ttsAbort;

            throw Exception::Error;

        }

    }

}

Kindly check the below screenshot

Support Faryal's Cusine

Import Export Model D365FO

Import Export Model D365FO

Export Model

ModelUtil.exe -export -metadatastorepath=[path of the metadata store] -modelname=[name of the model to export] -outputpath=[path of the folder where the model file should be saved]

ModelUtil.exe -export -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement" -outputpath=c:\temp



Import Model

ModelUtil.exe -import -metadatastorepath=[path of the metadata store where model should be imported] -file=[full path of the file to import]

ModelUtil.exe -import -metadatastorepath=C:\AOSService\PackagesLocalDirectory -modelname="FleetManagement" -outputpath=c:\temp


Important 
You can find the model name in Descriptor file in the tag of   <DisplayName> Tag

Support Faryal's Cusine

Generate class from SQL database table

Generate class from SQL database table

declare @TableName sysname = 'BANKACCOUNT'

declare @Result varchar(max) = 'public class ' + UPPER(LEFT(@TableName,1))+LOWER(SUBSTRING(@TableName,2,LEN(@TableName)))  + 'Entity

{'

select @Result = @Result + '

    public ' + ColumnType + NullableSign + ' ' + ColumnName + ' { get; set; }

'

from

(

    select

        replace(col.name, ' ', '_') ColumnName,

        column_id ColumnId,

        case typ.name

            when 'bigint' then 'long'

            when 'binary' then 'byte[]'

            when 'bit' then 'bool'

            when 'char' then 'string'

            when 'date' then 'DateTime'

            when 'datetime' then 'DateTime'

            when 'datetime2' then 'DateTime'

            when 'datetimeoffset' then 'DateTimeOffset'

            when 'decimal' then 'decimal'

            when 'float' then 'float'

            when 'image' then 'byte[]'

            when 'int' then 'int'

            when 'money' then 'decimal'

            when 'nchar' then 'char'

            when 'ntext' then 'string'

            when 'numeric' then 'decimal'

            when 'nvarchar' then 'string'

            when 'real' then 'double'

            when 'smalldatetime' then 'DateTime'

            when 'smallint' then 'short'

            when 'smallmoney' then 'decimal'

            when 'text' then 'string'

            when 'time' then 'TimeSpan'

            when 'timestamp' then 'DateTime'

            when 'tinyint' then 'byte'

            when 'uniqueidentifier' then 'Guid'

            when 'varbinary' then 'byte[]'

            when 'varchar' then 'string'

            else 'UNKNOWN_' + typ.name

        end ColumnType,

        case

            when col.is_nullable = 1 and typ.name in ('bigint', 'bit', 'date', 'datetime', 'datetime2', 'datetimeoffset', 'decimal', 'float', 'int', 'money', 'numeric', 'real', 'smalldatetime', 'smallint', 'smallmoney', 'time', 'tinyint', 'uniqueidentifier')

            then '?'

            else ''

        end NullableSign

    from sys.columns col

        join sys.types typ on

            col.system_type_id = typ.system_type_id AND col.user_type_id = typ.user_type_id

    where object_id = object_id(@TableName)

) t

order by ColumnId

set @Result = @Result  + '

}'

print @Result

public class BankaccountEntity

{

    public int ID { get; set; }

    public string BANK { get; set; }

    public string ROUNTINGNUM { get; set; }

    public string CURRENCY { get; set; }

    public string ACCOUNTNUM { get; set; }

    public int? MAINACCOUNTID { get; set; }

    public string IBAN { get; set; }

    public string SWIFT { get; set; }

    public string BRANCH { get; set; }

    public string CONTACTPERSON { get; set; }

    public string CONTACTPHONE { get; set; }

    public string CONTACTEMAIL { get; set; }

    public bool? STATUS { get; set; }

}

Support Faryal's Cusine

Map Enumerator VS Map Iterator D365FO

Map Enumerator VS Map Iterator

Map Enumerator

Map enumerators are automatically created on the same tier as the map when you call the Map.getEnumerator method.

Using the MapEnumerator class avoids a potential problem in code marked as Called from, where the iterator and map can end up on separate tiers

Map enumerators require less code than map iterators, they perform slightly better.

Map Iterator

Map Iterator should be used when you want to delete items from a list by using the MapIterator.delete method.

Support Faryal's Cusine

LCS Package Deployment failed D365FO

LCS Package Deployment failed D365FO

Yesterday, I faced the error during Package deployment through LCS on newly provision Environment.

Deployment were crash on Step-24 and on Runbook the only thing is mentioned that script halted..


Runbook Step

 <Log>
      <Time>2018-08-28T07:02:12.4782433+00:00</Time>
      <MachineName>KHA-DEV-1</MachineName>
      <StepID>24</StepID>
      <Message>The step started</Message>
    </Log>
    <Log>
      <Time>2018-08-28T07:03:46.6864227+00:00</Time>
      <MachineName>KHA-DEV-1</MachineName>
      <StepID>24</StepID>
      <Message>ScriptHalted</Message>
    </Log>
    <Log>
      <Time>2018-08-28T07:03:46.6864227+00:00</Time>
      <MachineName>KHA-DEV-1</MachineName>
      <StepID>24</StepID>
      <Message>The step failed</Message>
    </Log>

When I download the detail logs of the deployment nothing was mentioned their related to Failure of the step..


When I check event viewer logs of the Instance found below error 

Faulting application name: Microsoft.Dynamics.AX.Deployment.Setup.exe, version: 7.0.4841.41289, time stamp: 0x1d43b12822ca100
Faulting module name: , version: , time stamp: 0x Please see crash analysis results at https://azurewatson.cloudapp.net
Exception code: 0x Please see crash analysis results at https://azurewatson.cloudapp.net
Fault offset: 0x Please see crash analysis results at https://azurewatson.cloudapp.net
Faulting process id: 0x1980
Faulting application start time: 0x1d43ea61e64c62f, kernel time: 0x02a05724, user time: 0x07f8dcf0
Faulting application path: K:\AosService\WebRoot\bin\Microsoft.Dynamics.AX.Deployment.Setup.exe
Faulting module path:  Please see crash analysis results at https://azurewatson.cloudapp.net
Report Id: 7862bf9a-e223-4488-aa6d-a3b5fe340b37
Faulting package full name: 
Faulting package-relative application ID:


After spending hours of hours we decide to log the issue to Microsoft about this strange behavior..

After investigation Microsoft found that this is product issue which they are facing on newly create VM and provide solution with us..

Following is the solution provided by Microsft

The workaround for the issue is the following, and from my testing, these steps can be performed on a machine that is a non-admin developer box in Microsoft’s subscription:

1. Go to the Environment Details page that shows the servicing status of Failed
2. Click on the Manage Environment header if you need to expand it to see the RDP and password information
3. RDP into your Developer/Demo or AOS machine within the environment and perform the following steps to Repair the ODBC Driver 17 installation on the machines
1. Go to the Start menu and open Add or Remove programs
2. In the Add or Remove Programs window, type ODBC in the Search box which should let you see the following results:

                                 

3. Then highlight the ODBC Driver 17 and press Modify, then click Next on the opening window of the wizard
4. Then choose Repair and press Next and then press Install on the next dialog

             

5. Wait for the install to finish and press the Finish button
6. Repeat these steps for every AOS machine in your environment (including any Private AOS) if you are using a multi-box Sandbox environment.
3. After these steps have been performed on every AOS, go back to LCS and press Resume to continue with the servicing operation.
4. If the you already aborted the operation, you can perform these actions BEFORE starting the servicing operation

Support Faryal's Cusine