How To Use D365 Batch Jobs
Aug15

How To Use D365 Batch Jobs

In this article learn to how use D365 batch jobs to automate and offload recurring tasks to the server. This will allow your employees to be more productive and save time. Learn to recognize when a process can be run as a batch job. And learn about the many processes that can be run by… Continue Reading → The post How To Use D365 Batch Jobs appeared first on Dynamics 365 Musings. Continue Reading peter.ramer’s...

Read More
How to Handle Batch Jobs When Disabling or Deleting a User in D365FO
Aug11

How to Handle Batch Jobs When Disabling or Deleting a User in D365FO

I had someone reach out to me about the ‘right’ way to handle batch jobs when disabling or deleting a user from D365FO. Let’s look at the options you have to avoid any issues. Why This is an Issue Batch jobs within D365FO allow for a way to execute a set of instructions that can be scheduled to run on a periodic basis. These are used extensively to perform business calculations and because… Continue Reading...

Read More
D365 Commerce : Omitting serialization of null and default values in JSON payloads
Aug07

D365 Commerce : Omitting serialization of null and default values in JSON payloads

I have always been interested in how to improve performance, and I have understood that there is no silver bullet or switch you just can turn to get dramatically improvements. The path towards performance is a delicate balance between functionality, usability, scalability and effort/budget. Together with friends, I think we have found some low-hanging fruits … Continue reading D365 Commerce :… Continue Reading Kurt...

Read More
Priority-based batch scheduling in Dynamics 365
Jul29

Priority-based batch scheduling in Dynamics 365

We’ve seen a lot of improvements to the product since it was released as AX7, and some name changes too 😝 And one of the areas where we’ve seen more enhancements is the batch framework. And since the currently live last version of Dynamics 365 Finance and Operations, 10.0.28, we have a new feature that […] ariste.info Priority-based batch scheduling in Dynamics 365 Continue Reading Adrià Ariste Santacreu’s...

Read More
How To View D365 Sales Order Totals
Jul18

How To View D365 Sales Order Totals

One thing that every user cares about on every single sales order is the totals. After adding all of the items to a sales order in Microsoft Dynamics 365 for Finance and Operations, the totals show you how much tax, shipping, sub-total and overall total money is owed. In this article I will show you… Continue Reading → The post How To View D365 Sales Order Totals appeared first on Dynamics… Continue Reading...

Read More
How to Use a .NET Project Within a D365FO Solution
Jul07

How to Use a .NET Project Within a D365FO Solution

I wanted to write today about why I utilize .NET projects for certain scenarios when developing X++ solutions for D365FO. How Is This Possible? How is it possible that you can have two different project types under one solution? I actually wrote about the changes that were happening to the X++ compiler way back in 2017, the change we are most interested in is that X++ code now compiles and… Continue Reading Alex’s Article...

Read More
Button search from Action Pane – D365 FO
Jul05

Button search from Action Pane – D365 FO

Finding a button in a form is difficult if it has complex design with Action pane having multiple tabs , various button groups in the tabs and so on. For instance, Sales order form. How to search the button ‘Cash flow forecasts’ in the ‘Action pane’ ? Have you noticed a search box in Action pane ? This is called ‘Action Pane Search’. It is handy in doing search in such complex… Continue...

Read More
How To Write a D365 Runnable Class (Job)
Jul04

How To Write a D365 Runnable Class (Job)

Often times as a developer you have the need to quickly write and run some x++ code in Microsoft Dynamics 365 for Finance and Operations. In this article, I will explain how to write a D365 runnable class (Job). These jobs can be used to quickly test and experiment with some code. As well as… Continue Reading → The post How To Write a D365 Runnable Class (Job) appeared first on Dynamics 365… Continue Reading...

Read More
Table Sync Failed for Table: XXXtable. Exception: System.InvalidOperationException: Table 'XXX': Converting Field 'YYY' of Type 'AxTableFieldReal' to 'AxTableFieldInt' is not supported. Please drop the original field, sync the table and add a new field with the same name if needed.
Jul03

Table Sync Failed for Table: XXXtable. Exception: System.InvalidOperationException: Table 'XXX': Converting Field 'YYY' of Type 'AxTableFieldReal' to 'AxTableFieldInt' is not supported. Please drop the original field, sync the table and add a new field with the same name if needed.

 issue: Table Sync Failed for Table: XXXtable. Exception: System.InvalidOperationException: Table ‘XXX’: Converting Field ‘YYY’ of Type ‘AxTableFieldReal’ to ‘AxTableFieldInt’ is not supported. Please drop the original field, sync the table and add a new field with the same name if needed. solution : Just Rename your field and sync your DB  or  drop the original field,...

Read More
Ho to calculate due date in x++?
Jul01

Ho to calculate due date in x++?

 class UpdateDuedate_CustAging {     public static void main(Args _args)     {         CustTrans       CustTrans;         CustInvoiceJour         CustInvoiceJour;                  ttsBegin;         while select forupdate CustInvoiceJour where...

Read More
Logs in Dynamics 365: not anymore!
Jun30

Logs in Dynamics 365: not anymore!

Let’s talk about logs in Dynamics 365 Finance and Operations. And I don’t mean the built-in database logs we’ve had since the old Axapta days. I’m talking about plain logs, a table and a form to see how/why data is changing, or logging external calls to OData or custom web services endpoints in the ERP. […] ariste.info Logs in Dynamics 365: not anymore! Continue Reading Adrià Ariste Santacreu’s...

Read More
Creating Extensions from related AOT object – D365FO
Jun24

Creating Extensions from related AOT object – D365FO

From PU50, it is now easy to create extension from related AOT object. Earlier, the approach was to create a class and then fill out details if it for table or class or data entity. Below pic shows creating form extension Below one shows Code extension for the form field. table extension Continue Reading AnithaEswaran’s Article on their blog Creating Extensions from related AOT object – D365FO From PU50, it is now easy to...

Read More
Date format issue in ‘Execute a SQL Query (V2)’ logic apps – D365FO integration
Jun22

Date format issue in ‘Execute a SQL Query (V2)’ logic apps – D365FO integration

I had already explained about using sql query execution in my earlier blog posts. Recently I had another issue when using date column in the select list . For instance, in the below screenshot one of the field in the select list had Date column. If you observe the output, result in the date columns will be in a different format. The execution was successful in logic apps, but… Continue Reading AnithaEswaran’s Article on...

Read More
Dynamics 365 and the illusions of competence
Jun20

Dynamics 365 and the illusions of competence

The Dynamics 365 community is flooding over with excellent articles, video’s, blogposts and learning services, and I enjoy learning new stuff. When I consume the shared content, I feel that I really understand the concept and that it increases my competency. My “knowledge ego” bolster and I feel have a deep understanding on new subjects … Continue reading Dynamics 365 and the illusions… Continue Reading...

Read More
An Update to ‘Creating a Read Only Role for D365FO – User Interface’
Jun20

An Update to ‘Creating a Read Only Role for D365FO – User Interface’

I had a comment on one of my blog posts that Microsoft had updated the functionality that existed to help create a read only role from the D365FO user interface so I wanted to show how much easier it is to perform this process now. In my previous post, I showed how you had to manually manipulate an XML file and use regular expressions find/replace to achieve the desired security file to be… Continue Reading Alex’s Article...

Read More
Default location of VS Projects ,instead of repos folder : D365FO
Jun18

Default location of VS Projects ,instead of repos folder : D365FO

I noticed in all the FO VMs, the project location has been set to ‘repos’ folder. . Though this set up doesn`t pose any errors,it is always a best practice to save the projects in its location where the TFS is configured. The set up for default location of VS projects during creation is in Tools -> option . Click Ok and restart the VS and you will see the change upon creating a… Continue Reading...

Read More
Alphabetical ordering of Labels in D365FO
Jun18

Alphabetical ordering of Labels in D365FO

We usually append the new labels at the end of the label file. It is difficult to search the label in case if we need to check if the label exists already. From PU50, it is possible to arrange the labels in alphabetical order with a simple set up in Visual studio. Go to Tools Option and select the following option Continue Reading AnithaEswaran’s Article on their blog Alphabetical ordering of Labels in D365FO We usually append...

Read More
Issue With FieldObject Method on DictTable Class in D365FO
Jun09

Issue With FieldObject Method on DictTable Class in D365FO

I recently ran into an interesting issue with using the FieldObject() method on the DictTable class when programming in X++ for D365FO. Scenario The scenario to replicate the issue is to create a DictTable object and then perform a fieldObject() method call on a field that doesn’t exist. According to Microsoft documentation, this method should return null if the object could not be created.

Read More
can not export chart and reports from power bi.com to excel?
Jun09

can not export chart and reports from power bi.com to excel?

 can not export chart and reports from power bi.com to excel ? after investigation ; there is an option for power bi desk for that reason  under file /options and setting  should disable option for hide the header option because export option available in header option that you hide   Continue Reading noreply@blogger.com (Hakim)’s Article on their blog can not export chart and reports from power bi.com to...

Read More
Power BI Multiple Companies D365 F&O
Jun09

Power BI Multiple Companies D365 F&O

Cross-company behavior By default, OData returns only data that belongs to the user’s default company. To see data from outside the user’s default company, specify the ?cross-company=true query option. This option will return data from all companies that the user has access to. Example: http://[baseURI\]/data/FleetCustomers?cross-company=true To filter by a particular company that isn’t your… Continue...

Read More
Using Azure LogicApps and D365FinOps business events for data export scenarios
Jun08

Using Azure LogicApps and D365FinOps business events for data export scenarios

Last week i shared an article about Power automate flow integration with Dynamics 365 FinOps to export data by using Data management package REST API, and we have seen the 2 different options that support file-based integration scenarios that can be used as data batch API in D365 FinOps, when each API can be considered based on multiple decision points. see the previous article: Data… Continue Reading adalhix’s Article on...

Read More
Display Navigation link in D365FO
Jun08

Display Navigation link in D365FO

With a simple set up, it is easy to display the navigation link or path of the form. This feature will be useful for developers when they discuss with client or functional team . Navigate to System Administration -> Set up -> Client Performance options. Select ‘Enable legacy navigation bar’ and click Ok. Refresh the browser . Continue Reading AnithaEswaran’s Article on their blog Display Navigation link in...

Read More
How To Develop A D365 Number Sequence
Jun06

How To Develop A D365 Number Sequence

In the last article, “How to Use a D365 Numbers Sequence“, you learned that a number sequence is a system generated unique value. Additionally, you learned how to set up and use them. In this article, learn how you can develop a D365 number sequence to your own field using X++. And how to add… Continue Reading → The post How To Develop A D365 Number Sequence appeared first on Dynamics 365… Continue...

Read More
Vendor payment journal should inherit dimension from vendor master data while offset is expected to have dimension drill down from bank or any other offset account type
Jun05

Vendor payment journal should inherit dimension from vendor master data while offset is expected to have dimension drill down from bank or any other offset account type

 PROBLEM DESCRIPTION ========================== Financial dimension on bank journal for offset account is expected to be inherited from offset account master data. But vendor dimensions shows on offset account.   SUMMARY of TROUBLESHOOTING ========================== As per design, dimension from account will be copied on offset account. Then if any blank dimension, dimension for offset account… Continue Reading...

Read More
FastTrack recommendations for success
Jun03

FastTrack recommendations for success

I give the Microsoft FastTrack team and team producing the docs all credit for the following blogpost! We very often get information overload, and then there is great to get a more compressed summary of what is important to consider in D365 projects. Here is the text from an email that is sent out to … Continue reading FastTrack recommendations for success Continue Reading Kurt Hatlevik’s Article on their blog...

Read More
How to Grant Access to Navigation Modules in D365FO
Jun02

How to Grant Access to Navigation Modules in D365FO

A question I recently got asked was ‘Is there an easy way to grant access to different modules in the navigation within D365FO?’ I wanted to show how this can be done and provide some resources to hopefully help out! How is the Navigation Access Decided? Which navigation objects a user sees within D365FO is directly related to the menu items the user is assigned as the entries in the… Continue Reading Alex’s...

Read More
D365FO DIXF : No update if the record already exists
Jun02

D365FO DIXF : No update if the record already exists

DIXF framework updates the existing records based on the Primary key defined in the entity. But there are scenarios where we don`t need to trigger an update . For instance, if I am importing a vendor file with primary address details along with other fields, triggering the same file multiple times (when new records are added) would create duplicate addresses in the GAB. My client was not ok… Continue Reading...

Read More
Data export via Power automate and Data management package API
May27

Data export via Power automate and Data management package API

Most businesses handle a tremendous amount of data on a daily basis, when one of the main challenging tasks during the ERP life cycle systems, is its capability to offer agile and prebuilt modern data integration patterns for complex business scenarios to communitate easily with other systems, and ensure continiuous data integration and data storage flows. In Dynamics 365 FinOps we have… Continue Reading adalhix’s Article...

Read More
The working folder [source path] is already in use by the workspace [workspace name];[owner] on computer [tfs server]
May27

The working folder [source path] is already in use by the workspace [workspace name];[owner] on computer [tfs server]

When a VM is already configured with tfs using one user id, until the workspace is deleted from Source control, another user will not able to configure it . In order to execute the below command to delete the workspace of another user, you should have proper privilege to Source control. tf workspace /delete /server:devopsAzureURL workspaceName;”User name” In the above statement,… Continue Reading...

Read More
The remote certificate is invalid according to the validation procedure
May26

The remote certificate is invalid according to the validation procedure

We faced the below issues in our dev environments and the team was unable to access the URL. As a workaround, in ‘Microsoft Edge’ we had an option of clicking ‘Advanced’ button which allowed us to redirect to the URL. This option was also not working for few users and they had to try accessing the URL in ‘incoginto’ mode. Scroll down for more details Also, the users were… Continue Reading...

Read More
How To Use A D365 Number Sequence
May23

How To Use A D365 Number Sequence

A D365 number sequence allows the system to generate a unique value. As well as use a defined format for the type of record being used. This is extremely helpful. There are sometimes, such as with item numbers, where you might have a specific value you use to already identify something. On the other hand,… Continue Reading → The post How To Use A D365 Number Sequence appeared first on

Read More
Create A D365 Development Environment
May09

Create A D365 Development Environment

In order to develop in Microsoft Dynamics 365 for Finance and Operations, you need a development environment. In this article, you will learn how to create a D365 development environment. Once this environment is setup, you can use it to perform testing of the system. As well as develop new functionality using Visual Studio. You… Continue Reading → The post Create A D365 Development… Continue Reading...

Read More
Segregation of Duties in D365FO
May03

Segregation of Duties in D365FO

I’ve referred to the Segregation of Duties (SOD) feature in Dynamics 365 for Finance & Operations before but haven’t really gotten into the specifics of the feature itself, what it allows you to do and the shortcomings/gaps. What is Segregation of Duties? The idea of Segregation of Duties (aka Separation of Duties) is that a single user should not be able to perform certain actions in a… Continue Reading...

Read More
How To Write A D365 Find Method
Apr25

How To Write A D365 Find Method

One of the most common tasks when writing code in Microsoft Dynamics 365 for Finance and Operations, is to retrieve a record from the database. Once you have the record, you can read, update, or delete it. In this article I will show you how to write a D365 find method. A ‘Find’ method makes… Continue Reading → The post How To Write A D365 Find Method appeared first on Dynamics 365… Continue Reading...

Read More
Customer advance and NTE
Apr22

Customer advance and NTE

 Customer advance created for GBP 12,000 but the NTE value on the project contract header is GBP 10,000. The customer advance invoice posted without any issues as NTE is not checked at advance level. The NTE values on the project contract are also unaltered. First project transaction of expense was posted for GBP 8,000, with a NTE check as “Success & Committed”. This transaction was successfully… Continue...

Read More
Document Attachment as Notes in D365FO
Apr22

Document Attachment as Notes in D365FO

I`ve already posted on exporting and importing attachments in D365 FO. There are various types of attachment available in FO . For instance, as File, image, Notes, URL etc. If you are importing the attachment as Notes, it can be handled in a simple way with the OOB entity . There is no need to export or import the package mentioned in earlier post which is suitable for Files and image… Continue Reading AnithaEswaran’s...

Read More
Creation of Credit Note in ProjOps
Apr21

Creation of Credit Note in ProjOps

 Once the invoice is “Confirmed” in ProjOps and project invoice proposal “Posted” in FinOps , user can create a credit note by clicking the “Correct invoice” button, which creates a negative invoice in ProjOps. Once the negative invoice is “Confirmed”, then system does NOT automatically create a negative project invoice proposal in FinOps. System gives this error: The user has to...

Read More
Insertar Power Apps en Dynamics 365 Finance and Operations
Apr20

Insertar Power Apps en Dynamics 365 Finance and Operations

Gracias a la Power Platform, se han multiplicado las opciones que tenemos para extender Dynamics 365 Finance and Operations sin necesidad de escribir código. En artículos anteriores vimos como podíamos aprovechar los flujos de Power Automate para ello, y en esta ocasión, nos vamos a centrar en las distintas formas que tenemos para insertar aplicaciones de lienzo de Power Apps dentro de… Continue Reading ja.tomas’s Article...

Read More
D365 Store Commerce performance test
Apr20

D365 Store Commerce performance test

Hi friends. A few weeks ago, Microsoft announced that the D365 Store Commerce App is now GA. The MPOS will enter “end-of-support” in release 10.0.33(Spring 2023) according to the following whitepaper. There are still features missing in Store Commerce, like dual display etc, but this will be added in later releases (10.0.28+). One of the … Continue reading D365 Store Commerce… Continue Reading Kurt...

Read More
How To Update Data In D365
Apr18

How To Update Data In D365

After users enter in data in Microsoft Dynamics 365 for Finance and Operations you often need to process the data. In this article you will learn how to update data in D365 using x++. There are several different ways to update data. And there are several important things you need to know in order to… Continue Reading → The post How To Update Data In D365 appeared first on Dynamics 365… Continue Reading...

Read More
D365: My take on the new Microsoft focus
Apr13

D365: My take on the new Microsoft focus

On the 6. April 2022 Microsoft had a launch event for Dynamics 365, where Charles Lamanna (Corporate Vice President, Business Applications & Platform) was the key speaker, and presented the latest wave of Dynamics 365. The main innovation theme was organized around 3 concepts; Data, AI and Collaboration. The main keynote states that Data is … Continue reading D365: My take on the new… Continue Reading Kurt...

Read More
How To Insert Data In D365
Apr11

How To Insert Data In D365

Of the of the most important things to know how to do in Microsoft Dynamics 365 for Finance and Operations is to work with data. In this article you will learn how to insert data in D365 using x++. There are several different ways to insert data. Therefore, understanding when to use each one is… Continue Reading → The post How To Insert Data In D365 appeared first on Dynamics 365 Musings. Continue Reading...

Read More
Part 4 – GitHub
Apr07

Part 4 – GitHub

Can you use Git Hub? yes. GitHub is also an option you could pursue when moving to Git. GitHub has a lot of new features and offerings that Azure DevOps does not have. However, there is basically no documentation from MSFT on how to configure builds and various other automation options in GitHub. I’m sure it’s possible but there will be a fair amount of guess work. Getting your pipelines fully… Continue Reading...

Read More
Part 3 – Developing with VS 2019 / 2022
Apr07

Part 3 – Developing with VS 2019 / 2022

What’s it like developing using Git? Developing in VS with Git is easy but I wanted to call out a few changes. First, you don’t need to manually add items to your repo. Your repo will have a .gitingore file that says what can be committed – and what can’t. If your .gitIgnore file doesn’t specifically ignore it, it will automatically be added. Also, your project folder will need to be in the…...

Read More
Part 3 – Developing with VS 2019
Apr07

Part 3 – Developing with VS 2019

What’s it like developing using Git? Developing in VS with Git is easy but I wanted to call out a few changes. First, you don’t need to manually add items to your repo. Your repo will have a .gitingore file that says what can be committed – and what can’t. If your .gitIgnore file doesn’t specifically ignore it, it will automatically be added. Also, your project folder will need to be in the…...

Read More
D365 : A messy tips blogpost
Apr06

D365 : A messy tips blogpost

Hi friends. We learn new things every day, and I wanted to share a new messy blogpost where you will find undocumented some tips. Enjoy. Azure Zone Pinning Sometimes I have experienced that Dynamics 365 performs slower than expected. I have in a few scenarios tracked this down the fact that the services are distributed … Continue reading D365 : A messy tips blogpost Continue Reading Kurt Hatlevik’s Article on their...

Read More
How To Use The D365 Table Browser
Apr04

How To Use The D365 Table Browser

There exist many forms to show the user data in Microsoft Dynamics 365 for Finance and Operations. However, sometimes it is very useful to look at all of the unfiltered data in a specific table. In this article, you will learn the multiple ways to use the D365 table browser. There have been many articles… Continue Reading → The post How To Use The D365 Table Browser appeared first on

Read More
Part 2 – Lifecycle of a Branch
Apr04

Part 2 – Lifecycle of a Branch

Let’s take a look at the lifecyle of a Git Branch. Unlike TFVC, branches in Git are typically short lived when it comes to development. In TFVC you may have a branch for each developer or a branch for development in general, another for test then a release branch. In Git, we will be using branches differently. We’ll get a change request as a work item in DevOps, review it, create a branch,… Continue Reading Nathan...

Read More
Part 1 – Package Management
Apr03

Part 1 – Package Management

How Shoud I Manage Packages in Git? There are 2 options when looking at Git for managing your X++ code. The main driver for which option you select is if you will only ever have 1 package in your code base or more than 1. This include any ISVs or any other item that will have a code footprint anywhere in F&O. To learn more about packages, please see 

Read More
Using Git with 1 Package
Apr01

Using Git with 1 Package

Submitted by Nathan Clouse on 04/01/22. Using Git with 1 Package When using Git for F&O, there are 2 basic flavors of using it; with 1 package or more than 1 package. This post will cover how to setup Git for use with 1 package. To learn out to create a Git repo in Azure DevOps, please refer to MSFT documentation. To learn how to create a repo on Github, please refer to GitHub… Continue Reading Nathan Clouse’s Article...

Read More