Dynamics 365 Archives - Page 2 of 6

D365FO Meetup, 2023 February, Budapest

It has been a long time since we could meet in person due to the Covid lockdown. I am happy to announce that we are going to have our D365FO Meetup at Microsoft headquarters in Graphisoft park, Budapest on the 16th of February 2023, thanks to András Strén (SR Product Marketing Manager@Microsoft, CEE area).

D365FO Meetup

We are going to cover the following topics with my colleague, Péter Prokopecz on this D365FO Meetup:

Dynamics 365 FinOps integrations:
- Possibilities for integrations
- Replacements of AX 2012 technologies within D365
- What should be considered when choosing a platform for our integrations in the cloud?
Advanced D365 developer tooling and technologies:
- Did you have no time to catch up with the changes in the most recent platform builds?
- Would like to know in which direction is Microsoft taking the developer tooling?
- You want to know how to use SocrateX/BaseX/AppChecker?
- Did you always want to see how to create a Visual Studio add-in to automate tasks and expand the functionality of the developer IDE?
- What is in the d365fo.tools that the community is building?

Language for the sessions: Hungarian.

By DAXRunBase|2023-02-13T09:46:12+01:00February 13th, 2023|Categories: Dynamics 365 for Finance and Operations, MSDyn365FO|Tags: #MSDyn365FO, Dynamics 365, meetup|0 Comments

Career day speaker at Mensa HungarIQa

The Mensa high IQ society in Hungary has started a series of sessions dedicated for showing the various IT professions in detail on a career day. As a proud member of the society I have the pleasure to show what do I do as Software Engineer and Solution Architect for Enterprise Resource Manager systems, what are my day-to-day activities with Microsoft Dynamics AX 2012 and Dynamics 365 Finance and Operations.

This series of events are organized in order to help people who are just about to make the decision of their life about what to become when they graduate after high school. This is also to aid people, who are considering a career change. As a Mensa HungarIQa career day speaker my task is to talk about what skillsets are required to be successful in this corner of IT, what are the advantages and difficulties chasing a path like this in the industry, what perks and benefits do we get.

I also plan to demonstrate a range of tools that we use on a daily basis to show how wide range of knowledge one has to have that can be applied to a multitude of other jobs in case they consider a switch again:

business processes (finance, supply chain, distribution, manufacturing, etc.)
DevOps / Version control
Visual Studio development
Microsoft Azure
Virtualization and systems management / monitoring
Artificial Intelligence and Machine Learning models
Web technologies (REST, OData, etc.)
and others…

By DAXRunBase|2023-03-19T19:46:36+01:00January 5th, 2023|Categories: Dynamics 365 for Finance and Operations, Microsoft Dynamics AX, MSDyn365FO|Tags: #MSDyn365FO, Dynamics 365, Mensa, speaker|0 Comments

Find tables without cacheLookup property set

During the cleanup exercise of our code upgrade to Dynamics 365 Finance and Operations we have noticed that many of our custom tables did not have the cacheLookup configured. It can have a negative performance impact on your system, so it is best practice to have this properly configured. You can find below a job to find tables without cacheLookup property set.

You can find more details about caching in the documentation:

https://docs.microsoft.com/en-us/dynamicsax-2012/developer/single-record-caching

It is going to create a new project, with all the tables which were created on the CUS layer, that you need to verify.

static void WIK_findTablesWithoutCache(Args _args)
{
    #AOT
    #AOTExport
    #AviFiles
 
    ProjectName             projectName = "TableCache";
    TreeNodeIterator        tni     = TreeNode::findNode(#TablesPath).AOTiterator();
    TreeNode                node;
    ProjectNode             projectNode;
    SysDictTable            dictTable;
    Common                  common;
    int                     cnt;
    int64                   recordCount;
    int64                   counter;
    SysOperationProgress    pr = SysOperationProgress::newGeneral(#AviUpdate, 'Processing treenode', 0);
 
    void addTreeNodeToProject(TreeNode _node)
    {
        TmpIdRef        tmpIdRef;
 
        tmpIdRef.clear();
        tmpIdRef.Name = SysTreeNode::getPath(_node);
        tmpIdRef.Mode = SysTreeNode::path2ApplObjectType(tmpIdRef.Name);
        tmpIdRef.useMode = UtilFileType::Application;
        tmpIdRef.insert();
 
        SysProjectFilterRunBase::addProjectNodes(tmpIdRef, projectNode);
    }
 
    projectNode    = infolog.projectRootNode();
    projectNode    = projectNode.AOTfindChild(#expProjectprivate);
    projectNode    = projectNode.AOTfindChild(projectName);
 
    if( !projectNode)
    {
        projectNode = SysTreeNode::createProject(projectName, ProjectSharedPrivate::Projprivate);
    }
 
    //projectNode.loadForInspection();
 
    tni = TreeNode::findNode(#TablesPath).AOTiterator();
    node = tni.next();
 
    while (node)
    {
        pr.incCount();
        pr.setText(node.AOTname());
 
        dictTable = SysDictTable::newTreeNode(node);
 
        if (!dictTable.isView() && !dictTable.isMap() && !dictTable.isTmp() && !dictTable.isTempDb() && !dictTable.isSystemTable()
            && dictTable.cacheLookup() == RecordCacheLevel::None
            && SysTreeNode::existsInLayer(dictTable.treeNode(), UtilEntryLevel::cus)
            && !SysTreeNode::existsInLayer(dictTable.treeNode(), UtilEntryLevel::sys)
            && !SysTreeNode::existsInLayer(dictTable.treeNode(), UtilEntryLevel::syp)
            )
        {
            counter++;
            //recordCount = dictTable.recordCount(true);
            //info(strFmt('%1 - %2 - %3', counter, dictTable.name(), recordCount));
            common = dictTable.makeRecord();
            select firstOnly RecId from common;
            if (common.RecId)
            {
                addTreeNodeToProject(node);
            }
        }
 
        node = tni.next();
    }
 
    //projectNode.treeNodeRelease();
    //projectNode.AOTrefresh();
}

By DAXRunBase|2022-03-31T19:29:32+02:00March 31st, 2022|Categories: AX 2012, Dynamics 365 for Finance and Operations, MSDyn365FO|Tags: #MSDyn365FO, AOT, AX 2012, cache, Dynamics 365, metadata, performance, tables|0 Comments

SQL record count by company

As part of our Data Upgrade from AX 2012 to Dynamics 365 Finance and Operations we had to ensure a way of telling how many records do we have per data area. Data import via entities are company-based, so we had to find out a reliable way to tell if everything has been successfully transferred. The following script can tell exactly that, show the SQL record count by company:

SET NOCOUNT ON
DECLARE @tableName NVARCHAR(255);
DECLARE @statement NVARCHAR(MAX);
 
-- Temporary table for storing record counts
CREATE TABLE #jdm_count (TableName NVARCHAR(255), Company NVARCHAR(4), RecordCount int)
 
-- Cursor for getting list of User-created tables
DECLARE cur_name CURSOR FOR
       SELECT QUOTENAME(SCHEMA_NAME(sOBJ.schema_id))
              + '.' + QUOTENAME(sOBJ.name)
       FROM sys.objects as sOBJ
       WHERE
              sOBJ.type = 'U'
              AND sOBJ.is_ms_shipped = 0x0
       ORDER BY SCHEMA_NAME(sOBJ.schema_id), sOBJ.name;
 
OPEN cur_name
 
-- Loop tables
FETCH NEXT FROM cur_name INTO @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
       -- Construct SQL Statement for getting company-specific record count
       SELECT @statement = 'SELECT ''' + @tableName + ''' AS [TableName]'
              + IIF(COL_LENGTH(@tableName, 'DATAAREAID') IS NOT NULL, ', DATAAREAID AS [Company]', ', '''' AS [COMPANY]')
              + ',COUNT(*) AS [RowCount] FROM ' + @tableName + ' WITH (NOLOCK)'
              + IIF(COL_LENGTH(@tableName, 'DATAAREAID') IS NOT NULL, ' GROUP BY [DATAAREAID]', '')
              + ' HAVING COUNT(*) > 0';
              
       -- Insert statement results in temporary table
       INSERT INTO #jdm_count (TableName, Company, RecordCount)
              EXEC sp_executeSQL @statement;
 
       FETCH NEXT FROM cur_name INTO @tableName
END
 
CLOSE cur_name
DEALLOCATE cur_name
 
-- Display results
SELECT * FROM #jdm_count
ORDER BY RecordCount DESC, TableName, Company
 
DROP TABLE #jdm_count
SET NOCOUNT OFF

By DAXRunBase|2022-03-31T19:18:47+02:00March 31st, 2022|Categories: AX 2012, Dynamics 365 for Finance and Operations, MSDyn365FO|Tags: AX 2012, Dynamics 365, SQL, tables|0 Comments

Identify tables to migrate

When we have decided to use a Data migration instead of a Data upgrade to D365FO we had to come up with a way to identify tables to migrate.

The AX developer client already has a form under Tools > Number of records, which can tell you how many rows does a table have. This form can be easily expanded to include additional information. The most useful are the table type, and the application layer.

You would typically want to migrate all tables which belong to the following Table groups:

Parameters
Group
Main

This is how you can add the table type display method and control to the SysTableRowCount form to identify tables to migrate:

//BP deviation documented
display TableGroup getTableGroup(UtilIdElements _utilIdElements)
{
    SysDictTable sysDictTable = SysDictTable::newName(_utilIdElements.name);

    if (sysDictTable)
    {
        return sysDictTable.tableGroup();
    }

    throw error(strfmt("@SYS19384", classstr(SysDictTable)));
}

By DAXRunBase|2022-03-31T19:06:37+02:00March 31st, 2022|Categories: AX 2012, Dynamics 365 for Finance and Operations, MSDyn365FO|Tags: AOT, AX 2012, Dynamics 365, metadata, migration, tables, X++|0 Comments