Introduction: There is server requirement from client, that They required few Reports and KPI  directly on the POS on store. Like Sales by Hours or sales by Item. This report run against the retail channel Database which is connected to that specific terminal. This report is not too complex to develop on other word you can say its does not required any heavy development for these reports. it required on XML report definition, SQL Query for the Data or as requirement of column. In Below Presentation, I will demonstrate you “ Sales by Sale Person” Report. This report is most commonly request from client. Step 1: Open the AX Client and goto  Retail -> Setup -> Channel Report Configuration Open Channel Report Configuration. Click on New Button, Once you click on New button Provide New Report ID :- 114 and Description :- Sales by Sale Persons In Report Details Section, select POS Permission Group in Permission Group fields For E.g. if casher want to run or view this report then select Cashier or if only Manager can view or run this report then select Manager. Report Definition XML, here you can develop the report. With below code. Which is combination XML report definition, SQL Query. <?xml version=”1.0″ encoding=”utf-8″?><RetailReport xmlns=”http://schemas.microsoft.com/dynamics/retail/2013/06/retailreportdefinition”><Title>SALESBYSALESPERSON</Title><DataSet><DataSourceType>OLTP</DataSourceType> <Query> <![CDATA[SELECT RST.NAMEONRECEIPT AS SALESPERSON, count(*) as TRANSACTIONLINES  , CAST(SUM(RTL.NETAMOUNT) * – 1  AS DECIMAL(18,2)) AS SALESAMOUNT, CAST(AVG(RTL.NETAMOUNT) * -1 AS DECIMAL(18,2))  AS AVGSALESAMOUNT FROM ax.RETAILTRANSACTIONSALESTRANS RTL INNER JOIN ax.RETAILTRANSACTIONTABLE RTA ON RTL.CHANNEL = RTA.CHANNEL AND RTL.STORE = RTA.STORE AND RTL.TERMINALID = RTA.TERMINAL AND RTL.TRANSACTIONID = RTA.TRANSACTIONID LEFT OUTER JOIN ax.RETAILSTAFFTABLE RST ON RTL.STAFF = RST.STAFFID WHERE RTA.CHANNEL = @bi_ChannelId AND @dt_StartDate <= RTA.TRANSDATE AND @dt_EndDate >= RTA.TRANSDATE AND (RTA.TYPE = 19 OR RTA.TYPE = 2 OR RTA.TYPE = 14) AND RTA.PAYMENTAMOUNT <> 0.00 AND RTL.TRANSACTIONSTATUS = 0 group by  RST.NAMEONRECEIPT ORDER BY  SALESPERSON]]> </Query></DataSet> <ReportParameters><ReportParameter Name=”dt_StartDate” DataType=”DateTime” Label=”STARTDATE” DefaultValue=”2014/1/1″/><ReportParameter Name=”dt_EndDate” DataType=”DateTime” Label=”ENDDATE” /> </ReportParameters> <ReportCharts> <ReportXYChartCategories=”SALESPERSON”><Series>SALESAMOUNT</Series></ReportXYChart> <ReportXYChartCategories=”SALESPERSON”><Series>TRANSACTIONLINES</Series></ReportXYChart> <ReportXYChartCategories=”SALESPERSON”><Series>AVGSALESAMOUNT</Series></ReportXYChart> </ReportCharts></RetailReport> Report Definition XML Explanation XML Report Definition Below Part is XML Report Definition of POS Report. <?xml version=”1.0″ encoding=”utf-8″?><RetailReport xmlns=”http://schemas.microsoft.com/dynamics/retail/2013/06/retailreportdefinition”><Title>SALESBYSALESPERSON</Title><DataSet><DataSourceType>OLTP</DataSourceType> SQL Query With help of SQL Query, you can set report logic. For Sales by Sales Person report below is SQL Query. You can also use stored procedures. <Query> <![CDATA[SELECT RST.NAMEONRECEIPT AS SALESPERSON, count(*) as TRANSACTIONLINES  , CAST(SUM(RTL.NETAMOUNT) * – 1  AS DECIMAL(18,2)) AS SALESAMOUNT, CAST(AVG(RTL.NETAMOUNT) * -1 AS DECIMAL(18,2))  AS AVGSALESAMOUNT FROM ax.RETAILTRANSACTIONSALESTRANS RTL INNER JOIN ax.RETAILTRANSACTIONTABLE RTA ON RTL.CHANNEL = RTA.CHANNEL AND RTL.STORE = RTA.STORE AND RTL.TERMINALID = RTA.TERMINAL AND RTL.TRANSACTIONID = RTA.TRANSACTIONID LEFT OUTER JOIN ax.RETAILSTAFFTABLE RST ON RTL.STAFF = RST.STAFFID WHERE RTA.CHANNEL = @bi_ChannelId AND @dt_StartDate <= RTA.TRANSDATE AND @dt_EndDate >= RTA.TRANSDATE AND (RTA.TYPE = 19 OR RTA.TYPE = 2 OR RTA.TYPE = 14) AND RTA.PAYMENTAMOUNT <> 0.00 AND RTL.TRANSACTIONSTATUS = 0 group by  RST.NAMEONRECEIPT ORDER BY  SALESPERSON]]> </Query></DataSet> Report Parameter This Dataset you to define report input parameter. In this Example Start date and End Date is Input parameter. When user want check data with specific date range then he can enter start and End date. <ReportParameters> <ReportParameter Name=”dt_StartDate” DataType=”DateTime” Label=”STARTDATE” DefaultValue=”2014/1/1″/><ReportParameter Name=”dt_EndDate” DataType=”DateTime” Label=”ENDDATE” /> </ReportParameters> Report Charts Report chart is used to Display chart on fields which you define in SQL Query Section. Here in this Example, I define SALESAMOUNT, TRANSACTIONLINES & AVGSALESAMOUNT. <ReportCharts> <ReportXYChartCategories=”SALESPERSON”><Series>SALESAMOUNT</Series></ReportXYChart> <ReportXYChartCategories=”SALESPERSON”><Series>TRANSACTIONLINES</Series></ReportXYChart> <ReportXYChartCategories=”SALESPERSON”><Series>AVGSALESAMOUNT</Series></ReportXYChart> </ReportCharts></RetailReport> Step 2: Once Step 1 is completed, we need to set this report to POS. so that user can use this report. We need to run job for the Report to all channel. In AX, go to Retail -> Periodic -> Data distribution -> Distribution schedule Run the JOB ID: – 1110. And wait for couple of minutes to complete the job. After Complete the Job Open AX POS and Go to POS Report. You will be able to see Sales by Sales Person Report. Conclusion: By Using, XML Report Definition, SQL Query, Report Parameter and Report Chart you can develop POS Report.  

In this blog , we will see how can a user create a custom Page Template Web Template Using Liquid template code in CRM Portals. Pre-Requisites: 1. Dynamics 365 Portal(CRM) 2. D365 CRM Environment Scenario: The user will have to create a simple two-column template that WebLink Set as left -Side navigation, with the page content to the right. The Web Template Page Template that we are going to create is shown below. Steps for Implementing Above Scenario Step 1: The user will first have to create two Web Templates one which will have the layout design and the other will have the content to the layout designed previously. In the Layout web template the user has to go to Portals > Web Templates on the dashboard and select new in the CRM Environment. The user has to enter the following details along with the Liquid Template code as shown below. Step 2: In this step the user has to create the second Web Template as shown below which will contain the Liquid Template code for inserting data content in to the Web template layout designed previously. Step 3: Now the user will have to create a new web link set according to the Web Link Set that the user has defined and intends to use in his Web Template. Over here the user has referred to Web Link Set ‘My Order Link’. The user has to go to Portals > Web Link Sets and click on New and enter the details as shown below. The user needs to add Links to the Web Link Set as shown below by clicking on the ‘+’ button to the right after the Web Link Set is saved. Step 4: Once this is done the user now has to create a Page Template that will include the web templates that we have created previously. In order to create a new Page Template the user has to go to Portals > Page Template. The user will enter the details of the Page template as shown below and click on ‘Save’. Step 5: Now the user will create a Web Page that will utilize the Page Template that we have designed. The user can create a Web Page directly form a Page Template by clicking on the ‘+’ button to the right on the Web Page Tab or by going to Portals > Web Pages and clicking on New. The user has to enter the details of the Web Page as shown below. The user can create a custom Localized Content that will be used in the 2nd section of the layout of the Web Template. The user can create a new localized content for the following Web Page by selecting the ‘+’ option. Step 6: The user will have to go to the Dynamics 365 portal environment and create a new child page that will display the result. While Entering the details of the child page the user will have to specify the Page Template that we have created previously as shown below.

In D365 Operations, many times we need to check what data is store in tables. So, we open table browser from backend. Sometimes we face below error for all tables while opening table browser, it is a very common error and it simply means any recent customization is not compiled or sync in database. Solution: Go to Dynamics 365 -> Build Models Select the model which you have recently customized. Go to options tab. Select Synchronize database. Click Build.

Introduction: Goods and Service Tax (GST) will be applicable at national level. It is a consumption based tax levied on sales, manufacture and consumption of goods and services. This tax will act like a substitute for all indirect tax levied by the government. GST patch has been released and is a part of the cumulative update 17 for Microsoft Dynamics NAV 2016. Pre-requisite: 1. Microsoft Dynamics NAV 2016 (IN version) 2. Cumulative Update 17 for Microsoft Dynamics NAV 2016 IN Purpose: The purpose of the blog is to explain the procedure to update the GST patch on Microsoft Dynamics NAV 2016 IN. Procedure: Download the Cumulative Update 17 for Microsoft Dynamics NAV 2016 IN (CU 17 NAV 2016 IN.zip) from here. Unzip the folder. Take SQL backup of the complete NAV 2016 database to ensure nothing is lost after the Cumulative update 17 which includes GST patch has been installed. Fig 1: SQL Backup of database A cumulative update includes files that are separated into the following folders i.e. ‘APPLICATION’ and ‘DVD’. Application folder includes the following files: Fig 2: Application folder To install application files, follow below steps: Unmodified databases: Import the CUObjects.fob file (highlighted in Fig. 3) into unmodified Microsoft Dynamics NAV 2016 database and replace the existing objects in the database with the cumulative update objects. Fig 3: CUObjects.fob file in Application folder Modified databases: Import the CUObjects.fob file (highlighted in Fig. 3) into the modified database. Replace the objects in the database that have not been modified. Compare and merge the cumulative objects with the objects in the database that have been modified. If a table in the cumulative update has a new field and the same table in your database has been modified, use the Merge: Existing<-New or the Merge: New<-Existing options to import the new fields. Fig 4: Reading objects process after selecting file to be imported Fig 5: Import Worksheet which shows the GST patch objects Fig 6: Number of objects created and replaced after import of objects has been completed All objects in the database have to be compiled after the import process has been completed. Now in the Microsoft Dynamics NAV desktop client and web client, GST patch will be available under Financial Management Department. Fig 7: GST patch available in NAV under Financial Management Department Fig 8: GST Using the above mentioned steps, GST patch can be installed in the Microsoft Dynamics NAV 2016 (IN version).

In this blog article, I am explaining about upgradation of Scribe insight version. Upgrading scribe insight 7.8.0 version to latest scribe insight 7.9.2 version. Step 1: Backup Export existing scribe Console Open scribe console -> right click -> Import/Export -> Export a package -> Select package -> Next -> Give specific name and path to store the backup files -> Next -> Finish This will create a .spkz file in the specified path. Take Backup of Collaboration folder Make a copy of collaboration folder. Path eg: C:\Users\Public\Documents\Scribe Take a backup of Scribe Serial Number Open Scribe Workbench -> Help -> About Scribe Insight -> Copy the Serial Number Step 2: Unregister the existing Scribe version Open Scribe Workbench -> Help -> Unregister this Computer -> Yes After successful unregistering, you will get a pop up window as Step 3: Stop the Scribe services From Task Manager -> End the Scribe.UpdateService.exe (if it exists) Step 4: Download current version of Scribe Insight Site: https://openmind.scribesoft.com/html/insight_download Step 5: Download Microsoft.NET Framework 4.5.2 Site: https://www.microsoft.com/en-us/download/details.aspx?id=42643 Note: Select scribe update notifier when asked during installation process. Restart the computer/remote server. Step 6: Run the Application Click on Run -> Next -> specify the path for unzip -> click Unzip -> Close. Step 7: Installation of Latest version of Scribe Insight Run Setup file Open ScribeInsight792_x64 folder (which is stored in the path specified during unzip) -> Run Setup.exe Uninstall existing adapters we need to uninstall the existing adapter eg: CRM , AX ,etc. Control Panel -> uninstall/ program Also, the system will automatically uninstall the adapter. Install Adapters Click on check box Insight adapters then click on Start installation Below window will appear Click on Install After Visual studio installation below window will pop up Restart the computer Open the setup.exe file again -> Click Next -> Accept the terms -> Next -> Install -> Next -> Accept license agreements -> Install -> Finish Setup wizard will pop up -> cancel username window -> select the adapter you want to install -> Next -> Finish Start Scribe Services Start -> Run -> services.msc -> Select Scribe Services one by one -> click on LogOn -> Click This Account -> Click Browse -> Browse the name -> Insert Password -> Apply Check dependencies and make sure all the dependent services are started before you start the Scribe Services. Do this for all the Scribe Services. (Services starting with name ‘Scribe’) Step 8: Register the Scribe Insight Select Register Online Copy the Serial Number which you took backup before. You will get details window You will get product update status Click Next Registration Successful window will appear -> Click Finish Step 9: Verify the version of installed Scribe Insight Open Scribe Workbench -> Help -> About Scribe Insight  

In this era where consumers are more aware, informed and expect just a little bit more with any service they opt for, you must be on your toes all the time if you want to satisfy them at every point. With Microsoft dynamics 365 for sales, go for the salesforce automation that will let you catch the nerves of what your consumers demand and expect. This will not only help you in engaging well with your customers, but will also help you in satisfying their business needs that will in turn help you to attract more new customers by satisfying the current ones.  The accelerated performance and boosted productivity will be witnessed from time-to-time enabling your customers to build a solid business foundation of their own Introduction: In Dynamics 365 Financials, Sales order line items cannot be integrated in a single step. As, it takes only item number in a create () and rest all the fields are considered as an Update. Prerequisite: Dynamics 365 Financials. TIBCO Cloud Integration Subscription. Purpose of the Setup: Our goal is to integrate Sales Order Line item from Microsoft Dynamics CRM Online to D365 Financials through TIBCO Cloud Integration. Steps: Configure a connection for your Microsoft Dynamics CRM Online by providing the required information. Configure a connection for your D365 Financials by providing the required information. Create a new Solution and specify the Solution name and the Agent. Note: Here, we are using a Cloud Agent. Now create an Integration Map for integrating Sales Order Header and its Line items from CRM Online to Dynamics 365 Financials. Sales Order Header: Use Create Block and create Sales Order Header by mapping required fields. Sales Order Lines: Use For each child Block for looping the Sales Order Lines. Use Create Block to Create Sales Order Line by mapping primary fields like Document_No,Document_Type,No Use Update Merge Block to map rest of the fields of Sales Order Lines like quantity,Unit_price etc along with ETag and ETagConcurrencyBehavior Note: (As specified by Scribe Software) The OData Protocol uses Entity Tags (ETag) to determine how to update or delete data. The Dynamics NAV/Financials Connector exposes these ETags as fields: ETag — Available as a source and target field, contains the ETag value provided by the Dynamics NAV/Financials OData service. ETagConcurrencyBehavior — Available as a target field, used to determine how data conflicts are handled. Possible values for this field are: Always Overwrite (default) Overwrite If Match Overwrite If Not Match

Microsoft Dynamics is an ERP or Enterprise Resource Planning software that is created by one of the top companies in the world, Microsoft. Many small and medium companies are using Microsoft Dynamics NAV these days. Microsoft Dynamics NAV upgrade is now available.  Businesses that are using this software can now update it. This ERP software does help companies to remove the inefficiencies in their processes. Almost all the departments in the organization can benefit when they start to use the ERP software.  Once you update the software, you might struggle a few days as you try to understand the way the system works. Here is one of the issues that you might face and how you can handle it Introduction: Microsoft Dynamics NAV can be embedded in SharePoint online which will be available as an app in SharePoint. Thus, NAV data will be displayed on the SharePoint site. The user can then modify and save the data on the SharePoint site through the NAV web client. Also, web parts such as Sales Orders List, Customers List, etc. can be added to the SharePoint site. When the user selects a particular record in SharePoint online, it opens the relevant page in the Microsoft Dynamics web client and after the changes are saved and the page has been closed, the change is reflected in SharePoint online. Pre-requisites: 1. Microsoft Dynamics NAV 2016 2. SharePoint online account Purpose: The main purpose of embedding NAV 2016 in SharePoint online is to make all the NAV data available in SharePoint so that a SharePoint user can check and modify NAV data in SharePoint online itself. Procedure: Step 1: To Register Dynamics NAV as an App in SharePoint Go to the appregnew.aspx page in your SharePoint given as below: https://MyTenant.sharepoint.com/_layouts/15/appregnew.aspx where https://MyTenant.sharepoint.com is the URL of the SharePoint site. The following fields have to be entered to register a new app: Client Id: It will be generated automatically after clicking the generate button. Client Secret: It will be generated automatically after clicking the generate button. Title: Enter a unique title for the app. App Domain: Enter the host name of Microsoft Dynamics NAV web client URL for example cronus.com Redirect URL: Enter the URL of the Microsoft Dynamics NAV web client for example https://www.cronus.com/DynamicsNAV100 Click on the Create button to register the app. Step 2: Create an app catalog Go to the following link: https:// MyTenant.sharepoint.com/_layouts/15/online/SiteCollections.aspx Go to apps and then navigate to app catalog Create a new app catalog site if there is no existing app catalog for the tenant Enter a title for the app catalog and the web site address name. Also enter the administrator name. Click OK and now the app catalog will be created and will be added to the Site Collections list. Step 3: To create app in SharePoint online. Go to Visual Studio and Create a new project – App for SharePoint Enter a unique name for the project. The app should be Provider-hosted After the project has been created, remove the webapp that is created by visual studio automatically. Now go to AppManifest.xml. Replace the highlighted part of Start page link in Visual Studio (shown in the below screenshot) with the web client URL for example: https://www.cronus.com/DynamicsNAV100/WebClient/ Right click on the project and Publish the app. After the app has been published, package the app. Step 4: Upload the app made in Visual Studio to SharePoint in Apps for SharePoint and add the app to Site collections Go to the app catalog created. Click on Apps for SharePoint. Now upload the app to SharePoint. It can be done directly by dragging the app from the folder in which it is created after publishing and packaging to the Apps for SharePoint section. The app will then be copied under apps for SharePoint. Go to Site Collections and navigate to Site Contents. Click on ‘Add an app’ Click on ‘Trust it’ and then the app will be added to SharePoint. Step 5: To add a Microsoft Dynamics NAV web part to SharePoint online Go to Visual Studio and open the project that was created initially. Right click on the project and add a new item ‘Client Web Part (Host Web)’ Enter the Web part URL under ‘Select or enter the URL of an existing web page for the client web part content’ The following code illustrates how to modify the Elements.xml file: <?xml version=”1.0″ encoding=”utf-8″?> <Elements xmlns=”http://schemas.microsoft.com/sharepoint/”> <ClientWebPart Name=”ListPart” Title=”Microsoft Dynamics NAV List Part” Description=”List from Microsoft Dynamics NAV” DefaultWidth=”800″ DefaultHeight=”300″ > <Content Type=”html” Src=”https://www.cronus.com/DynamicsNAV100/WebClient/List.aspx?page=_ThePageId_&amp;pagesize=5&amp;shownavigation=0&amp;showribbon=0&amp;showuiparts=0&amp;isembedded=1/> <Properties> <Property Name=”ThePageId” Type=”int” DefaultValue=”9305″ WebCategory=”Microsoft Dynamics NAV” WebDisplayName=”Page number” RequiresDesignerPermission=”true”     />                        </Properties>                    </ClientWebPart>                    </Elements> The above ‘ThePageId’ property has been defined so that the web part page to be displayed can be modified after clicking ‘Edit’ on the SharePoint page. Change the version number in AppManifest.xml. Again publish and package the app. Now Remove the previous app uploaded in Apps for SharePoint. Drag the app again and replace it in Apps for SharePoint.g. Now Go to Site Collections and navigate to Site Contents. Click on ‘Add an app’. Go to the Site Collection where the app has been added. Click on ‘Edit’. Select Insert an ‘app part’. Select the created web part and add it. Thus, the web part will now be added to the SharePoint page. The above screenshot shows that Sales Orders List web part has been embedded in SharePoint online.On clicking a particular record, it opens the relevant page in the NAV web client. Modifications can be made above. Upon saving and closing this record, the SharePoint page is refreshed and the change is reflected in SharePoint online. Important Note:  The web part will not be embedded and displayed if the following property is present in web.config file which is present in the WebClient folder: <add name=”X-FRAME-OPTIONS” value=”SAMEORIGIN” /> Remove/Comment the above line of code in web.config file to embed NAV web parts in SharePoint online because SAMEORIGIN allows framing of the Microsoft Dynamics NAV Web client in another … Continue reading Embedding Microsoft Dynamics NAV and its web parts in SharePoint online →

Since Microsoft Dynamics NAV upgrade is available now, it is crucial for you as a company to go for it and get the update. Microsoft Dynamics NAV is an ERP software. ERP stands for Enterprise Resource Planning. Companies can increase the efficiency of their staff as well as their productivity when they use this particular ERP software.  Especially, small and medium companies can get a good return on the investment if they invest in this particular software. Here are some of the departments in your organization that is going to benefit well when you use ERP software: Dynamic 365 Finance Manufacturing Units Customer Relationship Management Dynamic 365 Supply Chains Electronic Commerce Analytics and so forth Introduction: This article explains how to change the editable fields into un-editable fields based on certain condition. In this article, we make the page fields un-editable on change of status from Open to Released. For example, the fields like No., Description etc. will be freeze when the NAV page status changes to Released. Pre-requisites: Microsoft Dynamics NAV 2017. Steps We create a Boolean field in the Global variable (Ctrl + G) in the NAV page and sets the property by clicking on (Shift + F4) of the boolean variable ‘IncludeInDataset’ to yes. This property is set to yes when the variable is used as the value of the Editable property, enabled property, visible property or StyleExpr property. Now we select the fields of the NAV which needs to be changed to un-editable and set the enabled properties of the field to the Boolean field name. Now in the C/AL code (F9), in the ‘OnAfterGetCurrRecord’ we place a condition that if the status is Released then the Boolean field ‘fieldeditable’ is set to false this will freeze the fields and only if the status is open the ‘fieldeditable’ will be set to true. By default the value of the boolean variable is true. Below is the screenshot of the NAV page with status open. Below in the screenshot , the approval status is ‘released’.

ERP means Enterprise Resource Planning. So many companies are creating ERP software these days. Microsft Dynamics is a product from the world’s leading company Microsoft. Dynamics 365 for Finance and Operations is one of that ERP software that can help companies (Small & Large) to streamline their finance and operations departments so that they can become efficient.  The price is affordable, and once you install it, using the software is quite easy. There are some of the best features that this ERP software offers. You need to take the time to understand how to use this software to do things much quicker. If you are the employer, you should plan on organizing training sessions so that people can understand how to use it. Microsoft Dynamics 365 for Operations supports Direct delivery to customers. With direct delivery, sales orders are delivered directly from the vendor to the customer without physically entering your company’s inventory.  This type of delivery saves delivery time, labour cost, and inventory carrying costs, reduce transportation cost because you do not hold the products in your warehouse before you ship them to the customer. Below is the procedure to send ordered products directly to the customer from the vendor. 1) Open Sales and marketing > Common > Sales orders > All sales orders. Or Accounts receivable > Common > Sales orders > All sales orders. 2) Click Sales order in the New group of the Action Pane to create a new sales order. 3) In the Create sales order form, select Customer account and then click OK. 4) In the Item number drop-down, select Item. Enter quantity in Quantity Field. Specify all other information which is required. 5) Click Direct delivery in the New group of the Action Pane. 6) Then Direct Delivery form will be opened. If Vendor account number specified on item then it will automatically come on Direct Delivery form otherwise you can select or change it manually. Select the Include all check box if you want to create direct deliveries for all the sales order lines in the form. You can also select individual lines by clicking the Include check box for each sales order line and click OK. 7) Once Purchase order is created you will get below Infolog on screen Automatic purchase creation Vendor account: XXXX Purchase order XXXXXX has been created. And also you can see Purchase order number on Sales order line details in reference number field. 8) Open Purchase order, Click Header view in the Page Option group of the Action Pane, and then click the Address FastTab. You can see Customer Delivery address which came from Sales order form. 9) Now confirm the Purchase order and Post the Product receipt. 10) Once Product receipt has been posted then Purchase order status will be changed to Received and Sales order status will be automatically changed to Delivered. Conclusion: By using Direct delivery functionality you can create deliveries directly from vendors to customers, reducing delivery time and order administration.

In this blog article, I will explain about the new updates of Power BI related to New Quick Calcs, Word wrap on matrix row headers and X-axis & Y-axis font size control. New Quick Calcs: Percent of row total & percent of column total In this Power BI update, they are introducing two new Quick Calcs. These are as follows: Percent of row total Percent of column total Under the field pane -> right click on value field -> Quick Calc. Then, under Show value as, you will see Percent of column total and Percent of row total If you convert a matrix visual with one of these new Quick Calcs, the calculation will convert these totals into a percent of grand total. Example: In below figure Cost column shows the cost for sub category. After applying the Quick Calcs as Percent of column total the matrix is looks like follows: Word wrap on matrix row headers: In earlier update, the word wrap was added for table header only but now it’s added for matrix row header as well. You will see the Word wrap toggle under the Formatting pane -> Row header card -> Word wrap. Once you turn on word wrap, the row headers will word wrap to fill the space they have. X-axis and Y-axis font size control Earlier we were not able to control the font size of X-axis and Y-axis. But now we can control the X-axis and Y-axis font size. Now you can find the text size slider under the X- axis and Y- axis card in the formatting pane. After changing in font size of X- axis and Y-axis.