Installing a Dynamics CRM 2013 Update

To install a Dynamics CRM 2013 update, you will need to go through the following steps. I will be demonstrating on a Dynamics CRM 2013 On Premise installation. Take a snapshot of your CRM environment. You will want to test the installation first on a DEV environment and make sure your customizations are working as expected after the update has been installed. Go to the Dynamics CRM 2013 updates page, located … Continue reading Installing a Dynamics CRM 2013 Update

Dynamics GP Dexterity User Security Tables

The following are useful Dynamics GP tables regarding security: SY09000 – sySecurityMSTRTask – Security Tasks Master SY10600 – Security Assignment Role Task – sySecurityAssignTaskRole SY09100 – Security Roles Master – sySecurityMSTRRole SY10500 – Security Assignment User Role – sySecurityAssignUserRole SY01500 – Company Master – SY_Company_MSTR  

How to Change the Company Logo in Dynamics AX

The company logo in Dynamics AX is used in different areas such as reporting. To change the company logo, go to the Organizational administration page and select Legal Entities. Then, select the legal entity that you would like to add or change a logo, and click “Company Logo”: Click Change or Remove to add/remove a logo:  

Installing Microsoft SQL Server AdventureWorks Sample Data

Microsoft provides sample SQL Server databases called AdventureWorks. You can download the files from the CodePlex website for your relevant SQL Server version here –  You can then attach the databases to your SQL Server instance. To do this, copy the files to a location on the SQL Server and run the following command: CREATE DATABASE [AdventureWorks2012] ON (FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf’) FOR ATTACH_REBUILD_LOG GO CREATE DATABASE [AdventureWorksDW2012] ON (FILENAME … Continue reading Installing Microsoft SQL Server AdventureWorks Sample Data

C# – Inheritance

Carrying on from our previous transport post, we currently have a car class that has some properties. However, a car is a type of vehicle. What if we wanted to expand to other types of vehicles in our solution? Let’s add a vehicle class. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; namespace Transportation {     class Vehicle     {     } } Now, as we shoudn’t create an object out of “vehicle”, we will define this as an abstract class: using System; using System.Collections.Generic; using System.Linq; … Continue reading C# – Inheritance

C# – Classes

In this example and series of examples, I will go through some object oriented and C# concepts. We will use an example of building a transport system, using Cars as an example. First, create a C# project for a class library called “Transportation”. Also, let’s create a new console application called Carl.TestTransportation. We will use that to test our class working.   Let’s star with characteristics of a car. Cars have: Make. E.g. Ferrari … Continue reading C# – Classes

Hello World Console App C#

Creating a console application in C# is really easy. Let’s go through a Hello World example. First, create a new project in Visual Studio. Give the project a name: The project contains a Program.cs file, which contains a static Main method: This method will be called first when the application is run – it is the entry point of the application. It is static and declared as a class or … Continue reading Hello World Console App C#

How to Build SSRS Reports in Dynamics AX

In this post I will show how to build SSRS reports in Dynamics AX 2012 R3. Let’s modify the Purchase Order Report. Firstly, open Visual Studio and make sure the Application Explorer is open (View->Application Explorer): Expand SSRS Reports and find the Purchase Order Report: Double click the report to open it and create a new SSRS project. Rename the project from the generic name it provides to something more … Continue reading How to Build SSRS Reports in Dynamics AX

Installing the eConnect 10 SDK

To install the eConnect 10 SDK, download the eConnect SDK from the Microsoft website. Then, extract the ZIP file. You will see 2 files: Run the eConnectSdk.exe. Select the components you want to install: Enter your service credentials: You will see this success message: Once installed, you will see files located at: C:\Program Files (x86)\Common Files\microsoft shared\eConnect 10  

Finding eConnect 9.0 Version Info

To find the version of an eConnect 9.0 installation, in Windows search for eConnect Release Information: This will open the window: Use the elipse to open the database connection: Click OK and you will see the version information: