Table levelemodfiied filed COC

-

 Today we have a requirement to create COC of the modified filed of the standard table So below are the example :- 


[ExtensionOf(tableStr(EntAssetWorkOrderLine))]

final class IHSEntAssetWorkOrderLineDbt_Extension

{

    /// <summary>

    /// Method to display Asset lifestate On Asset.

    /// </summary>

    /// <returns>

    /// The Asset lifestate On Asset.

    /// </returns>

    [SysClientCacheDataMethodAttribute(true)]

    display EntAssetLifecycleStateId displayAssetLifeCycleState()

    {

        EntAssetObjectLifecycleStateRecId lifeCycleStateReciD = this.objectTable().ObjectLifecycleState;//EntAssetObjectTable::ihsFindByAssetAndBarcode(EntAssetObjectTable::findRecId(this.object).ObjectID , this.IHSBarcode).ObjectLifecycleState;

        return EntAssetObjectLifecycleState::find(lifeCycleStateReciD).ObjectLifecycleStateId;

    }

==========================================================

    public static EntAssetWorkOrderLine ihsFindByWorkorderRecid(EntAssetWorkOrderRecID _recId, boolean _forUpdate = false)

    {

        EntAssetWorkOrderLine    workOrderLine;

    

        if (_recId)

        {

            workOrderLine.selectForUpdate(_forUpdate);

    

            select firstOnly workOrderLine

                where workOrderLine.WorkOrder == _recId;

        }

    

        return workOrderLine;

    }

=========================================================================

    // <summary>


    // To modifiedfield call the "avaInitFromWorkOrderType" method to check the works order type


    // </summary>


    public void modifiedField(FieldId _fieldId)

    {

        next modifiedField(_fieldId);


        switch (_fieldId)

        {

            case fieldNum(EntAssetWorkOrderLine,  Object):

                this.ihsInitFromWorkOrderObject();

                // update net value on the work orderline 

                this.ihsUpdateNetValue(this.Object);

                break;


            case fieldNum(EntAssetWorkOrderLine,  IHSAssetCondition):

                this.ihsUpdateAssetLifeCycleState();

                break;

        }

    }

=========================================================================

    // <summary>

    // Method will check that work order type what is the work order classification selected on work order typr form

    // </summary>


    public void ihsInitFromWorkOrderObject()

    {

        if(!this.RefRecId)

        {

            

            EntAssetObjectTable assetTable = EntAssetObjectTable::findRecId(this.Object);


            this.IHSBarcode = assetTable.IHSBarcode;

            this.IHSName    = assetTable.Name;

            this.IHSItemId  = assetTable.ItemId;

            this.IHSObjectLifecycleState = assetTable.ObjectLifecycleState;

            this.IHSFunctionalLocation  = assetTable.FunctionalLocation;

            this.IHSFunctionalLocationTypeId =this.functionalLocation().functionalLocationType().FunctionalLocationTypeId; //EntAssetFunctionalLocationType::findRecId(EntAssetFunctionalLocation::findRecID(this.FunctionalLocation).FunctionalLocationType).FunctionalLocationTypeId;

            this.IHSObjectTypeID = this.objectTable().objectType().ObjectTypeID; //EntAssetObjectType::find(EntAssetObjectTable::findRecId(this.objectID).ObjectType).ObjectTypeID;


            this.ihsInitFromAttributeTypeId(this.Object);

            this.displayAssetLifeCycleState();

        }

    }

=========================================================================

    public void ihsUpdateAssetLifeCycleState()

    {

        EntAssetObjectTable assetTable = EntAssetObjectTable::findRecId(this.Object);

       

        ttsbegin;

        assetTable.selectForUpdate(true);

        assetTable.ObjectLifecycleState = IHSWorkOrderAssetStateTable::findByType(this.workOrderTable().workOrderType().WorkOrderTypeId, this.IHSAssetCondition).ObjectLifecycleState;

        assetTable.update();

        ttscommit;

    }

=========================================================================

    // <summary>

    // Get the asset group from the parameter form..

    // </summary>


    public void ihsInitFromAttributeTypeId(EntAssetObjectRecID _object)

    {

        EntAssetParameters  entAssetParameters = EntAssetParameters::find();

       // EntAssetAttributeTypeId getAssetGroup = entAssetParameters.IHSAttributeTypeId;

        EntAssetObjectAttribute objectbjectAttribute;


        select firstonly objectbjectAttribute

            where objectbjectAttribute.Object == _object

            && objectbjectAttribute.AttributeTypeId == entAssetParameters.IHSAttributeTypeId;


        if(objectbjectAttribute.RecId)

        {

            this.IHSAssetGroup = objectbjectAttribute.ValueString;


        }



    }

=========================================================================

    public void ihsUpdateNetValue(EntAssetObjectRecID _object)

    {

       

        EntAssetObjectTable     objectTable;

        AssetTable              assetTable;

        EntAssetParameters      parameters  = EntAssetParameters::find();

        AssetBook               assetBook;

        IHSAssetSumCalc         ihsAssetSumTrans;

        int                     currentYear = year(systemDateGet());

        date                    startDate   = mkDate(1, 1, 1900);

        date                    endDate     = mkDate(31, 12, currentYear);

        AmountMST               netValue;


        select objectTable

            where objectTable.RecId == _object

                join assetTable

            where assetTable.AssetId == objectTable.FixedAssetId

                join assetBook

            where assetBook.AssetId == assetTable.AssetId

                && assetBook.BookId == parameters.IHSBookId;

       

            ihsAssetSumTrans = IHSAssetSumCalcTrans::newAssetPeriod(assetBook.AssetId, assetBook.BookId, startDate, endDate);

            netValue = ihsAssetSumTrans.netBookValue();


            this.IHSNetbookValue = netValue;

    }

=========================================================================

    public void ihsImportFromAssetTable()

    {

        EntAssetObjectTable assetTable = EntAssetObjectTable::ihsFindByBarcode(this.IHSBarcode);


            this.Object     = assetTable.RecId;

            this.IHSName    = assetTable.Name;

            this.IHSItemId  = assetTable.ItemId;

            this.IHSObjectLifecycleState = assetTable.ObjectLifecycleState;

            this.IHSFunctionalLocation  = assetTable.FunctionalLocation;

            this.IHSFunctionalLocationTypeId =this.functionalLocation().functionalLocationType().FunctionalLocationTypeId; //EntAssetFunctionalLocationType::findRecId(EntAssetFunctionalLocation::findRecID(this.FunctionalLocation).FunctionalLocationType).FunctionalLocationTypeId;

            this.IHSObjectTypeID = this.objectTable().objectType().ObjectTypeID; //EntAssetObjectType::find(EntAssetObjectTable::findRecId(this.objectID).ObjectType).ObjectTypeID;


            this.ihsInitFromAttributeTypeId(this.Object);

            this.displayAssetLifeCycleState();

        

    }


}

=========================================================================


Comments

Post a Comment

Popular posts from this blog

Customization on Sales invoice Report in D365 F&O

-
 We have a requirement to create a new design and show some new fields in the sales invoice report.  So for that we need to consider the below steps :-  1) Controller class than extends standard class and create alogic. 2) Create a print management class to call the new design. 3) Extension of DP class to write a logic. 4) Report design. ==================================================================== 1) Controller class : -  /// <summary> /// Extension of the controller class to call the custom design of report "MMSSalesInvoice.report" for MMS legal entity. /// </summary> class MMSSalesInvoiceController extends SalesInvoiceController {        public static MMSSalesInvoiceController construct()         {             return new MMSSalesInvoiceController();         }         public static void main(Args _args)         { ...
Read more

75) COC - Create a coc of the table modified method

-
 /// <summary> /// The <c>AvaEntAssetChecklistVariableOptionsDbt_Extension</c> contains the TransMountain extending logic for the <c>EntAssetChecklistVariableOptions</c> table. /// </summary> [ExtensionOf(tableStr(EntAssetChecklistVariableOptions))] final class AvaEntAssetChecklistVariableOptionsDbt_Extension {     /// <summary>     /// Processes the modified field event for TransMountain fields.     /// </summary>     /// <param name = "_fieldId">reference to field id</param>     public void modifiedField(FieldId _fieldId)     {         EntAssetChecklistVariableOptions entAssetChecklistVariableOptions;         next modifiedField(_fieldId);         // Default must be marked for only one check list line for the varaible.         if (_fieldId == fieldNum(EntAssetChecklistVariableOptions,...
Read more

46) D365 FO: SHAREPOINT FILE UPLOAD USING X++

-
Image
Requirement : Uploading a file in Sharepoint online using X++ and inside from Microsoft Dynamics 365 finance and operations. Prerequisites: The current user id of Microsoft Dynamics 365 Finance and operations should have proper rights and privileged in Sharepoint Online. Sample Code: In this scenario i am creating a text file in Microsoft Dynamics 365 finance and operations and then uploading its memory Stream in Sharepoint online using X++ . You can modify the X++ code in D365 finance and operations as per your need. class RunnableClassRun { /// /// Runs the class with the specified arguments. /// /// The specified arguments. public static void main(Args _args) { System.UriBuilder builder = new System.UriBuilder(“ https://XXXXXX.sharepoint.com&#8221 ;); str extId = xUserInfo::getExternalId(); Microsoft.Dynamics.AX.Framework.FileManagement.SharePointDocumentStorageProvider provider; Microsoft.Dynamics.AX.Framework.FileManagement.DocumentLocation documentLocation ...
Read more