Category Archives: Dynamics 365
PSA Quick Tip: How to Give Team Members Access to Only do Time Entries and Expense Entries and not Expose Other Entities in PSA v3.X
Dynamics 365 Project Service Automation helps companies to have control over the projects that they undertake. It is the main reason why a lot of companies love this particular ERP solution. Companies can complete the project within the timeframe and the budget that is allocated. Estimating the project budget and planning resources becomes a lot easy. Communication between employees in the company improves substantially. Microsoft Dynamics 365 for Project Service Automation equips the project managers with the essential tools to make them efficient. It helps companies to become organized and to become successful. Here are some quick tips on how you can give your colleagues access that is necessary to do expense and time entries without exposing them to other available entities on the system. Dynamics 365 Project Service Automation is a software application that companies need to buy and use if they want to have full control of a project. Organizations can use this application to manage, track, and deliver project-based services on time. Creating work schedules and quotations utilizing this system is secure. You can manage and assign resources with ease when you use this software. Mastering how this system works is quite essential if you desire that your projects become successful. You might encounter so many unique problems when you are using this particular system. Here are some probable solutions that will help you to solve these problems. Problem Definition: We sometimes have a few team members who only need to do the time entries and expense entries. They do not need any exposure to other entities. How do we make it possible via the OOB (Out of the box) security roles in PSA V3.X. Solution: From the security–>Users–> select the user–>Manage Role and Only keep “Project Resource” Role. 2. Go to Security–>Security Roles–>Open the security Role “Project Resource” –> change the following 2 parameters read/write access as shown below in the image. 3. Log off and log in again and you are set 🙂
Share Story :
First Canvas Power App: Learn Few Easy and Important Commands
These days there are so many companies that are developing software applications to help businesses manage the projects. But, nothing comes close to dynamics 365 project service automation. It is unique and is one software that every business should have if they want to manage projects and help them to become successful. Companies can track as well as manage projects well when they use this particular software.astering this software is essential if you want to use this application efficiently. PowerApps is one service that Microsoft offers, and developers can use it to build apps as per the requirement of the client. As my thoughts build to initiate writing this blog, similar was the feeling when I first thought about exploring Power Apps. The expression was, “What exactly is Power Apps?”. When the world is talking about it, it brings me more curiosity to understand what is so powerful about it. Let’s first commence with understanding what exactly is Power Apps: PowerApps is an initiative by Microsoft that allows developers and nontechnical users to build mobile applications from selectable templates. The objective of PowerApps is to enable business users to build new capabilities via apps, without requiring that they have code expertise. Types of Power Apps: Model driven apps: These types of apps directly publish the entity on the mobile/ tablet. These apps can be used from Microsoft Dynamics 365 App from mobile. They are very easy to make and can be ready within 15mins of time. Canvas apps: These apps are blank canvas given to the developers with a free hand to design the app in the way they want. In this blog we shall focus more on how to make a Canvas app. Follow the steps below to make a PowerApps. Step 1: Login to www.portal.office.com Step 2: Click on PowerApps icon as shown in the image below: This will open a new browser tab where we need to select what kind of app do we need to make. Step 3: Click on Canvas app from blank, which opens a pop up. Please name your app and select whether the app is for Phone or for Tablet as shown below and click on Create button. This opens the Canvas app editor as shown below: To take this blog forward, I will use an app that is created by me and explain a few commands used by me and how was the design done in that app. The app captures the Grievances of people in office. There are 5 screens created by me and they are: list_Grievances Screen: This list all the grievances in the system. 2. frm_GrievanceRecord Screen: This opens a grievance record. 3. Frm_NewGrievance Screen: This screen is used to capture a new grievance. 4. Frm_CameraScreen : This is used to capture the image of the grievance using camera control. 5. SuccessScrn: This is used to display the success on the screen. Technical dive Let’s take a dive in each screen and get into understanding of functionalities developed on each screen: List_grievances: a. New Grievance button: This button will navigate to a frm_NewGrievance Record to capture new grievance from the employee. The code written behind that is:………………………………………………………………………………………………………………Navigate(frm_NewGrievance,ScreenTransition.Fade ); …………………………………………………………………………………………………………………….b. To display the list of Grievance I have inserted a List Screen as shown in the image below: c. To display the list of Grievance, we need to add a Data Source. How to add a data source is shown below: There are approximately more than 250 Data sources to which Power apps can connect. Select the data source you wish to connect. In my case, I will connect to Dynamics 365 Data Source. It will ask you to choose your entity and then you can click on connect. Your Data Source “Grievances” will start appearing in Items drop down of Property Window. Post that we can align the attributes that we need to see on the list view: To Display Employee Full Name, below is the code that I wrote: ………………………………………………………………….. ThisItem.’Employee Full Name’ ………………………………………………………………… To get the department value, which is a lookup to another entity below is the code that was written: …………………………………………………………………. LookUp(Departments,new_departmentid=ThisItem.Department, new_name) …………………………………………………………………. To display the image from the SharePoint Library, below is the code: LookUp(GrievanceLibrary, Title = TitleGrievance.Text, Image) Where GrievanceLibrary is the Sharepoint Datasource added in Powerapp and Title and image are the fields created in SharePoint. To open the Grievance record on frm_Grievance Record, write the below code: Navigate(frm_GrievanceRecord,ScreenTransition.Fade,glryGrievances.Selected) frm_NewGrievanceRecord: To store the new grievance record, we used the Form Screen. On the update button, write the below code: Patch( Grievances, Defaults(Grievances), { new_employeefullname: DataCardValue3.Text, new_description: DataCardValue15.Text, _new_departmentl_value: DataCardValue10.Selected.new_departmentid, _new_grievancetypel_value: DataCardValue6.Selected.new_grievancetypeid, new_signature: PenInput4.Image } ); Patch( GrievanceLibrary, Defaults(GrievanceLibrary), { Title: DataCardValue3.Text, Image: First(Collection1).Url } ); UpdateContext({resettext: !resettext}); UpdateContext({resetcombobox: !resetcombobox}); Navigate(SuccessScrn,ScreenTransition.Fade); frm_CameraScreen Insert a Camera Media Control on the form as shown in the below screen shot. Insert an image control on the form below the Camera Media control. Capture button code: ClearCollect(Collection1, Camera1.Photo) Collection 1 s described above is the SharePoint collection object which needs to be cleared and then referred with the new Photo from the Camera Control, which in our case is Camera1. Confirm button code: Confirm Button will only Navigate it to New Grievance form and the code is ass per below: Navigate(frm_NewGrievance) To summarise: We learned how to create a Canvas Power app. Different controls that can be used. How to store image on Sharepoint in a Power app. Again I am sharing the code for storing the image on Sharepoint herewith: Patch( GrievanceLibrary, Defaults(GrievanceLibrary), { Title: DataCardValue3.Text, Image: First(Collection1).Url } ); To explain the above code, GrievanceLibrary is the SharePoint site of which Data Source is added. Title: This is a field in the Sharepoint library that will store the name of the Grievance. The data type in Sharepoint for Title is Single line Text Image: This will store … Continue reading First Canvas Power App: Learn Few Easy and Important Commands
Share Story :
Enable Flow button on D365 Ribbon
This is a pretty simple tweak to either show or hide the Flow button on the entity Forms’ Ribbon. Flow Button Not Visible System Settings Navigate to Settings > Administration. Go to System Settings In System Settings, under Customization tab, look for Enable Microsoft Flow option. You’ll be asked for permission Now, this is turned on Flow Button Visible Now, once you have enabled this setting, you’ll be able to see the Flow button on the View and Form ribbons across Dynamics 365 CE That was quick!!
Share Story :
Powerful Tips to Solve your Infinite Loop Issue
Dynamics 365 for Customer Service is the right ERP software to use if you desire to see the customer service improvement in your company. When businesses provide excellent customer support, clients not only have the best experiences, but they also stay loyal to a business. Of course, there are so many ERP solutions out there in the market. Dynamics 365 solutions are, however, the best in the world as many companies tried and tested this product and love the way it helps them to become a lot more organized. Since Microsoft owns this product, they do a lot of research to enhance this particular product. One problem people do not know how to fix is the infinite loop issue. Here are some fantastic tips to help you to surpass the problem. While using fetch xml to retrieve records more than 5000 records and if you have multiple entities involve in it. There are chances that you will get into an infinite loop even if you have less than 5000 records. Description: We have noticed that after 9.0 if you are using the old method to retrieve more that 5000 records using the fetch xml in the script it is possible that you will get the into infilter loop. This happens due to the internal multiplication of table which gives fist and last records id same in fetch XML. You need to make sure that include the header as shown in the below screen Need to make sure that you have below check condition before calling the fetch next record collection if (data[“@Microsoft.Dynamics.CRM.fetchxmlpagingcookie”] != null && data[“@Microsoft.Dynamics.CRM.morerecords”] != null && data[“@Microsoft.Dynamics.CRM.morerecords”]==true) { It has more than 1 record true only than call the next request Conclusion Hope this helps you to solve your infinite loop issue.
Share Story :
How to Deploy Dynamics 365 Operations Environment using Lifecycle Services – Part 2?
There are so many ERP or Enterprise Resourcing Planning Software in the market today. You need to pick the best one out of all the available options if you want your company to be successful in every stream of the operations. Dynamics 365 for Finance and Operations is one of the best ERP software that you can find. Companies do benefit a lot when they deploy Dynamics 365 Operations Environment. When employees put in enough time in learning how to use the software, things can become easy for them. It will help your staff to become a lot efficient in their duties. Their performance is also going to increase drastically over a period. Companies desire to unify both the operations and finance functions in their organization to make better and informed decisions quickly. Of course, there are so many options that are out there in the market. But, Microsoft Dynamics 365 for Finance and Operations is one software that you need to pick if you want to streamline your business. Businesses will get to enjoy so many benefits when they select this particular option over all other options. Many people do not know how to set up this software, nor do they know how to navigate through the application. Don’t worry — that is fine. In this article, we will take look at the post configuration setting for Finance and Operations environment. You can login to your LCS environment and check whether D365 Operations environment deployed or not. 2. Once you click on the deployed environment you’ll see the screen that shows the network configuration, storage details, environment details, service account use to deploy the environment and administrator details. We are not going into all this details, we’ll click on the login to the environment to configure the setting for AX development. 3. Once we click on the Log on to environment we’ll see the following D365 finance and operation environment screen. For now only the Admin who deployed the environment is able to access the environment so we need to add some user to the environment. Click here and scroll down to module section. 4. Once we click on the Users we can see list of the users with role, Click on the import users link, We can then see the list of users in the tenant we have if we are D365 tenant then we’ll have all the user from the organisation. 5. From the list of user we can add the users and assign the role for the user for the D365 development. We can also set the configuration for the different tools that Microsoft offer as a part of the development like Power BI integration. So, in this blog we see how to set up the post configuration setting for the LCS and how to add users to environment for D365 development.
Share Story :
Shift/Statement Posting Error in Microsoft Dynamics 365 For Retail
Microsoft Dynamics 365 for Retail Management Solution is an end to end or complete retail solution that every business need to have. It provides unified commerce solutions to retailers in all the channels, such as mobility, intelligence, sales, and productivity. Retailers can do a wide range of activities using this particular software. This solution helps customers to have an immersive experience. Retailers achieve a lot when they use Microsoft dynamics 365 for retail as people can do most of the things on the cloud. It increases the efficiency of the workers that are using this software. It is a SaaS solution that Microsoft is hosting. It is one of those solutions that retailers and their staff will love using. In this blog I am going to demonstrate how to deal with errors generated during statement posting. At times while you are posting a shift/statement, you may run into number of different errors. You may need to resolve them on your own. However, sometimes the error occurs because of a bug as shown in this article. It is asking you to run a validate store transactions job. Run the job, however the error message may not go away. If this error message does not go away than it’s more like a bug than an error. You need to contact Microsoft and raise a ticket . They can resolve this error in a day or two. As you can see here shift 2637 is still unposted i.e. no right tick in the posted column next to it. It won’t let you post it even if you create a new statement and try to post it. The reason could be that the statement containing it is not posted yet. Go to statements and find the unposted statement and try to post it. Issue should be resolved. Hope this helps!
Share Story :
Configuring Department-Wise URL in D365 CE
Customer Service is one of the essential segments of any business if they want to become successful. Every single thing about it does matter. Dynamics 365 for customer service is one of the tools that a business can use to improve brand loyalty and also to improvise the value that the companies offer to their clients. Any company that wants to improve in this segment needs to work on this thing. D365 Customer Service will set your company apart from the rest of the firms out there. This software will help you stay ahead of the customer’s expectations and to resolve their concerns a lot faster. Customers can reach out to the company a lot quicker and get resolutions for the problems they are facing at a much faster pace. Microsoft Dynamics 365 CE streamlines the way your employees communicate with customers and enhances their ability to collaborate. Problem Statement Clients implement D365 CE for all departments also need home/landing/default page for each department. This blog will help you to configure default URI for each department in D365 CE implementation for Company. Configuration Steps 1. Open Dynamics 365 Sales app 2. Navigate to “My Apps” in Settings group 3. Open Manage Roles Click on ellipses(…) and pop-up open, click on Manager Role 4. Setup App URL Enter URL Suffix e.g. SL and automatically URL is generated. 5. Setup Roles Roles are assigned to URL, Users with specific roles can only access App. 6. Copy URL and click Save button also share with Users for opening. Conclusion After following above configuration steps, we can share App URL with Sales Department similarly we can configure for Customer Service, Project Service, Field Service or any custom App share with the respective department. Hope this blog helps you to configure Department-wise or based on App for a group of people.
Share Story :
Prevent Contact Creation in D365 on Tracking Emails from New recipients
Typically, when you track Email/Appoint records from Outlook, unknown senders are created as Contacts in Dynamics 365? A new Email from unknown recipient. And if you track this Email using D365 App For Outlook, a new Contact is created in D365 without you being notified about it. And the Email from the Saved Contact in D365 appears like this Now, this could be unwanted. And there’s a simple way to turn this off! Disable Contact/Lead creation This setting is controlled from your Personal Settings. Under Email tab, look for the option that let’s you create Contacts/Leads for tracked Unknown Recipients. Once you un-check the same, when you track the Email/Appointment with unknown recipients, new Contacts will not be created. And you could identify this by simply going into Emails and seeing that the Email address appears rather than a Contact. Hope this helps.
Share Story :
Setting Output Parameter Value Using the Action
Dynamics 365 for customer service assists businesses to provide efficient and excellent customer service to improve customer service in a team. When it comes to business, every interaction that you get from your customer does matter a lot. Maximizing brand loyalty is only possible when customers get their problems or issues resolved quickly. Companies need to invest in Dynamics 365 solutions if they desire to provide the best customer service to their existing and prospective customers. It has some of the best features that can enhance your business operations. And the best part, it is quite economical than all other solutions that you now find in the market. There are so many resources that are available to make things easy for those who install and use it. We had a requirement where need to open the newly created record. Here we were using an action to create the record. Description: We had a requirement on button click contact will be created and once the record is created we need to open that record as well. Opening of the record is dependent on the user if he wants open or not. we have created a custom button and call the action which perform the operation of creation of the record. this record was created inside the action Below action was created and called on the button. 2. Output parameter was defined for the contact record that has been created inside the action 3. Once the contact record is created we set newly created contact guide as an output parameter. 4. Once that is done we got the contact id as a parameter and open it using the open form request in CRM Conclusion Hope this helps while setting output parameter value using the action.
Share Story :
Multiple Production Tenant in Dynamics 365 Business Central
Problem Statement: I have a requirement where the contents of the General Journals are to export to Excel and also can create new entries by importing the same Excel file as well. A major troublemaker is the dimensions as only Dimensions 1&2 ate stored in tables and can be validated easily but 3-8 are set at run-time through variables on the page. In this blog, I’ll be attempting to resolve how to automatically apply dimensions from 3-8 using the code. Pre-requisites: VS Code AL Language Extension Functional knowledge of Dimensions Microsoft Dynamics NAV / Business Central Solution: 1. Understanding how dimensions work technically: Any dimensions that are inserted in an entry in the system are validated to be stored in the Dimension Set Entries table. Dimension Set Entries table of which Dimension Set ID is set on the Table. This Dimension Set Entry ID is stored on the entries to be used as a reference. For instance, if we want to Apply Dimensions to General Journal Entries, the Dimension Set Entries ID is stored on General Journal Lines Table. Dimension Set ID on General Journals Out of 8 total dimensions, 2 dimensions are stored on the table. These 2 dimensions are also known as Global Dimensions. 2. Hack into Business Central: When importing, the entry either consists of a Dimension Set ID. If the Dimension Set ID is set to 0 which means no Dimension is applied yet. To apply the dimension to the entry using the code, we can use the standard available code ValidateShortcutDimCode(Dimension_No, Dimension_Value); Dimension_No: The position of the Dimension. Dimension_Value: Dimension Value that is to be applied. For Example:Rec_GenJnl.ValidateShortcutDimCode(3, SD3); When Exporting the Dimension into an Excel Format, you can use the Dimension Set ID present on the Entry to lookup into Dimension Set Entries Table. To Export the Dimensions using the code, you can use the following code: Clear(Rec_DimensionSetEntry); Rec_DimensionSetEntry.SetRange(“Dimension Set ID”, Rec_GenJnl.“Dimension Set ID”); Rec_DimensionSetEntry.SetRange(“Dimension Code”, Rec_GLSetup.“Shortcut Dimension 3 Code”); IF Rec_DimensionSetEntry.FindFirst() then MESSAGE(Format(Rec_DimensionSetEntry.“Dimension Value Code”)); Output: After Importing from Excel: After Exporting to Excel: Conclusion: Thus, using standard code present in Business Central, we can Import dimension details from other sources such as Excel. I also learned about the Dimension Set Entry table and how this is used to store the data on the Entry table using Dimension Set ID. Overall this is a big step where I learned how to import dimensions which are more than the 2 Global Dimension. Thanks for taking a keen interest in reading my blog.