Microsoft Dynamics Products Tips and News!
Tips and News on Microsoft Dynamics AX\365\CRM\NAV\GP\POS\RMS Administration, Technical and Functional!
Search This Blog
Google Website Translator Gadget
Sunday, June 23, 2024
Cost to use Microsoft Dynamics 365 by Umesh Pandit
Thursday, June 6, 2024
How to connect to Azure SQL with SSMS and Azure Data Studio!
Steps to connect to Azure SQL via Azure Data Studio and SQL Server Management Studio (SSMS):
Azure Data Studio:
1. Open Azure Data Studio on your PC.
2. Click on the New Connection button or select New Connection from the New dropdown.
3. In the Connection window, provide the following details:
- Connection type: Choose the connection type as SQL server.
- Server: Specify the server name of your Azure SQL. You can find the server name by navigating to the Azure SQL database in the Azure Portal.
- Authentication type: Choose SQL Login as the authentication type.
- Username and Password: Specify the Username and password you specified during the Azure SQL database creation in the Azure Portal.
4. Finally, click on the Connect button.
Note: you might need to create a new firewall rule if your server doesn't have one allowing Azure Data Studio or SSMS to connect.
Video:
https://youtu.be/2WckcGF8sFI
More info: https://www.linkedin.com/pulse/how-connect-azure-sql-ssms-data-studio-dr-umesh-pandit-0dasc/?trackingId=6O3%2Fm1TvQTO53PccwBmJ7g%3D%3D
Conquer Your Azure SQL with These Powerful Tools!
Ever need to manage your Azure SQL Database but unsure where to start? Look no further! This post will help you connect to your Azure SQL with SQL Server Management Studio (SSMS) and Azure Data Studio. Let me know in the comments below if you have any questions! #Azure #SQLServer #Database #SSMS #AzureDataStudio #AzureSQL #DatabaseAdministration #DataManagement #CloudDevelopment #MicrosoftAzure #SQLServerManagementStudio #ToolsforAzure #DatabaseConnection
Tuesday, April 11, 2023
Error Session ID ffe5687d-5f46-48bc-b1a6-fd17fdfa2d0f Search timestamp 2023-04-11T08:39:40.118Z 2.0.173.1006-46280275-hotfix at ProdWest3 Lifecycle Services cannot perform the current {0} operation. Received null or empty value for parameter {1}. If the issue persists, please contact support with this Id: 823edc00-9ddd-41ce-8d30-15eafcc82904
Error
Session ID ffe5687d-5f46-48bc-b1a6-fd17fdfa2d0f
Search timestamp 2023-04-11T08:39:40.118Z
2.0.173.1006-46280275-hotfix at ProdWest3
Lifecycle Services cannot perform the current {0} operation. Received null or empty value for parameter {1}. If the issue persists, please contact support with this Id: 823edc00-9ddd-41ce-8d30-15eafcc82904
The error message "Lifecycle Services cannot perform the current {0} operation. Received null or empty value for parameter {1}" indicates that a required parameter for a specific operation in the Lifecycle Services (LCS) application is missing or empty. LCS is a cloud-based collaboration platform used to manage Microsoft Dynamics 365 implementations.
This error message suggests that the operation you are trying to perform in LCS is missing a required parameter. This could be due to a variety of reasons, such as incorrect input or data format, a problem with the application itself, or a connectivity issue.
To resolve this error, you may want to try the following steps:
Verify that all required fields are filled in correctly.
Check that you have a stable internet connection and that your browser is up to date.
Try logging out of LCS, clearing your browser's cache and cookies, and then logging back in.
If the error persists, you may want to contact Microsoft support for further assistance.
It's worth noting that the specific steps to resolve this error may vary depending on the context and details of the operation you're attempting in LCS.
Sunday, December 18, 2022
The settings for connection encryption or server certificate trust may lead to connection failure if the server is not properly configured
The settings for connection encryption or server certificate trust may lead to connection failure if the server is not properly configured.
You may face this error while exporting or importing DB files.
Use command ;
SqlPackage.exe /Action:Import /TargetServerName:"localhost" /TargetDatabaseName:"Testbackup" /TargetTrustServerCertificate:True /SourceFile:"C:\Temp\testbackup.bacpac" /p:CommandTimeout=6200
For export just add at end of your original command: /TargetTrustServerCertificate:True
#export #import #bacpac
Monday, July 11, 2022
D365FO Database movement from T1 to T2 known as Golden configuration promotion
D365FO Database movement from T1 to T2 known as Golden configuration promotion
Tire 1 to Tire 2 movement of database in D365FO
Generally this is needed when you move Golden configuration which is hosted in T1 (Tire 1) and you wish to get in T2 (Tire 2) or UAT then these steps are needed.
You can also view:
Step 0: Download the RPD file from LCS
Step 1: After login, open SSMS
Step 2: Backup AxDB as AxDBforUAT.bak
Step 3: Create a new DB in SSMS as AxDBforUAT
Step 4: Restore the DB backup taken at step 2.
once the backup is restored on AxDBforUAT
run this query Step 5:
update sysglobalconfiguration
set value = 'SQLAZURE'
where name = 'BACKENDDB'
update sysglobalconfiguration
set value = 1
where name = 'TEMPTABLEINAXDB'
drop procedure if exists XU_DisableEnableNonClusteredIndexes
drop procedure if exists SP_ConfigureTablesForChangeTracking
drop procedure if exists SP_ConfigureTablesForChangeTracking_V2
drop schema [NT AUTHORITY\NETWORK SERVICE]
drop user [NT AUTHORITY\NETWORK SERVICE]
drop user axdbadmin
drop user axdeployuser
drop user axmrruntimeuser
drop user axretaildatasyncuser
drop user axretailruntimeuser
drop user axdeployextuser
--Tidy up the batch server config from the previous environment
DELETE FROM SYSSERVERCONFIG
--Tidy up server sessions from the previous environment
DELETE FROM SYSSERVERSESSIONS
--Tidy up printers from the previous environment
DELETE FROM SYSCORPNETPRINTERS
--Tidy up client sessions from the previous environment
DELETE FROM SYSCLIENTSESSIONS
--Tidy up batch sessions from the previous environment
DELETE FROM BATCHSERVERCONFIG
--Tidy up batch server to batch group relation table
DELETE FROM BATCHSERVERGROUP
-- Clear encrypted hardware profile merchant properties
update dbo.RETAILHARDWAREPROFILE set SECUREMERCHANTPROPERTIES = null where SECUREMERCHANTPROPERTIES is not null
Step 6: Open CMD as admin
Step 7: Run:
cd C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\
Download SQL package from https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver15#windows-net-core
SqlPackage.exe /a:export /ssn:localhost /sdn:<database to export> /tf:D:\Exportedbacpac\AxDBforUAT.bacpac /p:CommandTimeout=1200 /p:VerifyFullTextDocumentTypesSupported=false
------------------------------------
explanation of the parameters
------------------------------------
ssn (source server name) – The name of the SQL Server to export from. For the purposes of this article, the name should always be localhost.
sdn (source database name) – The name of the database to export.
tf (target file) – The path and name of the file to export to. The folder should already exist, but the export process will create the file.
------------------------------------------
Step 8: Login LCS
Step 9: Project>AL> Database Backup> Upload.
Step 10: Take the current UAT Backup (Export)
Step 11: Import the AxDBforUAT.bacpac in UAT
Done
Saturday, June 11, 2022
Session on Integration of Dynamics 365 HR with Azure AD
Session on Integration of Dynamics 365 HR with Azure AD
Saturday, April 16, 2022
D365UGINDIA - Session 17 X++ programming and best practices (L100) in D365 F&O-20220416
D365UGINDIA - Session 17 X++ programming and best practices (L100) in D365 F&O-20220416
Saturday, March 12, 2022
D365 F&O Warehouse Management Overview
D365 F&O Warehouse Management Overview
#azuretalks #azure #umeshpandit #umeshpanditax #ax D365 F&O Warehouse Management Overview
D365 F&O Warehouse Management Overview #d365fo #d365
Vendor On-Boarding & Collaboration Capabilities in D365 F&O
Microsoft Azure and Microsoft Dynamics 365
#D365UGINDIA - Vendor On-Boarding & Collaboration Capabilities in D365 F&O-20220312Tuesday, September 14, 2021
Leaning Learning path for MB 800 Microsoft Dynamics 365 Business Central Functional Consultant
Thursday, July 15, 2021
How to add or provision Azure Subscription on AzureTalks by Umesh Pandit
Monday, July 12, 2021
How to pass MB340,Tips for MB340
Friday, July 9, 2021
I am out in beta: MS-740: Troubleshooting Microsoft Teams https://lnkd.in/dVziDk2 #MS740 #teamsmeetings #microsoftteams #microsoft #azure
Wednesday, May 5, 2021
Dynamics 365 Implementation Guide by “The FastTrack for Dynamics 365 team”
The FastTrack for Dynamics 365 team is excited to announce the release of its Implementation Guide, which covers the solution's entire implementation lifecycle, topic-specific reviews, case studies, and recommended practices.
Download it to your device: https://just2helpu.co.in/dynamics-365-implementation-guide/ #ImplementationGuide #Dynamics365 #Dynamics365implementationGuide #microsoftdynamics365 #microsoft #FastTrackforDynamics365 #FastTrack
Sunday, March 21, 2021
MCT Resources & Benefits - Updated July 2020
MCT Resources & Benefits - Updated July 2020.pdf
https://classtestforsa.blob.core.windows.net/pdf/MCT Resources & Benefits - Updated July 2020.pdf
Wednesday, March 10, 2021
How to Create a Custom LinkedIn URL? Its a must for Microsoft Dynamics 365 and Azure Professional like Umesh Pandit
How to Create a Custom LinkedIn URL? Its a must for Microsoft Dynamics 365 and Azure Professional like Umesh Pandit
#cloud #msftadvocate #microsoft #linkedinprofiles
https://www.linkedin.com/posts/umeshpandit_how-to-create-a-custom-linkedin-url-its-activity-6775383984332386304-b-gG
Wednesday, February 10, 2021
Azure Dev Challenge:Azure Certification!Free Certification Azure free Vouchers
Check this video on how to complete #AzureDevChallenge
Microsoft Dynamics 365 Finance & Operations vs Microsoft Dynamics 365 Business Central
Microsoft Dynamics 365 Finance & Operations vs Microsoft Dynamics 365 Business Central
People now a days asking this question may be due to recent changes in their job roles or so…
So, thought of writing this blog Microsoft Dynamics 365 Finance & Operations vs Microsoft Dynamics 365 Business Central:
Microsoft Dynamics 365 Finance & Operations
Finance and Operations is a higher of AX. Just is not just like Business Central but also much bigger ERP for more functionality, it has the capability to be hosted either on prem or in the cloud. Finance and Operations is positioned as an integrated enterprise solution. It can be easily connected with other Microsoft apps like their CRM, Human Resource, Customer Service, and Marketing platforms. In addition, it comes with modular capabilities allowing users to pick only the apps and features they need.
Business Functionality
1. In Finance
2. Organization Administration
3. General Ledger
4. Cash and Bank Management
5. Accounts Payable
6. Accounts Receivable
7. Accounting
8. Credit and Collections
9. Budgeting
10. Consolidations
11. Cost Management
12. Fixed Assets
13. Expense Management
14. Tax
15. Audit Workbench
In Supply Chain Management (Operations)
1. Product Management
2. Inventory Management
3. Procurement and Sourcing
4. Production Control
5. Warehouse Management
6. Fleet Management
7. Transportation Management
8. Master Planning
9. Vendor Portal
Main Benefits of Dynamics Finance & Operations
1. Use PowerApps and Flow to optimize employee productivity as well as simple integration to Office 365
2. Enable sales and customer service people to have real time information at their disposal. Therefore, offer better customer service and drive more data driven sales
3. Real time at-a-glance dashboard that gives a high-level company overview
4. Adapt to a rapidly changing market with agile and efficient manufacturing operation automaton capabilities
Microsoft Dynamics 365 Business Central
Business Central is a higher version of NAV. It comes with
all the functionalities of NAV, but now users have the option to have their solution
on premises or hosted in the cloud (Off course Microsoft Azure). Microsoft Dynamics
365 Business Central technically has the same code base as NAV, it comes loaded
with new functionalities and a more user-friendly UX.
Business
Functionality
1.
Finance
2.
Sales
3.
Purchasing
4.
Inventory
5.
Project Management
6.
Fixed Assets Overview
7.
Relationship Management
8.
Human Resources
9.
Production Planning
10.
Assembly Management
11.
Manufacturing
12.
Warehouse Management
13.
Service Management
14.
General Business Functionality
15.
Local Functionality
Microsoft D365BC
delivers integrated functionality to provide support for:
1.
Financial management
2.
Supply chain management
3.
Relationship management
4.
Human resource management
5.
Project & Resource management
6.
Warehouse management
7.
Service Order Management
8.
Manufacturing
Main Benefits of
Dynamics Business Central
1.
Provides easy financial management by connecting
data across business functionalities like accounting, sales, and purchasing, as
well as including data from customer interactions
2.
Has built-in intelligence functions that predict
when a specific SKU need to be restocked.
3.
Allows the use of timesheets which help deliver
projects on time and under budget.
4. Can prioritize sales leads based on revenue potential, therefore leading to an optimized sales cycle.
Sunday, December 20, 2020
AZ-303 passed! AZ-303 Microsoft Azure Architect Technologies
Tuesday, December 8, 2020
How to Pass MB-800: Microsoft Dynamics 365 Business Central Functional Consultant Exam
How to Pass MB-800: Microsoft Dynamics 365 Business Central Functional Consultant Exam
Skills Measured
Set up Business Central (20-25%)
Create and configure a new company
Manage security
Set up core app functionality
Set up dimensions
Set up and manage approvals by using workflows
Configure sales and purchasing (10-15%)
Set up inventory
Configure master data for sales and purchasing
Configure pricing and discounts
Configure financials (25-30%)
Set up the Finance module
Configure the chart of accounts
Set up posting groups
Set up journals and bank accounts
Set up accounts receivables
Perform Business Central operations (30-35%)
Perform basic tasks in Business Central
Purchase items
Sell items
Process financial documents
Process payments and journals
Manage inventory costing
Details on what to read? https://query.prod.cms.rt.microsoft.com/cms/api/am/binary/RE4CxSE
Read online from https://docs.microsoft.com/en-us/learn/certifications/exams/mb-800?tab=tab-learning-paths
Cost to use Microsoft Dynamics 365 by Umesh Pandit
Cost to use Microsoft Dynamics 365 by Umesh Pandit Understanding the cost of using Microsoft Dynamics 365 can be complex, as it depends on v...