How to approve and change status of work flow for purchase order

-

 Today we have a requirement that create a job and pass the purchase order number. They approve and confirm the po also change the workflow status.


So to done this requirement we have created one helper class and a job 

1) Create a helper class :- 


class AVAPurchaseOrderHelperClass

{

    //For workflow  enabled Po's, changing the status from draft to approved

    public static void updatePOStatusToApproved(PurchTable _purchTable)

    {

        PurchTable purchTableUPD;

              

        ttsbegin;

        select firstonly forupdate purchTableUPD

            where purchTableUPD.PurchId == _purchTable.PurchId;


        purchTableUPD.AVAPOWorkflowApprovedChk = NoYes::No;

        purchTableUPD.autoApproveChangeRequest(true);

        ttscommit;

    

    }


    //For workflow  enabled Po's, changing the status from approved to draft to update autoclose field in the PO line

    public static void updatePOStatusToDraft(PurchTable _purchTable)

    {

        ttsbegin;

        _purchTable.selectForUpdate(true);

        _purchTable.AVAPOWorkflowApprovedChk = NoYes::Yes;

        VersioningPurchaseOrder::newPurchaseOrder(_purchTable).createChangeRequest();

        ttscommit;

    }


    public static Void updatePOAutoClose(PurchLine _purchLine)

    {

        ttsbegin;

        purchLine purchLineUPD = PurchLine::findRecId(_purchLine.RecId,true);

        purchLineUPD.AVAAutoClose = NoYes::Yes;

        purchLineUPD.doUpdate();

        ttscommit;

    }


    public static void confirmPO(PurchTable _purchTable)

    {

        ttsbegin;

        PurchFormLetter purchFormLetter;

        PurchFormLetter purchFormLetterPack;

        purchFormLetter = PurchFormLetter::construct(DocumentStatus::PurchaseOrder);

        purchFormLetter.update(_purchTable, _purchTable.PurchId,

                                    systemDateGet(),

                                    PurchUpdate::All,

                                    AccountOrder::None,

                                    NoYes::No,

                                    NoYes::no);

        ttscommit;

    }


}

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


Step 2 :- Create a job to test 


class AVAApprovedPOJob

{

    /// <summary>

    /// Runs the class with the specified arguments.

    /// </summary>

    /// <param name = "_args">The specified arguments.</param>

    public static void main(Args _args)

    {

        PurchTable      purchTable = purchTable::find('WG-0072161');

        AVAPurchaseOrderHelperClass::updatePOStatusToApproved(purchTable);

        Info(strFmt("%1",purchTable.DocumentStatus));

    }


}



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

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