java script Code:

function Totalcurrentyearamount(executionContext) {

    var formContext = executionContext.getFormContext();

    var totalytd = 0; // Initialize total YTD to 0

    const currentDate = new Date(); // Get the current date

    const currentYear = currentDate.getFullYear(); // Get the current year

    var apiContext = (typeof Xrm !== “undefined”) ? Xrm : parent.Xrm;

   // Retrieve all records from vijay_income entity

    apiContext.WebApi.retrieveMultipleRecords(“vijay_income”, “?$select=vijay_amount,vijay_year”).then(

        function success(results) {

            console.log(results);

        // Loop through the retrieved records

            for (var i = 0; i < results.entities.length; i++) {

                var result = results.entities[i];

                // Convert vijay_amount to an integer

                var vijay_amount = parseInt(result[“vijay_amount”], 10); // Ensure the amount is treated as an integer

                var vijay_year = parseInt(result[“vijay_year”],10); // Year field

              // Ensure vijay_year exists and matches the current year

                if (  vijay_year == currentYear) {

                    // Add the amount to total YTD if year matches current year

                    totalytd += vijay_amount;

                  }

            }

          // Log the total YTD for debugging purposes

          console.log(“Total YTD: ” + totalytd);

         // Set the total YTD value in the ‘vijay_ytd’ field on the form

            formContext.getAttribute(“vijay_ytd”).setValue(totalytd >0 ? totalytd.toString() : null);

        },

        function (error) {

            console.log(“Error in retrieveMultipleRecords: ” + error.message);

        }

    );

}

6. Then add the web resource in tour main form in form libraries and the function name in event handlers form ON – load.

7.Save and publish all customizations