Explore Dynamics World With Aslam : July 2018

Monday, 30 July 2018

Dynamics-AX-Integration in D365

Installing Security Development Tool for AX 2012 R3

Today I am installing the Security Development Tool in one of our lab environments. First of all, you need to download the tool from LifeCycle Services.

When you have the file MSI file it is time to do the install

1. Start by running the msi file… this is an extremely short install which seems to do nothing… but that is OK

2. When the mis install is done start Microsoft Dynamics AX 2012 Management Shell as an elevated user and run the following

Install-AXModel -File “c:\Program Files (x86)\Microsoft\Security Development Tool\SecurityDevelopmentTool.axmodel”

3. Start the AX client and you will get a message that the Model store has been modified. Select Compile and Syncronize and wait for the process to complete

4. When AX is done compiling and syncing start the AOT (by pressing Crtl + D)

5. Browse to the Class called SysSecEntryPointmanagerSetup, right-click and select Open

6. Restart the AX client

7. When the client is restarted go to Administration and click Security entry point permissions

Note: You might get an error that the tool can only be run in Single-User session mode. In that case go to Administration – Online users and disconnect all users except your own

Sunday, 29 July 2018

Basics in Microsoft Dynamics 365 operations

Basics Developments in Microsoft Dynamics 365 operations:

• Introduction to Visual Studio

• Architecture

• Labels and Resources

• Base Enumerations

• Extended Data Types

• Tables

• Table Indexes

• Table Relations

• Form Patterns

• Form Creation

• Menus

• X++ Overview

• Classes

• Database Manipulation

• Exception Handling

• Security Basics

• Introduction to Advanced Topics

Point 1:

Point 2:

Point 3:

Point 4:

Point 5:

Point 7:

Advance Concept in Microsoft Dynamics 365 Finance and Operations

Table of Content

Module 1: Extensibility

• Introduction

• Overlayering

• Extensions

• Extension models and packages

• Development tools support

• Lab 1.1: Add new field and class to existing form

Module 2: Unit Test Framework

• Introduction

• Creating Test Cases

• Adding methods to Test Cases

• Running Test Cases

• Lab 2.1: Create a Test Case

Module 3: Advance Classes

• Introduction

• Collection Classes

• Application Object Classes

• SysOperation Framework

• Runbase Framework

• Args Object

• Lab 3.1: Create a Map

• Lab 3.2: Create Runbase Class

• Lab 3.3: Using Args Object

Module 4: Advance Data Manipulation

• Introduction

• Querying

• Caching and Locking

• Tables

• Views

• Lab 4.1: Build a Query in X++

• Lab 4.2: Create and Copy Data between Temporary Tables Using X++

Module 5: Advance Forms

• Introduction

• Architecture

• Methods

• Data Sources

• Design

• Handles to the Objects in a Form

• Form Controls

• Additional Controls

• Lab 5.1: Create a form

• Lab 5.2: Use Unbound Controls

• Lab 5.3: Initialize a Form

• Lab 5.4: Add an Image control

Module 6: Number Sequence

• Introduction

• Overview

• Supported Scopes

• Set Up and Administration

• Set up Number Sequences

• Lab 6.1: Implement a new Number Sequence

Module 7: Extensible Data Security

• Introduction

• Overview

• Concepts

• Lab 7.1: Creating Security Policy

Module 8: Workflow

• Introduction

• Workflow Configuration

• Create a Workflow Category

• Create a Query

• Create a Workflow Type

• Enable Workflow On a Form

• Create a Workflow Approval

• Create Event Handlers

• Author a Workflow

Module 9: Data Entities

• Introduction

• Data Entities

• Building a Data Entity

• Using a Data Enitity

• Composite Data Entity

• Developing Composite Data Entity

• Set Based Data Entities

• Developing a Set Based Entity

• Lab 9.1: Create a Data Entity

• Lab 9.2: Access Data using X++

• Lab 9.3: Create a Composite Entity

• Lab 9.4: Create a Set Based Data Entity

Module 10: Analytics

• Introduction

• Aggregate Measurements

• Aggregate Dimension

• Key Performance Indicator

• Aggregate Data Entities

• Lab 10.1: Create an Aggregate Measurement and Data Entity

• Lab 10.2: Enable OData Access for Aggregate Data Entity

• Lab 10.3: Creating and using key performance Indicators

Module 11: Data Management Platform

• Introduction

• Data Management Platform

• Basic Import and Export

• Working with Data Management Platform

• Asynchronous Recurring Integration

• Lab 11.1: Basic Import and Export Using the Data Management Platform

Module 12: Services

• Introduction

• Services Overview

• OData Services

• Custom and Metadata Services

• Authentication

• Lab 12.1: Using OData Services

Wednesday, 25 July 2018

How to use AxBuild tool in Ax 2012

https://axhowto.wordpress.com/2014/07/24/how-to-use-axbuild-tool-in-ax-2012-r2-cu7/

Just had my hands on AX Build tool. - CMD syntax to compile all – >

C:\>cd C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\Bin\

C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin>axbuild.exe xppcompileAll /aos=01 /workers=4

AX2012 AXUTIL commands to Import,Export,Delete Models

// creating the Model in the Layer
AxUtil create /model:"TestModel" /Layer:CUS

// exporting the model to file
AxUtil export /model:"TestModel" /file:TestModel.axmodel

// importing the model from file
AxUtil import /file:TestModel.axmodel

// delete the model
AxUtil delete /model:"TestModel"

//delete the layer
AxUtil delete /layer:ISV

// if you have multiple instances running
//delete the layer from the database and AXserver.
Axutil delete /layer:ISV /db:<database> /s:<server>

Label:
Copy all the label files from below location and place it where you want.
C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\Application\Appl\Standard
Go to ax application and import the label file from the old system.
restart the service it will be set configure every thing

Troubleshoot "Failed to log on Microsoft Dynamics" During Report Rendering

http://shafeaa.blogspot.com/2015/04/troubleshoot-failed-to-log-on-microsoft.html

https://www.dynamics101.com/creating-custom-number-sequences-microsoft-dynamics-ax-2012/

https://sukrut-axapta.blogspot.com/2017/12/integration-with-dynamics-365-for.html
https://community.dynamics.com/365/financeandoperations/b/365operationswithsukrut/archive/2017/12/03/integration-with-dynamics-365-for-operations-using-odata-proxy-generator

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/data-entities/build-consuming-data-entities

https://stoneridgesoftware.com/working-with-the-odata-endpoint-in-dynamics-365-for-operations/

https://sukrut-axapta.blogspot.com/2017/12/integration-with-dynamics-365-for.html

HTTP: https://dynamicsaxinsight.wordpress.com/2015/02/20/ax-2012-integrate-dynamics-ax-with-website/

Monday, 16 July 2018

Interview questions in dynamics 365

1. Debugging process in D365?

2. Event handlers and types?

3. What is the use of the chain of commands?

https://community.dynamics.com/365/financeandoperations/b/sertansdynamicsax/archive/2017/11/15/ax7-d365-chain-of-command-with-example

4. What is the difference between pre/post event handler and Chain of commands?

5. How to create a table in D365?

6. What kind of changes can we do in CustTable_Extension?

7. Can we add methods to Extension table? If no. why? If yes. How?

8. How to create DataEntity?

https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/data-entities/develop-composite-data-entities

9. Where do you write code for customization while importing data through DataEntity?

10. Where do you write code for customization while exporting data through DataEntity?

11. What is the difference between a virtual field and computed column?

12. Can we use event handlers on table methods?

13. Can we use event handlers on Forms?

15. EventHandlers-Pre and post events

16. How to use the delegates?

17. Calling sequence in forms?

18. Deployment options?

19. How to create the composite DataEntities?

20. Wrappable and HookableAttribute use.

21. Table Best practices?

22. Table relations?

23. Table Keys: Surrogate, Alternate, Replacement, Primary, and Foreign?

https://docs.microsoft.com/en-us/dynamicsax-2012/developer/table-keys-surrogate-alternate-replacement-primary-and-foreign

24. What is the use of View? Can we use CRUD operations in the Views? Can we use view in the reports to pull the data?

25. How to add field in the D365 Table? If we need to use extension concepts how to add it tell me the step by step process?

26. How to create workflow in D365? Is there any difference in workflow AX 2012 and D365?

27. How to use cache lookup? What is the use of that, how many type of cache lookup?

28. Why we use cluster index?

Data entities, DIXF, and Reporting:

1) SSRS reports creating a concept, classes involved

2) Data entities

3) DIXF

Data model:

1) Table creation and best practices

2) The concept of initializing fields, validating fields at both Table level and form level

3) Form design scenarios like details form, list page, list page interaction classes etc. Link types, enabling/disabling buttons on forms, filter on forms

4) Business logic:

1) Purch order cycle and related technical artifacts

2) PO product receipt posting

3) Sys operation framework

4) Troubleshooting of a production issue

Knowledge in AIF, web services

Performance optimization tools

Data entities and Reporting:

1 SSRS reports creating concept, classes involved

2 Data entities

Data model:

3. Table creation and best practices

1) Concept of initializing fields, validating fields and modifying fields at both Table level and form level

2) D365 Table creation and Extension

Business logic:

1. Customization related to macros, COC and event handlers in D365

2. Purchase agreements cycle and related technical artifacts

3. Sys operation framework

4. Workflow customization

5. Scenarios on Multi select Look up and Process

SSRS
X++ and best practices
Understanding on SYS operation framework/Batches
DIXF

deployments options

1)Best Practices of table?

2)If a form has two date fields with starting date and ending date when a user enters date in a starting date it automatically generates ending date by +7(appending it to starting date)?

3)Difference between primary index and unique index?

4)which classes are called while doing confirmation and packing slip in the process of purchase order?

5)Steps to create a data entity?

6)have you worked on services?

7)What is abstract table?

8)How did you start the process after giving the requirement?

9)Types of lookups?

10)differences between reread, execute query and refresh?

11)difference between edit and display?

12)How did you create a workflow? what are the classes that are involved while creating the workflow?

13)Have you created a custom workflow or standard workflow?subworkflows?
14)How did you give the validation to the standard table without using event handlers and validation methods?

15)chain of commands in D365? process?

16) where Do you write the code for adding fields in standard entity?

17)where do you used the data entities in your project?

18)Do you know anything about trade agreement and sales agreement?

19)Multithreading?

20)Change tracking in DIXF?

21)TFS

22)Steps to create a Report?

23)Multi select lookup with default selection?

24)Classes that are used in reports?

Tuesday, 3 July 2018

Clear Caches in Microsoft Dynamics 365 for Finance and Operations

public class GHMCClearCaches
{
public static void main(Args _args)
{
SysFlushAOD::main(new Args());
SysFlushData::main(new Args());
SysFlushDictionary::main(new Args());
}
}

Data Entity field with IsComputed field is yes in dynamics 365

IF IsComputed field is yes in dataentitys which is unbounded control fields
Change the below properties on the unbounded field level IsComputed field is yes
-Add the EDT
-Data Entity view method - GHMCRetrieveBalance
public class GHMCCustomerBalanceEntity extends common
{
/// <summary>
/// Retrieves Balance of the Customer
/// </summary>
/// <returns></returns>
public static str GHMCRetrieveBalance()
{

str balance;

balance = @'
SELECT SUM(CUSTTRANSOPEN.AMOUNTMST) FROM CUSTTRANS
join CUSTTRANSOPEN on CUSTTRANS.RecId = CUSTTRANSOPEN.RefRecId
and CUSTTRANSOPEN.DATAAREAID = T1.DATAAREAID
group by CurrencyCode,custTrans.ACCOUNTNUM
having custTrans.ACCOUNTNUM = T1.ACCOUNTNUM
';

return balance;
}

/// <summary>
/// Retrieves Current Balance
/// </summary>
/// <returns></returns>
public static str GHMCRetrieveCurrentBalance()
{

str currentBalance;

currentBalance = @'
SELECT (CREDITMAX -(SELECT SUM(ESTIMATE) FROM SALESTABLE
WHERE CUSTACCOUNT = T1.ACCOUNTNUM AND DATAAREAID = T1.DATAAREAID))
AS CURRENTBALANCE FROM CUSTTABLE WHERE ACCOUNTNUM = T1.ACCOUNTNUM
AND DATAAREAID = T1.DATAAREAID
';

return currentBalance;
}

}