86) COC Invent table

-

 //// <summary>

/// The <c>AvaInventTransferTable_Extension</c> contains the TransMountain eventing logic for the <c>InventtransferTable</c> table.

/// </summary>

[ExtensionOf(tableStr(InventTransferTable))]

final class AvaInventTransferTable_Extension

{


    /// <summary>

    /// diplay method to get the tracking ID of Transfer order.

    /// FDD :- EXT_004_TrackItemShipment

    /// </summary>

    [sysClientCacheDataMethod(true)]

    display public static InventTransferTrackingId avaTrackingID(InventTransferTable _this)

    {

        InventTransferJour  transferJour;


        select firstonly TrackingId from  transferJour

            order by TrackingId desc

            where transferJour.TransferId == _this.TransferId;

            

        return transferJour.TrackingId;


    }


    /// <summary>

    /// Fill the values of work order.

    /// FDD : - EXT_004_TrackItemShipment

    /// </summary>


    public void avaInitFromworkOrderTable(EntAssetWorkOrderLine  _entAssetWorkOrderLine)

    {

        this.InventLocationIdFrom = EntAssetParameters::find().AvaDefaultFromWarehouse;

        this.modifiedField(fieldNum(InventTransferTable, InventLocationIdFrom));

        this.InventLocationIdTo   = _entAssetWorkOrderLine.functionalLocation().InventLocationId;

        this.modifiedField(fieldNum(InventTransferTable, InventLocationIdTo));

        this.AvaWorkOrderTable    = _entAssetWorkOrderLine.workOrderTable().RecId;

        this.FromContactPerson    = HcmWorker::userId2Worker(curUserId());

    }


    /// <summary>

    /// Validate the work id is exist or not  in transfer order form lookup.

    /// FDD : - EXT_004_TrackItemShipment

    /// </summary>

    public boolean avaValidateWorkOrderId()

    {

        boolean                         ret = true;

        

        if(EntAssetWorkOrderTable::findRecId(this.AvaWorkOrderTable).lifecycleState().AvaEnableTransferOrder)

        {

            ret = checkFailed(strFmt("@AvaTransMountain:AVAWorkOrderIDNotFound_Label", EntAssetWorkOrderTable::findRecId(this.AvaWorkOrderTable).WorkOrderId));

           

        }

        return ret;

    }


    public boolean validateField(FieldId _fieldIdToCheck)

    {

        boolean ret;

        

        ret = next validateField(_fieldIdToCheck);

        

        if (ret && _fieldIdToCHeck == fieldNum(InventTransferTable, AvaWorkOrderTable) && this.AvaWorkOrderTable)

        {

            ret = ret && this.avaValidateWorkOrderId();

        }

        return ret;

    }


    /// <summary>

    /// Will update the work order status on the basis of transfer order

    /// FDD : - EXT_004_TrackItemShipment

    /// </summary>

    public void insert()

    {

        next insert();


        InventTransferTable::avaUpdateWorkOrderStatus(this);

    }


    /// <summary>

    /// Will update the work order status on the basis of transfer order

    /// FDD : - EXT_004_TrackItemShipment

    /// </summary>

    public void update()

    {


        next update();


        InventTransferTable::avaUpdateWorkOrderStatus(this);

        //Bug_8993_FDD:EXT_004_TrackItemShipment_04.08.2020_Vinay_Sn

        InventTransferTable::avaUpdateToTransferContact(this);

        //Bug_8993_FDD:EXT_004_TrackItemShipment_04.08.2020_Vinay_En


        

    }


    /// <summary>

    /// Will update the work order status on the basis of transfer order

    /// FDD : - EXT_004_TrackItemShipment

    /// </summary>

    public void delete()

    {

        next delete();


        InventTransferTable::avaUpdateWorkOrderStatus(this);

    }


    /// <summary>

    /// Will update the work order status on the basis of transfer order 

    /// FDD : - EXT_004_TrackItemShipment

    /// </summary>

    public static void avaUpdateWorkOrderStatus(InventTransferTable _invenTransferTable)

    {

        inventTransferTable     inventTransferTable;

        InventTransferStatus    minInventTransferStatus;

        AvaWorkOrderTransferStatus transferStatus;

        

        select AvaWorkOrderTable, minof(TransferStatus) from inventTransferTable

            group by AvaWorkOrderTable

            where inventTransferTable.AvaWorkOrderTable  == _invenTransferTable.AvaWorkOrderTable;


        // Bug_8992_FDD:EXT_004_TrackItemShipment_04.08.2020_VinayT_So

        //if (!inventTransferTable.AvaWorkOrderTable)

        // Bug_8992_FDD:EXT_004_TrackItemShipment_04.08.2020_VinayT_Eo


        // Bug_8992_FDD:EXT_004_TrackItemShipment_04.08.2020_VinayT_Sn

        if (inventTransferTable.AvaWorkOrderTable)

        // Bug_8992_FDD:EXT_004_TrackItemShipment_04.08.2020_VinayT_En

        {

            transferstatus = InventTransferTable::AvaGetorkOrderTransferStatusFromTransferStatus(inventTransferTable.TransferStatus);

        }

        else

        {

            transferStatus = AvaWorkOrderTransferStatus::Blank;

        }


        ttsbegin;


        EntAssetWorkOrderTable workOrderTable = EntAssetWorkOrderTable::findRecId(_invenTransferTable.AvaWorkOrderTable, true);

       

        if (workOrderTable)

        {

            workOrderTable.AvaTransferStatus = transferStatus;

            workOrderTable.doUpdate();

        }


        ttscommit;

    }


    public static AvaWorkOrderTransferStatus avaGetorkOrderTransferStatusFromTransferStatus(InventTransferStatus _inventTransferStatus)

    {

        switch(_inventTransferStatus)

        {

            case InventTransferStatus::Created:

                return AvaWorkOrderTransferStatus::Pending;

            case InventTransferStatus::Shipped:

                return AvaWorkOrderTransferStatus::Shipped;

            case InventTransferStatus::Received:

                return AvaWorkOrderTransferStatus::Received;

            default:

                return AvaWorkOrderTransferStatus::Blank;

        }

    }


    public EntAssetWorkOrderTable avaWorkOrderTable(boolean _forUpdate = false)

    {

        EntAssetWorkOrderTable workOrderTableLocal;

        if (this.AvaWorkOrderTable)

        {

            workOrderTableLocal = EntAssetWorkOrderTable::findRecId(this.AvaWorkOrderTable, _forUpdate);

        }

        return workOrderTableLocal;

    }


    /// <summary>

    /// Update the To Transfer contact when the transfer order status is in received status.

    /// FDD :- EXT_004_TrackItemShipment.

    /// Bug_8993_FDD:EXT_004_TrackItemShipment_04.08.2020_Vinay

    /// </summary>

    public static void avaUpdateToTransferContact(InventTransferTable   _this)

    {

        InventTransferTable inventTransferTable;


        ttsbegin;

        if(_this.Transferstatus ==  InventTransferStatus::Received)

        {

            select forupdate ToContactPerson from inventTransferTable

                where inventTransferTable.TransferId  == _this.TransferId;


            inventTransferTable.ToContactPerson = HcmWorker::userId2Worker(curUserId());

            inventTransferTable.doupdate();

            

        }

        ttscommit;

        

       

    }


}

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