How to create a label in Dynamics 365 for finance and operations

How to create a label in Dynamics 365 for finance and operations, Creating a Label file in D365

Creating a Lable in Dynamics 365 for finance and operations is quite simple.

Getting ready

RDP the DEV server and get ready.

To get started, open Visual Studio, and then create a project.

File>New> Project>

How to do it...

Once Project is created > Click on Solutions Explorer>

To create the label file, follow these steps:

Right-click on the project and select Add | New item... or use the keyboard shortcut, Ctrl + Shift + A.
Choose Labels and Resources from the Dynamics 365 Items,

Now follow the Label File Wizard.

Select Languages>

Then Finish>

Done

Happy D365!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

New Update from Microsoft now we have copy button in LCS as well! https://lcs.dynamics.com/V2

New Update from Microsoft now we have copy button in LCS as well! https://lcs.dynamics.com/V2

Loved: Copy function in Microsoft LCS

Happy LCSing!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Microsoft Dynamics 365 document routing service is not running. It can be started from the windows services administrative tool.

Microsoft Dynamics 365 document routing service is not running. It can be started from the windows services administrative tool.

Issue: Microsoft Dynamics 365 document routing service is not running. It can be started from the windows services administrative tool.

Microsoft Dynamics 365: Microsoft Dynamics 365 Finance and Operation

OS: Windows Server 2016

SQL: SQL 2017

Solution:

Open Run> Open services.msc> When we checked, it was in the stopped state,

Please start:

Click on the icon and then click on the Printer Tab:

How to install and Run the Document Routing Agent as a Windows service

Happy D365 Printing!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

The requested operation requires elevation.? on command prompt resulting the ipconfig /flushdns

The requested operation requires elevation.

Why do we see The requested operation requires elevation.? on command prompt resulting the ipconfig /flushdns ?

Solution: type cmd on search and the "Run as Administrator"

Happy CMDing!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

How to fix certificates SSL error on D365fo One box VHD.

Step 1: Create a new self-signed certificate

Run the following Power Shell command (Run as Administrator):

New-SelfSignedCertificate -Subject "CN=*.cloud.onebox.dynamics.com,O=Microsoft Corporation,L=Redmond,S=WA,C=US" -DnsName "*.cloud.onebox.dynamics.com", "usnconeboxax1ecom.cloud.onebox.dynamics.com", "usnconeboxax1pos.cloud.onebox.dynamics.com", "usnconeboxax1ret.cloud.onebox.dynamics.com" -CertStoreLocation "cert:\LocalMachine\My" -KeyUsage DataEncipherment, KeyEncipherment, DigitalSignature -HashAlgorithm "SHA384" -KeyAlgorithm RSA -KeyLength 2048 -NotAfter (Get-Date).AddYears(5)

This would create a new certificate, set to expire in 5 years.

Step 2: Copy the new certificate to the folder where trusted certificates are stored

Open Manage computer certificates (certlm). 

Newly generated certificate can be found in the Personal\Certificates folder. 

It has the same name as the old one, but different expiration date. 

Now copy and paste the new certificate to the Trusted Root Certification Authorities\Certificates folder.

Step 3: Bind the new certificate with D365FO

Open Internet Information Services (IIS) Manager. 

Now navigate to the AOSService site (1), click the Bindings link on the right 

(2) and select the hostname 

(3) and then click the Edit button 

(4)The Edit Site Binding dialog opens. Open the SSL certificate drop-down selection box 

(5)You will see two certificates with the same name (*.cloud.onebox.dynamics.com). The one selected is probably the old one. Select the other one. Then click the View button to inspect, if you selected the right certificate (by checking the expiry date, for example).

Click Yes if the system asks for confirmation to change the certificate for other related sites.

Close all open dialogs. Restart the AOSService (Click the Restart link under Manage Websites in the vertical pane on the right).

Step 4: Test if the connection to D365FO is treated as safe in Chrome

Restart Chrome and navigate to D365FO. It should work fine. 

How to check which SQL DB is linked with Sharepoint?

How to check which SQL DB is linked with Sharepoint?

Issue:

How to check which SQL DB is linked with Sharepoint?

AX: AX 2012 R3
OS: Windows Server 2012 R2
SQL: SQL 2014
SharePoint:

Solution:

Open SQL> Start RUN>SSMS>

Select the DB>

SELECT program_name, count(*)

FROM

Master..sysprocesses

WHERE ecid=0

GROUP BY program_name

ORDER BY count(*) desc

Now I can see the List of SQL DB which are used in SharePoint!

Happy Querying! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Microsoft Certifications and Exams News September 2018

Microsoft Certifications and Exams News September 2018

This month, Microsoft released two exams and two practice tests. In September, two more practice tests will be ready for the new Azure Administrator exams. New Exams Released on August 17, 2018 MB6-898: Microsoft Dynamics 365 for Talent 70-777: Implementing Microsoft Azure Cosmos DB Solutions (beta; discount codes available, while supplies last, for exams taken before October 1, 2018)

Practice Tests Released 70-774: Perform Cloud Data Science with Azure Machine Learning 70-775: Perform Data Engineering on Microsoft Azure HDInsight Practice Tests Coming in September 2018 on mindhub AZ-101: Microsoft Azure Integration and Security AZ-102: Microsoft Azure Administrator Certification Transition (Original Publication Date: 09/06/2018)

Discount for New Beta Exam 70-777: Implementing Microsoft Azure Cosmos DB Solutions

If you design, build and troubleshoot Azure Cosmos DB solutions, don’t miss this opportunity to take Exam 70-777 (beta) at an 80% discount. The 300 beta seats are available, while supplies last, on a first-come, first served basis, and you must register and take the exam by October 1, 2018. As a developer or an architect, your working knowledge of Cosmos DB helps you meet business and technical requirements. Now you can also use it to help us evaluate the quality of our exam questions, as we build the live exam. We appreciate your voice and welcome your feedback. Get the details, and register today.

Enjoy!

Happy Certifications!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

How to Install Active Directory for Windows 10, Windows 8 and Windows 8.1

How to Install Active Directory for Windows 10, Windows 8 and Windows 8.1

1. Download and install one of the following depending on your version of Windows:
• Remote Server Administrator Tools For Windows 10
•  Remote Server Administrator Tools For Windows 8
•   Remote Server Administrator Tools For Windows 8.1
2. Right-click the Start button and choose “Control Panel“. (Note: In some configurations, you may be able to skip to step 9.)
3. Select “Programs“.
4.  From the “Programs and Features” section, select “Turn Windows features on or off“.
5. Scroll down and expand the “Remote Server Administration Tools” section.
6. Expand “Role Administration Tools“.
7. Expand “AD DS and AD LDS Tools“.
8. Ensure that “AD DS Tools” is checked, then select “OK“.
9. You should have an option for “Administrative Tools” on the Start menu. From there, select any of the Active Directory tools.

     Tag: How to Install Active Directory for Windows 10, How to Install Active Directory for Windows 8 and How to Install Active Directory for Windows 8.1

Happy AD! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Installing Dynamics 365 Finance and Operation On Premises AKA Dynamics 365 Enterprise Server Hardware Sizing

Dynamics 365 Enterprise Server Hardware Sizing

Installing Dynamics 365 Finance and Operation On-Prem(Premises) AKA Dynamics 365 for Finance and Operations (on-premises)

People around the world are asking me this question for Installing the Dynamics 365 Finance and Operation On-Prem(Premises), well this was not so easy.

Let's discuss that what will be the Hardware needed and how much VM's will be used as this is the question which is asked by Customer Company to the Microsoft Partner Company.

Please check the excel sheet for the same.





Steps by Steps Installing Dynamics 365 Finance and Operation On-Prem(Premises)

Happy D365ing for FO!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

DevOps Ebook,DevOps for Dummies,DevOps Dumps,Putting the Ops in DevOps for Dummies

DevOps Ebook, DevOps for Dummies, DevOps Dumps, Putting the Ops in DevOps for Dummies,
Insights into the mix of technology trends, processes, and best practices, and IT organizations and role shifts impacting DevOps.


DevOps is the combination of cultural philosophies, practices, and tools that increase an organization’s ability to deliver applications and services at high velocity: evolving and improving products at a faster pace than organizations using traditional software development and infrastructure management processes. This speed enables organizations to better serve their customers and compete more effectively in the market.

Free copy download for the link!

Happy DevOpsing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Financial Reporting for Dynamics AX 2012. Management Reporter

Financial Reporting for Dynamics AX 2012. Management Reporter – your financial reporting solution for Dynamics AX. Management Reporter Benefits. Direct integration with general ledger; Custom financial reports to fit your business; Dynamic report layouts reduce maintenance


PPT: Powerpoint for Management Report AX 2012

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Kill online user in Dynamics AX 2012

Kill online user in Dynamics AX 2012

How to Kill online user in Dynamics AX 2012?

Solution:

Stop AOS

Open SQL

truncate table SysServerSessions

truncate table SysClientSessions

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

The model store has been modified, How to skip The model store has been modified dialog in AX 2012

The model store has been modified,
How to skip The model store has been modified dialog in AX 2012

Issue:

The model store has been modified,

How to skip The model store has been modified dialog in AX 2012

AX: AX 2012 R3
OS: Windows Server 2012 R2
SQL: SQL 2014

Solution:

Well, we have three solutions:


The easiest way to get rid of it to uncheck the MinorUpgrade checkbox on the ReleaseUpdateConfiguration table. Close the Client and start it again.

You can also alternatively create a job that runs SysCheckList_Update::finalizeMinorUpgrade();

as below:

static void Job11(Args _args)
{
    SysCheckList_Update::finalizeMinorUpgrade();
   
   }


You can also use this  "Set-AXModelStore NoInstallMode" via Power Shell

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Microsoft Dynamics AX 2012 Performance monitoring and Diagnostic Tools

Microsoft Dynamics AX 2012 Performance monitoring and Diagnostic Tools


Please find the below diagnostics tools for performance monitoring w.r.t AX 2012 and above>

1. Trace Parser (https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/perf-test/trace-parser)
2. Performance Monitor (https://technet.microsoft.com/en-us/library/cc961845.aspx)
3. AX Diagnostic Framework Tool (https://community.dynamics.com/ax/b/brandongeorge/archive/2013/01/08/microsoft-dynamics-ax-diagnostic-framework-beta)
4. Performance Analyzer for Microsoft Dynamics AX (DynamicsPerf) (https://blogs.msdn.microsoft.com/axinthefield/dynamicsperf-2-0-deployment-guide/)
5. Life Cycle Services (https://lcs.dynamics.com/Logon/Index)
6. Intelligent Data Management Framework (IDMF) (https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/lifecycle-services/ax-2012/overview-idmf)
7. System Center Operations Manager Monitoring Pack for Microsoft Dynamics AX 2012 (https://www.microsoft.com/en-in/download/details.aspx?id=26934)
8. Performance Analysis of  Logs (https://archive.codeplex.com/?p=pal )

On the SQL side, we can see

1. Activity Monitor
2. Extended Events
3. Management Data Warehouse

Windows Server Performance Tools

1. Disk Defragmentation
2. Disk Cleanup
3. Event Viewer
4. Memory Utilization
5. Performance monitor
6. Memory cleaner
7. Debugdiag
8. Windbg

Network Performance Tools

1. Packet analyzer
2. Performance monitor
3. Command Prompt
4. Firewall
5. Task Manager
6. Router & Switch
7. Network Monitoring
8. Wireshark (https://www.wireshark.org)
9. Fiddler

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

The requested Workflow action failed

The requested Workflow action failed


Issue: The requested Workflow action failed

I got following error "The requested workflow action failed." when I click on Email Approval link!


AX: AX 2012 R3
OS: Windows Server 2012 R2
SQL: SQL 2014

Solution:

I followed the two steps:

1. Redeploy SysWorkflowApprovalServices and SysWorkflowApprovalServiceGroup

We can do this in AOT (ctrl+d) then got to service groups and 

Go to SysWorkflowApprovalServices and 

SysWorkflowApprovalServiceGroup

right click on it and click Redeploy one by one.

and 

2. Deactivate and Activate EmailApprovalServices (It might of different name in your company)

Go to Microsoft Dynamics AX, click System Administration > Services and Application integration framework > Inbound ports look for EmailApprovalService Deactivate and  Activate again and re-test!

Bingo!

Its fixed,

Happy DAXing! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

The web browser running the add-in is not allowing access to local or session storage. Please adjust the environment and consult the support pages if necessary.

The web browser running the add-in is not allowing access to local or session storage. Please adjust the environment and consult the support pages if necessary.

Note – You must need to get help from IT if you don’t have administrator rights on your computer.

Also, we can get this scripted to run at system startup.

Error –

When the user clicks on “open with Excel” on D365,  Excel gives the error.

"The web browser running the add-in is not allowing access to local or session storage. Please adjust the environment and consult the support pages if necessary."

Resolution –

Go to windows and search for command prompt window by typing “cmd”.

Right-click and “Run as administrator”

Copy below line and paste it inside command prompt

icacls %userprofile%\Appdata\LocalLow /t /setintegritylevel (OI)(CI)L

Hit “Enter” and you should get the message.

Refresh D365 browser before exporting data to excel.

Happy D365ing!

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit 

Today I Passed the Microsoft MB2-708 Microsoft Dynamics CRM Installation!

Today I Passed the Microsoft MB2-708 Microsoft Dynamics CRM Installation!

Preparing for MB2-708 Microsoft Dynamics CRM Installation Exam:

MB2-708 is Microsoft Dynamics CRM 2015 Installation certification with the focus on On-Premise setup.

I remember I was in Singapore, I was here to install Microsoft Dynamics AX 2012 R3 CU 8, eventually, I came to know that I need to install Microsoft Dynamics CRM 2015.

This was a big tricking one, however, I made it work and later I thought of giving the exam.

It also covers working with relevant technologies, techniques, and tools such as Email Router, Deployment Manager, Active Directory, Federation, SQL Server, VSS, Network Load Balancing, etc.

You should check Exam MB2-708  for more details.

Happy CRM Infra! 

Thanks & Regards,

Umesh Pandit

https://msdynamicsaxtips.blogspot.com

Mail ID: pandit.umesh@hotmail.com

Skype ID: pandit.umesh

https://www.youracclaim.com/users/umeshpandit