Introduction: In this blog, we are going to discuss how to set a party list field using JavaScript in Dynamics CRM. Many times, there is a requirement that any email send from CRM must be send from a specific user, irrespective of the user logged in to CRM. Scenario: In the Incident Management, there is a need that each mail send from CRM to Customers must be send from Support User. Steps: Step 1: Write a function on load of email form. Retrieve the Queue or User you want to set from Web API Step 2: Party List basically consists of User or a Queue. So, we can set User or a Queue in party list. You can differentiate the User and Queue by specifying the Entity Type. a. Queue: “queue” b. User: “systemuser” Code is given below:  var partylistData = new Array(); partylistData[0] = new Object(); partylistData[0].id = queue.value[0].queueid; partylistData[0].name = queue.value[0].name; partylistData[0].entityType = “queue”; Xrm.Page.getAttribute(“from”).setValue(partylistData); More validation can be set on basis of the requirements. On the status of the email validation can be done.

As an entrepreneur, if you want to streamline your operations and finance departments, you should go for an ERP solution. Countless companies are offering ERP or Enterprise Resource Planning solutions or software. Dynamics 365 for finance and operations, however, is one of the best ERP solutions that you can find in the market today. One of the key reasons why a lot of companies are using this software is that it is easy to install, configure, and to use. You can scale your business when you use ERP solutions like Dynamics 365. A lot of resources are available online that will help your employees become smart and efficient.  Deploying this software is easy. Here is some information for you In this blog article, we will see how we can deploy the package in Dynamics 365 Operations. This Package can be any latest update, hotfix or deployment package you have created. Prerequisites: LCS login VM Instance Steps: 1. Download, Extract and Unblock Package 2. Update topology configuration data 3. Generate a runbook from the topology 4. Execute runbook Download, Extract and Unblock Package a. Login to LCS and download the Zip file of Deployable Package. b. After downloading, go to downloaded Zip file properties and select unblock. c. Extract the Zip file to a non–user folder. Update topology configuration data a. Go to extracted folder and open the file “DefaultTopologyData.xml” b. Populate the file with VM name. i. Go to This PC -> Properties. Find the name of the machine. ii. Update the VM name with the machine name in the file. c. Populate the file with installed components i. Open a command prompt as an administrator. ii. Run the command from extracted folder path to see a list of all installed components on the computer. iii. Update the file with a list of components. 3. Generate a runbook from the topology a. Run the command to generate a runbook. AXUpdateInstaller.exe generate -runbookid=[runbookID] -topologyfile=[topologyFile] -servicemodelfile=[serviceModelFile] -runbookfile=[runbookFile] Example: b. Runbook will contain instructions in sequential steps to deploy the package. 4. Execute Runbook a. Import the runbook. AXUpdateInstaller.exe import -runbookfile=[runbookFile] Example: b. Verify the runbook. c. Execute the runbook. AXUpdateInstaller.exe execute -runbookid=[runbookID] Example: d. Export the runbook. Export the runbook for future reference, you can use it to refer the steps, time to execute each step and logs for each step. UpdateInstaller.exe export -runbookid=[runbookID] -runbookfile=[runbookFile] Example:

Microsoft Dynamics 365 for Retail Management Solution is the perfect answer to the questions from the modern day consumers related to cost-effectiveness, fast and flexible services that they aim for. Microsoft Dynamics aims at seamless management solutions across all retail channels making it easier for the customer to establish a balance between their business requirements and the deliverables. When it comes to power and performance, Microsoft Dynamics is the best enterprise resource planning (ERP) cloud solution currently available in the market This amazing retail management solution from Microsoft has considerably reduced the complexities faced by the retailers in their day-to-day life in a new and unified way making it one of the most wanted and demanded software solutions in the market. Introduction: Dynamics 365 Operation Retail is providing CPOS.  This Blog Describe you, how to configure CPOS in AX 7 Operation. CPOS is Online POS, Offline POS functionality does not support to CPOS. CPOS can be Open in Internet Explorer, chrome, Firefox browser. MPOS having Online and offline functionality. In this blog for Demo Purpose, we are configuring CPOS for Huston store. And for CPOS, I am using Chrome browser. Follow the Below Setup to Configure CPOS . Before you Start: Before you Start Configuration of CPOS. Go to the Retail and Commerce -> Headquarter setup -> Parameter -> Retail Shared Parameters Select Entity Validation Templates.  Click on Import Default template. After that Drill-down to template Option and select Select RetailVal and click on SAVE button. Step 1: Go to the Retail and Commerce > Channels > Retail Store > All Store And select Houston Store. Click on Configuration Status. Select Approve All and click on Update Button. Step 2: Go to Retail and Commerce > Channels > Channel Deployment In Retail Store search for Houston Store. You will find that Progress for Houston store is 100%. Step 3: Click on Registers. Next to that you will see all the register which is created all stores. Put the filter on “HOUSTON” on Store Number. After that you can able to view list Houston Store Registers. Select Registers Number “Houston-30” and Open it. Click on configuration Status Click on Approve all and click on Update. Once you click on Update. Status will change to Completed. Click on close button. Step 4: On register page click on Device Select “HOUSTON-30”. Application Type of this Device is “Retail Cloud POS”. which mean this is CPOS. Activation status is Pending and Validation Status is not Run. Change Activation Status from pending to Pending to Activated and click on Validate Devices for Activation. Step 5: In General Tab of Device “Houstone-30” copy POS URL and Past it in Browser. Or you can click on that URL Link. Click on Next Button. Server URL, Device ID and Register ID is set by Default base on your Cloud POS Device. Click on Activate button. Once you click on Activate, it will start for activating Cloud POS. Once its Active, you will get message Click on Get Stated. You can able to view Cloud POS Login Screen. Enter Worker user ID and Password to login. Conclusion: By following this Steps, you can configure CPOS in Dynamics 365 Operation.

Introduction: CRM SDK provides a data migration tool/application called “DataMigrationUtility” which allows simple data migration from one CRM environment to another CRM environment. Prerequisite: Microsoft Dynamics CRM. CRM SDK Purpose of the set up Our goal is to migrate accounts from one Online CRM environment to another CRM environment. Steps: Open CRM SDK folder and run ‘DataMigrationUtility’ application. Path: SDK\Tools\ConfigurationMigration Click on Create Schema. You’ll be asked to log in to your source CRM system. Select the solution, entity and fields. Then click ‘save and export’, this will save a XML schema file. To export data: select XML file created in the above steps and create a file to save the data (zip file); then click Exportdata. Click exit after successful export of data. To import data: Click on Import data and then continue. Login to your target system. Select Zip file which was created in the above steps. Click on Import data Error logs can be viewed from Logs stored.  

Dynamics 365 for finance and operations is an ERP system built and designed to match your business needs in this modern day business scenario. Elements are currently as much a business system as it is innovation deliverable, some portion of a bigger biological system where data pulled from unique channels, (for example, social, IoT, and Office) is caught, investigated, and spread so as to help explicit business objectives. Make planning simpler by giving your spending chiefs simple to-utilize apparatuses. A wizard causes them to make spending plan worksheet formats for Microsoft Excel.  This cloud-based ERP framework gives the pertinent data you have to convey vital, information-driven bits of knowledge to key divisions. Additional quick monetary bits of knowledge drive corporate procedure and development, declining obligation through effective assortment of the board. Generally, users spend lot of time in selecting each product and their variants for sales in Sales order. Dynamics 365 for operations gives option to select the product by category. Following is the process to select multiple products and their variants in a quick way: 1. Create a new Sales Order 2. Click on Add products in Sales Order Line 3.  A new form will open which is divided in to three parts Select category – To select the respective category Available Products – It shows all the products available in the selected category Add Selected products- The products which are selected for the Sales order 4.  Once the category is selected, select the product and click on Add variants to select the variants for that product. 5.  A new form will open listing all the variants for that product. The user can select all the variants by checking on Select all or can select specific variants and can put quantity. 6.  On clicking OK , all the products selected with their variants will come in the sales line. Conclusion : In this way the user can save lot of time in creating Sales order having multiple lines.

Introduction: Microsoft introduced a cloud-based platform that works with Mobile Devices known as Microsoft Staff Hub. This platform enables workers and their Managers to manage, communicate and share content. Workers can ask for time off or swap and offer their shifts with their co- workers whereas Managers can send messages to one person or the entire team. Managers can also upload files and then workers can access that file within their Mobile Apps. Microsoft Staff hub is available for Office 365 Business Subscribers as a Web App for Managers and as a Mobile App for Employees/Workers supported on iOS and Android. Settings To start with Microsoft Staff Hub, the very first step is to activate the Staff Hub which can be done by Global Admin. Enabling Microsoft Staff Hub After Login, Admin can go to the mentioned URL https://staffhub.ms/admin and enable StaffHub. Self-Provision Accounts This setting enables the ability to create the new Office 365 accounts for desk-less workers. It adds the Security Group “DesklessWorkers” and creates an account in Azure Active Directory and provisions an Office 365 Group for every team that is created. Microsoft StaffHub Team members are added as members of Office 365 Group and the files and documents that are uploaded in Microsoft StaffHub Team are stored in Group SharePoint of that Team.     Employee Resources Admins can provide their desk-less workers with links to important internal resources or PowerApps i.e. the ones that are most often used by employees. You can enter max up to three links and can give corresponding Titles. Working: Create Schedule Managers can use Microsoft StaffHub to create Schedule, Manage Requests for Shift swaps or Time off and they can also share information with files across the team. With StaffHub, Managers can update shifts from week to week, by “Copy Last Schedule” button with different color labels and can update the notes in the shift that can be highlighted to the workers. Schedules can be viewed in Day, Week, Month, Today or we can just go to a specific day. Managers can add an employee in the schedule for a shift. They can set the start and end time. Managers can also assign a color or add notes to the shift. Custom Label can be used to display in the schedule. Raise Requests Employees can request to schedule changes in the shift using Microsoft StaffHub mobile app. The request is sent to Manager for approval and once approved it is automatically updated on the schedule. Employees can also offer to swap the shift i.e. to get the shift exchanged by some other co-worker. Workers can decline the request and approve the request. View Shifts Workers can view their shifts in a single view on their Mobile App. Conclusion Thus, Microsoft Staff Hub helps managers and workers understand and manage shifts and also allows the flexibility to swap their shifts with Manager’s Approval.

Dynamics 365 for finance and operations is one of the best ERP solutions that you find in the market. ERP is an acronym for Enterprise Resource Planning. It is a software that helps small and medium-sized companies to organize their work and to scale up high.  It is quite popular because there it has got some excellent features. For example, when you deploy this ERP software in your company. You get to enjoy things such as these: Feature Management Extensibility Enhancements An Option to Cancel Batch Job that is Running and so forth On top of it, it is quite affordable when you compare with the other Softwares that you find. Getting a solution to a problem is easy, as there are a lot of resources available online. Introduction: Two types of accounting for Purchase that take place when an accounting entry is generated for a product receipt or an invoice that contains stocked items. 1. Purchase order voucher entry after posting product receipt Accounting entry for the accrued liability Purchase expenditure, un-invoiced DR Purchase, accrual CR Accounting entry for the cost in inventory for the received quantity of the stocked item Cost of purchased materials received DR Purchase expenditure, un-invoiced CR 2. Purchase order voucher entry after posting product invoice Accounting entry on the product receipt for accrued liability are reversed. Purchase, accrual DR Purchase expenditure, un-invoiced CR Account entry liability for the vendor invoice. Purchase expenditure for product DR Vendor Balance CR Accounting entry on the product receipt that records the inventory cost is reversed. Purchase expenditure, un-invoiced DR Cost of purchased materials received CR Accounting entry to record the actual inventory cost. Cost of purchased materials invoiced DR Purchase expenditure for product CR Conclusion: Inventory value as well as Vendor balance will increase.

If you are planning to get Dynamics 365 for finance and operations, that is an excellent thing. It is wise to plan on getting it as soon as possible. It is an Enterprise Resource Planning (ERP) solution from Microsoft. Entrepreneurs that want their company to scale up high in a few years prefer to get this software.  It is apt for companies that are small and medium-sized. But, even large companies can use it to their benefit. While indeed, so many companies are creating ERP solutions. Nothing comes close to Dynamics 365.  The best part is that it is easy to install and configure than any other ERP solution you can find in the market. The pricing of this software is quite reasonable. Here is a solution to one of the common problems that you might face.  To account for salary payments and related transactions, you must import and post financial transactions made by payroll provider to the general ledger. The extension has been provided in Extension Market place for Importing of Ceridian Payroll Entries. The Ceridian Payroll extension allows you to import payroll transactions from the Ceridian HR/Payroll (US) and Ceridian PowerPay (Canada) services. Please find below the steps on how to install extension and import payroll entries in Financials: In the top right corner, choose theSearch for Page or Report icon, enter Extension, and then choose the related link. Click on Extension Marketplace. Select Ceridian Payroll from the list of apps. Click on Install Once it is installed user needs to logout of the Financials and log in to see the changes. Once the extension is installed the user can now import payroll entries into the system. To Import a file that is received from payroll provider user needs to map the external accounts in the payroll file and then open General Journal by searching in global search. In the General Journal, on the Action tab user needs to click on Import Payroll Transactions. Click on Next to proceed importing transaction. System will ask to provide the path of the file. Once the file is uploaded in the system User can post the general journal. Conclusion: The Ceridian payroll extension helps in reducing time and effort to create manual payroll entries in system and eliminates human error.

Scenario: CRM space is expensive, and often clients want alternatives to CRM storage for storing documents, images as these take up most of the space. Available solutions: SharePoint Online with Dynamics CRM OneDrive for Business with Dynamics CRM Currently, SharePoint document management is the preferred choice for most of the customers as alternative to storing email attachments and documents. Advantages of SharePoint: SharePoint storage cost is very small about $0.20 per GB/Month compared to CRM’s $9.99/GB/Month. So, CRM space is around 50 times costlier than SharePoint space. You can leverage SharePoint Document management features like: Full text Search Metadata sorting Revisions Enterprise grade security There are 2 ways to use SharePoint for document management with Dynamics: Use SharePoint Online Integration with Dynamics CRM. This is the ideal and efficient way to use SharePoint. You can see the steps for SharePoint online integration in one of our previous blogs: https://www.cloudfronts.com/enable-sharepoint-integration-and-onedrive-for-business-in-crm/ Use 3rd Party tools like Power Attachment, which will migrate your File attachments (notes) and Email attachments from CRM storage to Dynamics. More detail and pricing about Power attachments can found here: http://www.powerobjects.com/powerpacks/powerattachment/ 1st approach should be the preferred way for using SharePoint as it is free, and works well. But users complain about an extra step to navigate to attachments, in which case you can go for Approach 2. Alternative Solution: The drawback with using SharePoint is if you have requirement of migrating your documents from CRM storage (Notes Attachments and Email attachments), you need to use 3rd party paid tools like Power Attachment. Developing custom plugins to migrate documents to SharePoint is difficult in CRM online, since we cannot use External libraries in Sandbox plugin. Due to above 2 reason, we can use Azure Blob storage as a possible alternative for migrating CRM documents. What is Azure Blob storage: Massively-scalable object storage for unstructured data With exabytes of capacity and massive scalability, Azure Blob storage easily and cost-effectively stores from hundreds to billions of objects, in hot or cool tiers depending on how frequently data access is needed. Store any type of unstructured data—images, videos, audio, documents and more. Azure Blob Features: Easy to Use – Geo Redundancy Robust API access Very Cheap storage space: It costs about $0.03/ GB/ month- which is 6.5x less than SharePoint storage cost and 300x less than CRM storage cost. Learn more about pricing here: https://azure.microsoft.com/en-us/pricing/details/storage/blobs-general/ API Coding for CRUD Operations in Azure Blob: I have written a sample plugin which will migrate the CRM attachment to Azure blob, and save the Azure blob file link back in CRM. The plugin is registered on Annotation entity For this, I have used a RestHelper and BlobHelper utility code files, which have all the operations of (a) making a web request and (b) performing blob operations. The Helper files and the CRM plugin sample can be found in the below GitHub link:  https://github.com/somesh2207/CRMOnlineWithAzureBlob The plugin file is UploadDocumentToBlob.cs The below code from the plugin file takes the document from CRM and creates a blob using REST API: Entity entity = (Entity)context.InputParameters[“Target”]; string documentBlobURL = string.Empty; //// Optional condition to migrate attachments related to particular entity. //// If you want to migrate attachments for all entities, remove this CONDITION if (entity.Contains(“isdocument”) && entity.GetAttributeValue<bool>(“isdocument”) == true && entity.GetAttributeValue<string>(“objecttypecode”) == “account”) { string storageAccount = “<storageaccountname>”; string filename = entity.GetAttributeValue<string>(“filename”); string containerName = “<blobcontainername>”; string storageKey = “<blobstorage_accesskey>”; //// Read File string text = entity.GetAttributeValue<string>(“documentbody”); BlobHelper blobHelper = new BlobHelper(storageAccount, storageKey); bool isUploadSuccess = blobHelper.PutBlob(containerName, filename, text); //// Once blob upload is Success, get the Azure blob download-able URL of the uploaded File if (isUploadSuccess) documentBlobURL = string.Format(“https://{0}.blob.core.windows.net/{1}/{2}”, storageAccount, containerName, filename); }

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.