Restore deleted Sales order from the void salesorder

-

class TECRestoreDeletedSOBatchCls extends RunBaseBatch

{

     // User Input fields


          DialogField     fieldSalesid;


     DialogField     fieldName;


     // Variables to store user input


  //   SalesTable   salesTable;


     Name salesID;

     // pack() and unpack() methods are used to load the last value from user


     // for our simple example we are not going to use them.



     public container pack()

     {

          return conNull();

     }


     public boolean unpack(container packedClass)

     {

          return true;

     }


     // Dialog method to capture runtime user inputs for customer details


     public Object dialog()


     {

          Dialog dialog = super();


          // Set a title for dialog


          dialog.caption( 'Restored deleted Sales order');


          // Add a new field to Dialog


          fieldSalesid = dialog.addField(extendedTypeStr(name), 'Sales order number'); //SalesIdDelete



          return dialog;


     }


     // Retrieve values from Dialog


     public boolean getFromDialog()

     {

          salesid = fieldSalesid.value();


          return super();

     }


     public void run()

     {

          

          SalesTableDelete    salesTableDelete;

          SalesLineDelete     salesLineDelete;

          SalesTable          salesTable;

          SalesLine           salesLine;

          Map                 Map = new Map(Types::Int64, Types::Record);

        

          SalesTableDelete = SalesTableDelete::find(salesID, true); // provide the sales order

       

          ttsbegin;

      

          switch (salesTableDelete.Cancelled)

          {

               case Voided::Voided:

                    {

                         salesTable  = conpeek(salesTableDelete.SalesTable, 1);

                         salesTable.insert();

                

                         while select forupdate salesLineDelete

                              where salesLineDelete.SalesId == salesTableDelete.SalesId

                         {

                              salesLine = conpeek(salesLineDelete.SalesLine, 1);

                              salesLine.insert();


                              // this code is needed if the refenrce invet transaction is missing on particular case

                              //  InventTransOriginSalesLine originSalesLine;

                              //{

                              //    select * from originSalesLine where

                              //            originSalesLine.InventTransOrigin == InventTransOrigin::findByInventTransId(salesLine.InventTransId).RecId;


                              //    if (!originSalesLine.InventTransOrigin)

                              //    {

                              //        originSalesLine.InventTransOrigin = InventTransOrigin::findByInventTransId(salesLine.InventTransId).RecId;

                              //        originSalesLine.SalesLineDataAreaId = salesLine.DataAreaId;

                              //        originSalesLine.SalesLineInventTransId = salesLine.InventTransId;

                              //        originSalesLine.doInsert();

                              //     }

                              //}


                              salesLineDelete.delete();

                         }


                         salesTableDelete.delete();

                    }

                    break;


               case Voided::linesVoided :


                while select forupdate salesLineDelete where salesLineDelete.SalesId == salesTableDelete.SalesId

                    {

                         salesLine = conpeek(salesLineDelete.SalesLine, 1);

                         salesLine.insert();

                   

                         Map.insert(salesLine.RecId, salesLine);

                   

                         salesLineDelete.delete();

                    }

                    salesTableDelete.delete();

                    break;

          }


          ttscommit;



     }


     public static void main(Args _args)

     {


          TECRestoreDeletedSOBatchCls tecRestoreDeletedSOBatch = new TECRestoreDeletedSOBatchCls();


          // Prompt the dialog, if user clicks OK it returns true


          if (tecRestoreDeletedSOBatch.prompt())

          {

               tecRestoreDeletedSOBatch.run();

          }

     }


}

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

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

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