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.

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.

Creating a pro forma invoice on dynamics 365 for finance and operations is a pretty straightforward task. A pro forma invoice is a crucial financial document that people use in businesses. In a nutshell, a pro forma invoice is more or less like an estimate that companies share with their client before sending them the actual invoice. The actual amounts can change if there is a difference in the quantity of material as well as the labor before preparing the final bill. Many people struggle to locate, view, or to print this document on dynamics 365 as it can be confusing. In this article I am going to demonstrate how to view/print  pro-forma invoice. A pro forma invoice is an invoice that is prepared as an estimate of the actual invoice amounts before the invoice is posted. You can print a pro forma invoice either for a customer invoice for a sales order or for a free text invoice. Step 1: Configure Print management from  Account receivable>Setup>Forms   Step 2: Right click on Customer invoice and click New Step 3: Go to All sales orders, Select an order which is in Open state.     Step 4: Go to Invoice tab and click on Pro forma Invoice     Step 5: In Quantity select All and in Print options enable Print Invoice     Step 6: You may click on Export to save the document or print it   Hope this helps!

So, since adoption of Unified Interface is growing, people are asking – “What happened to the Ribbon icons?”. Well, a simple answer to this is tweaking the implementation a little. Typically, you have custom icons on your classic Web UI that look like this – But the same looks like a puzzle piece in the Unified Interface – So, here’s what you need to do. Icons on the Unified Interface take SVG format. You’ll need to take you existing PNG Web Resources   Creating SVG Icons Like most online services or applications, you can easily convert images to SVG. In this example, I’m using this online tool – https://www.online-convert.com/ Or you can try this too which I found quite a few people recommended – https://www.syncfusion.com/downloads/metrostudio For this example, I used https://convertio.co/png-svg/ And I got my converted SVG document downloaded. Now, create a new Web Resource in SVG and Upload the same. Ribbon Workbench Once your Web Resource for the SVG format is set, going back to your Ribbon Workbench customization work space, go to the Button where you wan to update the icon and select the SVG Web Resource under Modern Image as shown below Publish Changes and See Once your customization are published, you can simply refresh and check that your image has been updated Note: An online converted might not give you an accurate image. However, it is best recommended to create SVGs on an app. I’ve heard recommendations about https://www.syncfusion.com/downloads/metrostudio Hope this helps!

Problem Definition: Post upgrading to V3 I faced issues while importing the time entries from my Resource bookings. This was not the case with V2. In V2 when I went to Import Time Entries from Resource Bookings, it used to pick up all the time entries that were in Active State. Resolution: The resolution to this was simple, but, little tricky. Below are the steps to be followed to get the issue resolved. Step 1: Go to the D365 – Custom App as shown in the below image. This will take you to the classic interface of D365 CRM as shown below. Step 2: Navigate to Settings à Customizations Step 3: Click on Customize the System This will open a screen as shown below. Step 4: Navigate to Entities- Bookable Resource Bookings – Views and open the view named Resource Bookings for Time Entries Import Step 5: Click on Edit Filter Criteria and add a condition Status  – Equals  –  Active These conditions ensure that only Active bookings are to be selected. Then click on OK and Save and Close. Finally, click on Publish All Customizations. Now when you try to import the time entries from Resource booking it will import only the Active time entries and leave behind the canceled time entries. This blog reflects my personal findings and based solely on my experience of using PSA for the last 3+ years. For those who are looking for a platform that can track and manage the entire procedures of sales and project management, I would highly recommend them to try Microsoft dynamics 365 for project service automation.

If you want to set the alternate key to detecting duplicate record based on lookup it was not earlier. If you want to have duplicated detection based on you would not be able to that you have to write a plugin to get that result. Description: You can now achieve a duplicate detection rule by defining the lookup as an alternate key. You can create an alternate key by following the below steps To define the alternate keys, go to Go to Settings> Customizations Choose Customize the System–>Components ->Entities –> Entity–>Keys. Choose New. 3. On the form, fill in the required fields (Display Name and Name) and then choose and add the fields to the key. Save the key. In the example shown here, we used the ParentId field in the alternate key definition. Conclusion Hope this helps while defining the alternate key with lookup/entity reference

Introduction Sometime there is requirement where we need to set a null value based on certain condition. We usually use script to set the null value this can be achieved using the workflow. Description: To set the null value of you need to create a new workflow. Follow the below steps. Go to setting —> Process 2. Create new work flow 3. Set clear value for field which is you want to set the null value as shown as below. 4. Set the value and save the work flow. Conclusion Hope this helps while setting null value using the flow.

There is good news for people who were using Dynamics 365 Project Service Automation (PSA) with the latest update. Microsoft allows it’s users to make adjustments to time entry using the plain journal entry in the past. For example, if a user wants to adjust the time entry from one to three hours, they have to make a new journal entry for the three hours. But, the only problem is that you cannot track it against a particular time entry. Now, if you are using PSA V3.7, you can make the correction or adjustments on the existing time entries with ease. Here are the steps you need to follow: Problem definition: With the previous releases, PSA could allow adjustment of Time Entry hours via mere plain Journal entries. That means, if we need to adjust a couple of hours or adjust a time entry worth 4 hours, we needed to make a 4 hours journal entry, which could not be tracked against a Time entry. Problem Solution: With PSA V3.7 there is a Journal correction for Time Entries which can be done against a Time Entry done. How do we do it is shown in the below steps: Suppose we a do a Time entry of 1 hours for a Project and Submit it for approval as shown in the below screen shot. 2. Approve the same via Time Entries for approvals. 3. As soon as the time entries are approved, they get converted to Actuals. This can be validated by going to Project Contract – Select the appropriate Contract – Actuals. You will see there are 2 records that get created: 1.Cost 2.Unbilled Sales. 4. In order to get the same adjusted via Journals, go to Journal Entries, SalesàJournals and click on +New 5. Write the Description and select the Journal Type Equals “Time Correction” and Save the record. 6. Click on Browsers back button, Open the Record from Active Journal view and click on Time Entry Corrections Tab. 7.Fill in the fields: Project Project Task Time Entry Date Bookable Resource Resource Role 8. From the below grid select the Time Entry for which the correction is needed, by clicking on the Add Existing Time Entry and then select the time entry from the quick create form that opens and click on Add. 9. Post Step 7 and Step 8 is done, click on Preview Button from the Ribbon control as highlighted in the screen shot below. 10. It will highlight the Journal Lines Tab and show you the Journal Entries with negative values of the value of the time entry and there will be 4 records that can be seen. 2 with a positive value of the time entry and 2 with negative that is the Adjustment value. This is how we can do the adjustment of the time entry which indirectly creates a Journal entry against the time entry done. This blog reflects my personal findings and based solely on my experience of using PSA for last 3+ years. For those who are looking for a platform that can track and manage the entire procedures of sales and project managements, I would highly recommend them to try Microsoft dynamics 365 for project service automation.

So, I struggled some time in trying to make something just work as it was supposed to work. And for no conscious reason, I was able to figure out why. As to why my Quote wouldn’t save and auto generate the usual Quote ID? It kept asking me to enter it! Problem OOB, Quote ID is locked and is auto-generated when you save the record. Instead, I got this And asks me to enter Quote in the field again. Ideally, if you have a required field locked, you can save it and the form won’t force you. But, nothing would work. After much hassle, I finally noticed the culprit lying in plain sight. Let’s look at why this was happening. Culprit This happened because the same field was on the Business Process Flow and was unlocked That was the issue. As a part of the requirement, I had put it there, but either didn’t lock it or shouldn’t be there. I just removed it since it wasn’t a big deal and things were fine now. Hope this helps you! 🙂

Introduction: This blog explains how to Count No of files in SharePoint folder using MS Flow. Steps to be followed: Select “Send an HTTP request to SharePoint” from Actions.  Enter below details:Site Address: Select the site address from the list. Method: GETUri: _api/web/GetFolderByServerRelativeUrl(‘LibraryTitle/foldername’)/ItemCountExample: _api/web/GetFolderByServerRelativeUrl(‘account/CFS Organization_584732FD1267E911A997000D3AA2C8D1‘)/ItemCount-> It will count the no of files in “CFS Organization_584732FD1267E911A997000D3AA2C8D1” folder. Output of above request:  Accessing value of ItemCount: Add Compose Action. Add below expression in Inputs: body(‘Send_an_HTTP_request_to_SharePoint_’)[‘d’][‘ItemCount’]