Latest Microsoft Dynamics 365 Blogs | CloudFronts - Page 92

Customer order printing issue in Microsoft Dynamics D365 For Retail

Hi, In this blog I am going to illustrate how to get past the printing issues when you are trying to print Customer order, Quotation etc. Let’s consider a scenario: You are using a POS printer which is connected to your CPOS system. After finishing a transaction you want to print the receipt again from the ‘Show journal’ tab. When you go to show journal and attempt to print a order receipt you get following error Here, you dont need to panic and start troubleshooting the hardware station. The issue may not be with the hardware station but with receipt itself.  The issue is when you attempt to print a receipt from show journal sometimes it displays large receipt format such as the below one. Now this receipt will not print from the POS printer such as Epson and is bound throw an error. Hence you get hardware station error. However there is a way to resolve this. You can switch to a small receipt format by direction keys button located on the bottom right of the page. After switching to a smaller receipt format, you can go ahead and print it easily with POS Printer. Hope this helps!

Share Story :

What do you do when your NAV 2017 Job is not triggering through Job Queue Entries

Microsoft Dynamics Nav Integration is one of the most popular ERP solutions that most of the medium and large enterprises use today. It is an ERP solution that is not only easy to learn but is easy to learn and implement. Your staff is going to become a lot more efficient when they use this ERP solution.  Microsoft is one of the best companies in the world for all the right reasons. This software contains some of the best and unique features that will not only raise the productivity of the staff but will also improve your performance. But, if enterprises want to enjoy the benefits that come from this ERP solution, they need to plan on upgrading Dynamics NAV to a cloud-based environment. Introduction: Working with failed Scheduled Jobs can be a tiresome process. This is exactly the case where one of my clients has an Invoicing & Payment Jobs which run once a day and Job Queue Entries fail to trigger these Jobs. No Errors in the Logs, No Execution Entry, Simply No Way of Figuring it out as to why Job didn’t trigger. Contacting Microsoft Support, they are asking to simply Upgrade the Application to the latest version. Which is not a preferred option as the database size is around 200GB. Let’s see how to resolve this in a smarter way. Pre-requisites: Microsoft Windows Task Scheduler Microsoft Windows Powershell Microsoft Dynamics NAV(Administration Module for PowerShell & Development Environment) Books & References: https://docs.microsoft.com/en-us/powershell/module/microsoft.dynamics.nav.management/?view=businesscentral-ps Demonstration: 1. Building Objects to Run through a Codeunit: As you know that Job Queue Entries support Reports and Codeunits and NAV Administration Module only supports Codeunit. So, in order to make it work, create a Codeunit to execute all the Reports and code units. 2. Creation of PowerShell Script: This PowerShell Script executes with the help of NAV Administration to Run the Codeunit. Prior to running the script, you need to set the Execution Policy. Syntax: Invoke-NAVCodeunit <Codeunit No.> – ServerIntance <ServerInstanceName> -CompanyName  <Company Name> -Force 3. Setting Up Task Scheduler Triggers: By Setting up the Triggers, you can decide recurrence to execute the Codeunit. It can be Hours, Daily, Weekly, Monthly, One-Time or Infinite. You can also set the time for precise execution. 4. Setting Up Task Scheduler Commands: Whenever we execute the PowerShell Script through CMD, we run the commands as follows. Command: PowerShell.exe <PS Script File Path> Here, we pass the PowerShell.exe into the script and PS Script File Path as a Parameter. Conclusion: Thus, using NAV Administration Module, Power-Shell and Task Scheduler I was about to replicate Job Queue Entries functionality. Although this works perfectly for NAV and Business Central – On-Premise, it works for Business Central on SaaS. In my upcoming blog, I’ll also show we can achieve this. Hope you guys find this blog useful 😇

Share Story :

Restart IIS using Visual studio and Command prompt

Dynamics 365 for finance and operations is one of the best ERP solutions in the world. Clients can do a lot of complex jobs with ease when they choose to go for ERP solutions. It not only helps in improving the efficiency of the staff but will also help in improving the productivity of the company and will also help in managing the relationship with the clients. An enterprise is going to have total control of their business when they pick an ERP solution such as Microsoft Dynamics.  The best part is that Microsoft Dynamics has some of the most unique features that you will not find in any other ERP solution or software that you find in the world. Many of the time while development we have problems due to IIS services which are necessary while debugging in D365 Finance and Operations, many of the time problems can be just resolved by restarting IIS services on one box machine. IIS services can be restarted using two methods one is from Visual studio itself and the other is from Command prompt. Let’s see both the methods one by one: 1.Restart IIS services by Visual Studio:- this is a quite easy method only needs that your visual studio should be opened with administrator permissions. Now in Visual Studio Navigate to Dynamics 365 option and click on it Now select Option Restart IIS Express thats it Now your IIS Express service will restart 2.Restart IIS services by Command Prompt:- Other than Visual Studio IIS Express can be restarted using Command Prompt as follows Open Command Prompt as an Administrator Now enter the command as “iisreset” and Hit enter After completion, you will see the following screen That’s it, your IIS Service will get restarted using Visual Studio and Command Prompt.

Share Story :

General Journal Views in Microsoft Dynamics Business Central

Introduction: Recently In Business Central, I have observed the format for General Journals where the unnecessary fields are hidden in order to avoid confusion. Pre-requisites: Microsoft Dynamics Business Central Demonstration: There are 2 Views of General Journal in Business Central. 1. Limited field view: Limited Column View 2. All field view: Full Column View 3. Switching to Limited Field View: Switching to Limited Field View 4. Switching to All Field View: Conclusion: Thus, this limited view from all field view is helpful to avoid confusion during data entering but it has drawback. If you are entering Account No. as G/L Account and want to switch the Customer as Account Type, there is no way of doing it from Limited field view.This is because in General Journal functionality, Business Central automatically selects the Account Type from previous entry causing this drawback.

Share Story :

How to Run Jobs manually in Microsoft Dynamics 365 Retail

“Run Jobs” – as the name suggests is a process between Retail Channels and Retail essentials through which we transfer data between channels and database. Please Note: Jobs Run at a specified time which may be different for every Retail Scheduler. Be aware of what the time is set for jobs to run automatically.  Running jobs at a specific time requires setting to be done so that we can schedule a specific job to run at specific time. It can be easily done manually. You’ll have to follow the below steps: Step 1: Go to distribution schedule or Channel database in Retail Dynamics 365. If the job doesn’t run from distribution schedule run it through channel database. Step 2: Go to download sessions and make sure your Job is available or in applied state. If it is in available state, go to “Batch Jobs“. Step 3: Now you will have to find the same batch job that you were searching and need to run it at a specified time. Step 4: Here, since the Job is in waiting state, you need to change it’s scheduled date and time to current time. This change must be according to the time at which you want your job needs to be run. The specified time will make your job run immediately.   Step 5: You can check if Job is being applied in “Download sessions” whenever required. Step 6: You can also change how often the job should run from going to Recurrence. Step 7: Only things highlighted in Red boxes should be checked. Hope this helps!!! Thank you! Please feel free to post any doubts you have.

Share Story :

How to embed Power BI Report in Python Web application

In this article, we will embed a Power BI report in a python web application. Following are the steps to embed a report. STEPS: Go to Power BI web service and open the report that you want to embed in your web application, then click o the file menu and select the Embed option. The following window will pop up. Now copy the highlighted URL and save it somewhere you will need that URL later. Also copy the iframe tag in your web application’s front end logic. You can also adjust the height and width of the iframe. Now open the .py file where your routs are set. Now copy the highlighted URL and assigned it to one variable as shown below. Now remove the URL of iframe and replace it with the variable in the following way. you have to enter your Power BI credentials. The final output will look like this.Hope this helps.

Share Story :

How to change the Quote status to Draft after the Quote is won in PSA V3.X using MS Flow

Problem Definition: The sales cycle in my company demands me to create an opportunity every time a CR is requested or there is an additional estimate via a proposal that we ask on the current project from the customer. This needs me to go through the cycle from Opportunity to Quote to Contract. But, in this cycle, I do not want to create another Quote or contract, but update the existing one to add another Quote Line Detail. This is not possible once the Quote is marked a won in PSA. Solution: Following is what can be done to enable the Quote to move it to Draft mode an make it editable. Step 1: Go to the Quote and click on the Flow button in the Ribbon control and click on Create New Flow as shown in the screenshot below. Step 2: Use the Common Data Service Template and click on Continue. In case you see this page and you are not signed in with your account, please sign in and continue. Step 3: On the next screen select the details as shown in the below screenshot. Step 4: Select the Update Record Option from below as shown.   Step 5: Click on Add Dynamic Content link and select Quote field from there as shown below. Step 6: Change the field “Status Value” to Draft and Save the Flow. Step 7: Navigate to the flow and name is as shown below. Step 8: Its time now to test the Flow developed. Navigate to your Quotes and filter out the Won Quotes. Open one Quote and Click on Flow button from the Ribbon control and select the Flow that we wrote as shown below Step 9: Refresh the page and check that the Flow has done its job and the Quote is now in the Draft mode, ready to edit. 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.

Share Story :

Get Dynamics CRM layoutXml used in View from DevTools

Most times when you want to use AddCustomView() method to a Dynamics 365 control, you need to pass layoutXml to the method that will show the view you define. There’s an easier trick than writing this up. Select your View Assuming, you have an Advanced Find view open in the window which you want as a layoutXml of, on the same, press F12 to open Dev Tools. Select the selector. And on the Advanced Find window, select Body section Click on it, and the par will be selected in the Console of the Dev Tools. Once this is available, search for layoutXml and cycle through the results to go to the last result. select the “value” part. That is your layoutXml. Hope this helps.

Share Story :

Expenses in PSA for Fixed Bid and T&M contracts

Problem Definition: One of my clients decided to use Expense module in PSA and to his surprise he could see the amount value to be 0 in the Actuals. But, at the same time the Cost line had values in it. Upon researching and digging into all the configurations I was tired and couldn’t conclude. Finally, one configuration that made it work was to add the Transaction Category in the Sales Price List and make it Chargeable at Cost. Below is how to do it: Navigate to the project contract. Open the Pricelist associated with the Contract. It can be either the default pricelist or can be the custom price list for that particular contract. In the case shown in the screen shot, it is the Custom Price List. How do we Identify whether it is a Custom Price List is that, with the name of the Pricelist i.e. Sales Price List USD, there is the name of the opportunity and the Timestamp appended to it. You will see it in the screenshot below. Once you open that Custom Price List and Navigate to Category Prices, Click on “+ Add New Transaction Category” You will see a Quick Create Form opening up to add the Transaction Category. Fill in the details as shown in the below screenshot. The click on Save and Close and you will see your transaction Category added in the Grid. Your configuration is now ready. The next step is: To raise an expense as shown below. Configure/Create a Expense Category and relate it to the Transaction Category as per below. Navigate to Settings Area and Click on Expense Categories and then click on New. 2. Fill in the details as shown below. If you observe in the above image, there is a Transaction Category associated with the expense category and that is the one that should be present in the PriceList that we discussed initially in the above part of this blog. Once the expense is raised, Submit it. Submission sends it for the project Manager for approval. Project Manager approves it and as soon as the Project Manager approves it, it gets converted to Actuals as shown below. 4. Last step is to Create Invoice and see if the Expense gets shown up in the Invoice. For the same traverse to Project Contract and Open the specific project contract. It will automatically take you to Invoice Entity where the Invoice will be generated as shown below. Tips to remember: For Fixed Bid Project contract, you will need to create one more project contract line header which is of T&M type. This will be associated with another project on which you can raise the expenses. For T&M, we can still continue to raise the expense on the same project and there is no need of creating one more project contract line header. 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.

Share Story :

Setup Dockers

Docker is an independent container platform that enables organizations to seamlessly build, share and run any application, anywhere from hybrid cloud to the edge. Docker provides the ability to package and run an application in a loosely isolated environment called a container. The following steps shall help you to get Docker in place on your system. Steps: Visit the link- https://www.docker.com/products/docker-desktop, which will direct you to the Dockers website, after opening the link choose the “Download Desktop for Mac and Windows”. Now Create an Account for Docker or Login with credentials if you have an Account. After that go with “Download Docker desktop for Windows” and your download shall start soon. Install the downloaded “.exe” file and you are good to go with Dockers. Now look for “Docker Desktop is running”on your TaskBar with  Docker Icon. Open Powershell, and execute the command “docker info” and you shall see the docker information as below: Hope this helps!

Share Story :

SEARCH BLOGS:

FOLLOW CLOUDFRONTS BLOG :


Secured By miniOrange