Parashuram_D365 F&O

Sometimes due to business need, we need to refresh Sandbox environment as per Production environment.  Here LCS play a important role to perform Sandbox DB refresh . A database refresh copy the transactional and financial reporting DB of production environment into sandbox environment. There are few important thing that we need to take care while performing the sandbox DB refresh. 1. After sandbox DB refresh, all user's disable except the admin user 2. In sandbox, as other user account disable and only admin user account is enabled only.     Except admin user no user are able to login UAT from their account 3. Admin user first login the sandbox instance from admin account and enable the other user     than only other user would be login sandbox client 4. If admin user forget their credential, they can update  the environment administrator.     This option is not recommendable but if there are no option to get admin credential we can upda...

             In this blog we'll see, how to consume external API in D365. To start this development, first of all I had configured postman to test API. Below are the high level postman configuration: Sample JSON: [    {     "ClientCode": "I182",     "ClientName": "AXXX Limited", "CustomerKey": "2121-ddf-Test-faffbdTest090"   },   {     "ClientCode": "U027",     "ClientName": "XXXs LLC", "CustomerKey": "2121-ddf-Test-faffbdTest090"     } ] To achieve above requirement, I have wrote below code: class ProjectSyncInboun {     public static void InboundProject()     {         ProjectSyncInbound::jsonRead(ProjectSyncInbound::ProcessAuthorization("API_URL","Authorization_Detail",             "User_Name","APIPassword"));   ...

  Creating batch job with parameter using SysOperation framework and add validation on paramete Today, we will create batch job with parameter and add validation on parameter using SysOperation framework. Here are the requirement and its development. Requirement: We wants to create a batch job with two parameter. If number of days’ parameter & SQL query haven’t values, batch job wouldn’t run and system throw an error message before executing the batch job.   To achieve the above requirement we have created three classes that are – Service, Contract and Controller class 1. Contract class: This class used for to create parameter and add validation on parameter. To add the validation on contract class; add implements keyword with contract class and override validate() method.   implements SysOperationValidatable      public boolean validate() {        // validation logic }   [DataCont...

  Sometime in PROD, user expect report without waiting report development/deployment or developer wants to execute SQL script to test some result. As we know, in PROD/Sandbox environment direct SQL script execution is not possible. Will understand this development with below example: 1.      Lets assume end user wants a summery report which contains below details: Sales order number, Customer number, Item, Line amount(SUM of line amount which are group on SalesId) 2.      Few of the development script not working as expected or Developer feels there are some data issue and due to that their development not working and immediately he/she wants to test his/her development script  Both of the scenario’s achieve using today topic 😊  To achieve this, we have developed a form: We have added two tabs one for SQL script and second tab for maintain log for historical data SQL Query Tab: Filename:  After executing th...