Dynamics 365 for Finance and Operations Archives - Page 2 of 8

DMF TransferStatus to check entity processing

When we work with a Data Entity in D365FO, it can get tricky to track how transfers are going and how much is left. Here is a quick SQL snippet to query staging tables to figure out DMF TransferStatus:

select
  executionid,
  transferstatus,
  case
    when transferstatus = 0 then 'Not started'
    when transferstatus = 1 then 'Completed'
    when transferstatus = 2 then 'Error'
    when transferstatus = 3 then 'Validated'
    when transferstatus = 4 then 'Duplicate'
  end AS StatusTxt,
  count(*) from [dbo].[CUSTCUSTOMERV3STAGING]
group by executionid, transferstatus

This snippet can tell us how many records have been completed, has an error, or still remaining to be processed. It only works if a staging table is being used for the data entity export/import.

By DAXRunBase|2023-03-19T20:30:33+01:00March 19th, 2023|Categories: Dynamics 365 for Finance and Operations, MSDyn365FO|Tags: #MSDyn365FO, Data Entity, DMF, Dynamics 365, SQL|0 Comments

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

Active record count in ValidTimeState tables

In the previous blog post we have explored how to tell how many records do we have per company account using a T-SQL Query. But AX does have a concept which SQL cannot cope with, and makes it a bit harder to tell the active record count in ValidTimeState tables.

SQL record count by company

The following job can pull back this value for us, in order to validate if data migration row counts are matching between AX 2012 and D365FO.

static void WIK_findValidTimeStateKey_Tables(Args _args)
{
    DictTable           dictTable;
    Dictionary          dict = new Dictionary();
    TableId             tableId;
    Common              common;
    date                currentDate = systemDateGet();
 
    setPrefix('Record count for ValidTimeStateKey tables');
    tableId = dict.tableNext(0);
 
    while (tableId)
    {
        dictTable = new DictTable(tableId);
        if (!dictTable.isTmp() && !dictTable.isTempDb() && !dictTable.isView()
            && (dictTable.configurationKeyId() ? isConfigurationKeyEnabled(dictTable.configurationKeyId()) : true)
            && dictTable.isValidTimeStateTable())
        {
            common = dictTable.makeRecord();
            select validTimeState(currentDate) count(RecId) from common;
 
            if (common.RecId)
            {
                info(strFmt('%1\t%2', dictTable.name(), common.RecId));
            }
        }
 
        tableId = dict.tableNext(tableId);
    }
}

By DAXRunBase|2022-03-31T19:42:32+02:00March 31st, 2022|Categories: AX 2012, Dynamics 365 for Finance and Operations, MSDyn365FO|Tags: #MSDyn365FO, AX 2012, migration, SQL, tables, X++|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