Create custom Batch job without parameters in D365 X++

 For creating the batch job without parameters in D365 X++ via SysOpertion Framework, Follow the following steps;

1- First Create a menu action button in the project

2-Create an extension of menu and add menu button to the Menu.

3- Create a ABCBatchContract Contract class as shown below;

[DataContract,SysOperationContractProcessing(classStr(SysOperationAutomaticUIBuilder))]

/// <summary>

/// Create getter setter for query

/// </summary>

public class ABCBatchContract

{

    

}


4- Create ABCBatchController Controller Class as shown below;

/// <summary

/// Inventory Blocking batch controller class

/// </summary>

public  class ABCBatchController extends SysOperationServiceController

{

    /// <summary>

    /// Run the Service Opeeration class action

    /// </summary>

    protected void new()

    {

        super(classStr(ABCBatchService),methodStr(ABCBatchService, startProcess));

    }


    public static ABCBatchController newFromArgs(Args _args)

    {

        ABCBatchController  abcBatchController;


        // create a new instance of the controller

        abcBatchController = new ABCBatchController  ();


        abcBatchController.batchInfo().parmBatchExecute(true);


        // initialize from args

        // one of the things this will do is read the "parameters" property from the menu item

        abcBatchController.initializeFromArgs(_args);


        // return a new instance of this controller

        return abcBatchController;


    }


    public static ClassDescription description()

    {

        return "Blocking Description";

    }


    /// <summary>

    /// Main Method

    /// </summary>

    /// <param name = "args">Get records</param>

    public static void main(Args _args)

    {

  

       ABCBatchController abcController = new ABCBatchController();


        abcController = ABCBatchController::newFromArgs(_args);

        abcController.parmClassName(classStr(ABCBatchService));

        abcController.parmMethodName(methodStr(ABCBatchService, startProcess));

        abcController.parmExecutionMode(SysOperationExecutionMode::Synchronous);


        abcController.startOperation();


    }


}


5- Create a Service class ABCBatchService  from which your logic is executed as shown below;


/// <summary

/// Create a SysOperationFramework batch job

/// </summary>

public class ABCBatchService extends SysOperationServiceBase

{

    /// <summary>

    ///  Implement the logic to block the inventory on base of 3 months.

    /// </summary>

    /// <param name = "dataContract">ABCBatchContract</param>

    public void startProcess(ABCBatchContract dataContract)

    {

        

        InventDim inventDim;

        InventSum inventSum;

        date today = today();

        date preQuater = prevQtr(today);

        InventBatch inventBatch;


        str itemFilterFF = 'FF*';

        str itemFilterYN = 'YN*';


        // Get Records from table with available physical greater than zero.

        while select ItemId,AVAILPHYSICAL,INVENTDIMID from inventSum where inventSum.ItemId like itemFilterFF && inventSum.AVAILPHYSICAL > 0 || inventSum.ItemId like itemFilterYN && inventSum.AVAILPHYSICAL > 0

            join PRODDATE,expDate from inventBatch where inventSum.ItemId == inventBatch.ItemId && inventSum.InventBatchId == inventBatch.inventBatchId

        {

            // If expiration date exist then execute above logic else below logic.

            if (inventBatch.expDate)

            {

                if (inventBatch.expDate <= today)

                {

                    InventBlocking inventBlocking;

                    inventBlocking.initValue();



                    inventBlocking.ItemId = inventSum.ItemId;

                    inventBlocking.Qty = inventSum.AVAILPHYSICAL;

                    inventBlocking.BlockingType = InventBlockingType::Manual;

                    inventBlocking.InventDimId = inventSum.INVENTDIMID;

                    inventBlocking.Description =  "Inventory Blocking";


                    ttsbegin;

                    inventBlocking.insert();

                    ttscommit;


                    inventBlocking.clear();

                }


            }

            else

            {

                if (inventBatch.PRODDATE)

                {

                    if (inventBatch.PRODDATE <= preQuater)

                    {

                        InventBlocking inventBlocking;

                        inventBlocking.initValue();



                        inventBlocking.ItemId = inventSum.ItemId;

                        inventBlocking.Qty = inventSum.AVAILPHYSICAL;

                        inventBlocking.BlockingType = InventBlockingType::Manual;

                        inventBlocking.InventDimId = inventSum.INVENTDIMID;

                        inventBlocking.Description =  "Inventory Blocking";


                        ttsbegin;

                        inventBlocking.insert();

                        ttscommit;


                        inventBlocking.clear();

                    }

                }

            }


        }

        info("Inventory Blocking Succeeded");       

    }


}


6- Now build and sync your project.

7- Go to the front-end site and click on the menu action in which menu you have added. and your job form is displayed, then click on the OK button to execute the job.


If you have any confusion or problem, do let us know so we can slove the queries.


Thanks.

Comments

Post a Comment

Popular posts from this blog

Create custom workflow in D365 X++

Image
 For the creation of Custom Workflow in Dynamics 365 F&O, Kindly follow the following steps; 1. Create a custom Enum WorkflowStatus or you can use an existing one.   2. Create a new table EmployeeLeave as defined below and add the above Enum as a field and name it LeaveStatus . 3. Create a new form EmployeeLeaveForm by using the above table as a data source.   4. Create a new Display Menu Item EmployeeLeaveForm for the above form and add to any  Module by creating an extension of the Module Menu from the application Explorer. 5. Create a new Query EmployeeLeaveQuery  and add  EmployeeLeave as a data source.                 6. Create a new Workflow Category EmployeeLeaveCategory .   7. Create a new workflow type EmployeeLeaveWorkflowType .   • Category: Select the workflow category from the previous step • Query: Select the query created for the document table • Document menu item: Sel...
Read more

Convert amount from one currency to another currency using X++

  You can use the following X++ code snippet for currency amount conversion.     CurrencyExchangeHelper currencyExchangeHelper;     AmountMst amountMST;     CurrencyCode FromCurrency =  'PKR';     AmountCur amountCur = 5000;     currencyExchangeHelper = CurrencyExchangeHelper::newExchangeDate(Ledger::current(), systemDateGet());     amountMST =  currencyExchangeHelper.calculateCurrencyToCurrency(fromCurrency, SLDFabCostSheetsCalculation.Currency,amountCur,true);        info(strFmt("%1", amountMST));
Read more

How to Create Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 -- F&O Customization Part 2

Image
For Creating Extended Data Types (EDTs) in Finance and Operations of Dynamics 365 follow the following steps: Step # 1:        Right-click on the project to Add -> New Items as shown in the figure;     When you click the New Item ,  the new window is open as shown in the figure;     Select the Data Types from the Side Bar and click on the Add button as shown in the figure; Step # 2:          Now right click on the EDT and select the Properties as shown in the figure;               When you click the Properties button, the left panel is open, you can set the properties of EDT here,           mostly used properties are Label and Help Test. I have created four EDTs as shown in the figure;           You can check the EDTs in the Application Object Tree ( AOT ) as shown in the figure;          If ...
Read more