Financial Structure Series Part 2 – Chart of Accounts
Aug16

Financial Structure Series Part 2 – Chart of Accounts

In the previous post of the financial structure series, Financial Dimensions has been been thoroughly illustrated along the three primary types. In this post, we will shed a light on another core component of the financial structure in Dynamics AX, which is the chart of accounts. COA is simply a list of all the main accounts, below is a representation of the financial structure as a whole The… Continue Reading Mahmoud M....

Read More
AXAPTAMANIAC: Workflow not kicking in
Aug16

AXAPTAMANIAC: Workflow not kicking in

Many times there is a situation where the workflow does not kick in, no matter what. It does not give any error but it does not progress either. In such situations, a functional person can do the following debug steps before going to a a technical consultant. Most of the times this should resolve the issue, if it doesn’t then definitely it needs to be looked into by a technical… Continue Reading noreply@blogger.com (Sarang...

Read More
Financial Structure Series Part 1 – Financial Dimensions
Aug14

Financial Structure Series Part 1 – Financial Dimensions

Traditional legacy systems used to have chart of account segmentation in order to report on the different business levels for financial purposes, which imposes limitations on the business to expand their data capturing effectively and simply result with poor financial design. The financial structure series for Dynamics AX ( 365 for Finance and Operations ) will illustrate the theoretical… Continue Reading Mahmoud M....

Read More
AXAPTAMANIAC: Sales price on a project PO
Aug10

AXAPTAMANIAC: Sales price on a project PO

Reinventing the wheel is always frustrating and royal waste of time. To avoid that, i am writing this post. This is nothing big but just a small note so that it becomes permanent in my memory and i need spend time on it in future if it crosses my path again. Sales price field on the project tab in the project PO behaves differently based on whether it is for item or procurement category and… Continue Reading noreply@blogger.com...

Read More
Sales price on a PO when the cost is to be consumed on the project
Aug10

Sales price on a PO when the cost is to be consumed on the project

Reinventing the wheel is always frustrating and royal waste of time. To avoid that, i am writing this post. This is nothing big but just a small note so that it becomes permanent in my memory and i need spend time on it in future if it crosses my path again. Sales price field on the project tab in the project PO behaves differently based on whether it is for item or procurement category and… Continue Reading noreply@blogger.com...

Read More
How to export data more than 10 K in Dynamics 365?
Aug07

How to export data more than 10 K in Dynamics 365?

Export data in dynamics 365 is one the most common tasks for users and consultants in this post , I talked  about export data by excel Note,The maximum number of rows by using export to excel functionality is 10 K only  to avoid this limitation, we have multiple approaches 1-you can use data entity as the below Go to data management workspace there are two views for this workspace  1-The… Continue Reading noreply@blogger.com...

Read More
How to install DRA in Dynamics 365?
Aug07

How to install DRA in Dynamics 365?

Dynamics 365 for Finance and Operations offers a downloadable embedded application, known as Document Routing Agent (DRA) that you can use to enable network printing scenarios.  DRA can access both local and network printers that are connected to the computer running the Dynamics 365 for Finance and Operations application in the Cloud. How to install DRA? Go to Organization administration How to install DRA in Dynamics 365? Blog...

Read More
HOW TO SETUP BASIC BUDGETING IN MICROSOFT DYNAMICS 365?
Aug07

HOW TO SETUP BASIC BUDGETING IN MICROSOFT DYNAMICS 365?

In Dynamics 365, we have 3 boxed approaches for budgeting as the below to implement the budget in Dynamics 365, you need some prerequisites Prerequisites I suppose you have a chart of account and create the fiscal calendar, financial dimension ..etc 1- you must configure account structure  you can create one account structure with a financial dimension for budget  General ledger /chart… Continue Reading noreply@blogger.com...

Read More
AXAPTAMANIAC: Revenue Recognition – Jumping months in Straight Line Rev Rec.
Aug06

AXAPTAMANIAC: Revenue Recognition – Jumping months in Straight Line Rev Rec.

In my recent project i had to work a lot on the straight line rev rec functionality in detail and had to test many different scenarios. This gave me more insight into what is system capable of doing and what the system is not capable of doing with respect to recognizing revenue in a straight line scenario. Straight line revenue recognition will always recognize revenue (approx.) equal revenue… Continue Reading...

Read More
Microsoft Business Applications sessions on-demand and Dynamics 365 version 10
Aug03

Microsoft Business Applications sessions on-demand and Dynamics 365 version 10

The Microsoft Business Applications sessions are now available on-demand https://www.microsoft.com/en-us/businessapplicationssummit/sessionsondemand I enjoyed the following sessions: Client usability and productivity improvements in the October release and beyond for Microsoft Dynamics 365 for Finance and Operations Monitoring Microsoft Dynamics 365 for Finance and Operations with… Continue Reading Kurt Hatlevik’s Article...

Read More
HOW TO IMPLEMENT VALUE ADDED TAX (VAT) IN MICROSOFT DYNAMICS 365?
Aug02

HOW TO IMPLEMENT VALUE ADDED TAX (VAT) IN MICROSOFT DYNAMICS 365?

Value Added Tax or VAT is a tax on the consumption or use of goods and services levied at each point of sale. VAT is a form of indirect tax Dynamics 365 supports many types of indirect taxes, such as sales tax, value-added tax (VAT), goods and services tax (GST), unit-based fees, and withholding tax. you can check overview here   This post discusses setup and transaction  A-… Continue Reading noreply@blogger.com (Mahmoud...

Read More
Vote on Dynamics 365 ideas
Aug02

Vote on Dynamics 365 ideas

Do you know that you can influence the direction of Dynamics 365? But you may be unsure as to whether it really will make a difference. Microsoft have a site where the community can add ideas and vote on them. Go to https://experience.dynamics.com/ideas/ and create your ideas. If the idea is valid and they get enough votes, Microsoft will act and include them in their product backlog. But… Continue Reading Kurt Hatlevik’s...

Read More
AXAPTAMANIAC: Straight Line Revenue Recognition
Jul31

AXAPTAMANIAC: Straight Line Revenue Recognition

Standard calculation for straight line revenue recognition is as follows: Original contract value = 12000 Original contract value Actual start date = 1st July 2018 Actual end date = 30th June 2019 Start and End dates Estimation for first three periods (months) Estimation for first 3 months Calculation for Accrued revenue is as follows: Accrued revenue = (Total contract value /… Continue Reading noreply@blogger.com (Sarang...

Read More

Data Migration: Combining 105 Excel Files in 3 Minutes

I needed to import multiple Excel files into AX;  all of them had a very similar format with the same columns.  Python to the rescue.  Ever since Build 2018 I’ve been using Visual Studio Code and enjoyed every moment of it, as I build Python scripts to assist me with anything I can think of.  I highly suggest that tool, and the Cobalt2 theme, for increased productivity and debugging- Data Migration: Combining 105 Excel Files in 3...

Read More
How to implement Financial Dimension Default Template in Microsoft Dynamics 365?
Jul25

How to implement Financial Dimension Default Template in Microsoft Dynamics 365?

In the Thispost, we talk about import movement journal via excel. Some people thought counting cannot be imported because the system locks item for transactions and calculates the on hand online. In Fact, for the first point,  system lock item for transaction based on your setupso if you activate lock items during count so, if this parameter not activated, you can make any transaction during… Continue Reading noreply@blogger.com...

Read More
Dynamics AX = Denis Macchinetti: Maintenance mode
Jul24

Dynamics AX = Denis Macchinetti: Maintenance mode

Hi All, In order to turning maintenance mode on or off in an Dynamics 365 FO LBD (aka On-premise) implementation, you have to: Open Sql Server Management Studio Point to the AXDB database Raise the following command, update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = ‘CONFIGURATIONMODE’ Restart the Service Fabric service against all AOSs Node When you’ve completed your maintenance mode… Continue Reading Denis...

Read More
How To Create alerts in dynamics 365?
Jul23

How To Create alerts in dynamics 365?

In the Thispost, we talk about import movement journal via excel. Some people thought counting cannot be imported because the system locks item for transactions and calculates the on hand online. In Fact, for the first point,  system lock item for transaction based on your setupso if you activate lock items during count so, if this parameter not activated, you can make any transaction during… Continue Reading noreply@blogger.com...

Read More
How to refresh Data entity list in Dynamics 365?
Jul18

How to refresh Data entity list in Dynamics 365?

after updating our environment to update 15, I face the below error when export data by using data entity  “Configuaration key not enabled for the entity ‘####Entity’ “ when I check the data entities  I see the below warning  “entity list must be refreshed from the framework parameters ..etc” To solve the above error and avoid the warning  just go to framework… Continue Reading...

Read More
How to Apply a package to a non-production environment by using LCS?
Jul10

How to Apply a package to a non-production environment by using LCS?

In the previous  post , I talked about how to create a deployable package The next step, apply this package to test environment and Live environment. Just log in  to LCS  and select your project Go to Asset library  click software deployable package and add your package set name & description for your package and click add file  browse your package and click upload  just wait… Continue Reading noreply@blogger.com (Mahmoud...

Read More
AXAPTAMANIAC: Resource Scheduling in Dynamics 365 FinOps
Jul10

AXAPTAMANIAC: Resource Scheduling in Dynamics 365 FinOps

I got to get my hands dirty with this functionality in the new project that i started working on and i must say this has been one of the complex areas in PSA. There are couple of bugs still in the system but overall the functionality started making sense only after i tried and tested the scenarios umpteen number of times. The ‘penny drop’ moment finally happened when i realized that the same… Continue Reading...

Read More
How to manage security field in Dynamics 365?
Jul09

How to manage security field in Dynamics 365?

In this Post , we talked about how to create the security in d365…etc Many customers need to control some fields for users. for example:: user A can see the credit limit for customer and user B can’t see it   In AX 2012, you can do that by using override permission button for a specific role as the below just select your table and uncheck don override, then select your filed and assign… Continue Reading...

Read More
How to merge multiple packages in LCS for Dynamics 365?
Jul09

How to merge multiple packages in LCS for Dynamics 365?

In Dynamics 365,  Application of a single package in an average environment requires about 5 hours of downtime. To avoid additional hours of downtime when you must apply multiple packages. just Go To LCS  and log in with your account and select your project  go to the asset library  you can create a single combined package that contains one package of each type. If you select a… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How to delete Model in Dynamics 365?
Jul09

How to delete Model in Dynamics 365?

In this Post , I talked about how to create or update the model in dynamics 365 Today, how to delete? take care from delete action and don’t forget to backup your work  you can delete model easily by delete model folder in this path “C:AOSServicePackagesLocalDirectory” for example, if you need to delete  Test Hakim model Stop AOS web service and the Batch Management Service and Go to… Continue Reading...

Read More
How to import and export project in Dynamics 365?
Jul09

How to import and export project in Dynamics 365?

Sometimes, the developer needs to use the previous development in other projects, so To transfer elements to a different installation, you can use a project package file. to use a project package file , just export project  1-Export project Right-click on your project and click export set name and select the path that you need to save A project package contains all the elements from the… Continue Reading noreply@blogger.com...

Read More
How to set startup object / project in visual studio?
Jul09

How to set startup object / project in visual studio?

To debug any project in visual studio,  you must set a startup object as the below error  you can set a startup object easily, just right click on your object and click set as a startup object  also, you can set the project as a startup project for your solution  right click on your project  and click set as a startup project   Or, right click on your solution and… Continue Reading noreply@blogger.com (Mahmoud Hakim)’s...

Read More
How to put Dynamics 365 in maintenance mode?
Jul03

How to put Dynamics 365 in maintenance mode?

In AX 2012 in order to import a license file, just go to your license management form in system administration module and click on import, select the file and run a full sync. in Dynamic 365, this form is read-only and you can not edit until you put your system in maintenance mode. to apply the maintenance mode for sandbox just log in to lcs with your admin account and select your… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How to build model in dynamics 365?
Jul02

How to build model in dynamics 365?

to build a model in dynamics 365  just go to dynamics 365 Tab in Visual studio select the model that you need to build  also, you can build the referenced package if you need  you can see multiple options in the options tab  like build reports if you need, synchronize database during the build,,,, etc you can see more details about this options here  you can build… Continue Reading noreply@blogger.com (Mahmoud Hakim)’s...

Read More
How to create security role from scratch in dynamics 365?
Jul01

How to create security role from scratch in dynamics 365?

When you understand the security architecture of Finance and Operations, you can more easily customize security to fit the requirements of your business. for more details, you can check this link  I talked about this topic before in this post, from visual studio view today, we can do this task, but from the user interface in Dynamics 365 1-create security role  Security roles are a… Continue Reading noreply@blogger.com (Mahmoud...

Read More
how to use security diagnostics for task recording in dynamics 365?
Jul01

how to use security diagnostics for task recording in dynamics 365?

In AX 2012 we have Security Development Tool, for more details  Link Unfortunately, it’s not available in the current version and replaced by another useful tool called Security diagnostics tool. In the previous Post, we talked about using Task recording and how it works.  also, I talked about the  security from visual studio before in this postToday, how to use this recording in… Continue Reading noreply@blogger.com (Mahmoud...

Read More
FACT NUM#ERS for dynamics 365
Jul01

FACT NUM#ERS for dynamics 365

This statistics for the last update Demo VM March 2018 (platform 8 and update 15) A  form is a window that you open from the Microsoft Dynamics 365 that shows information and enables you to perform actions, Tables are where your data live and flourish. Microsoft dynamics is built on relational database and normalization concept. This will make your data well-structured and… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How to use Task Recorder in Dynamics 365?
Jun28

How to use Task Recorder in Dynamics 365?

Task Recorder is able to record user actions in the client with exact fidelity. Task Recorder is able to capture the type of user action (such as a button click, value entry, navigation, etc.) for more details https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/user-interface/task-recorder Go to Settings > Task recorder. To create recording  just click create recording How to use Task Recorder in Dynamics 365?...

Read More
How to implement vendor collaboration management in Dynamics 365?
Jun28

How to implement vendor collaboration management in Dynamics 365?

Microsoft Dynamics 365 for Finance and Operations is a web-based application,So you can allow vendors work directly in the Microsoft Dynamics 365  What can vendors do? review, accept and reject the request for quotations (RFQs) review, accept, reject, accept with the changes purchase orders (POs) perform vendor invoicing work with consignment stock just follow this steps to complete… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How To Reverse Fixed Asset Depreciation in Microsoft Dynamics 365?
Jun28

How To Reverse Fixed Asset Depreciation in Microsoft Dynamics 365?

In the Thispost, we talk about import movement journal via excel. Some people thought counting cannot be imported because the system locks item for transactions and calculates the on hand online. In Fact, for the first point,  system lock item for transaction based on your setupso if you activate lock items during count so, if this parameter not activated, you can make any transaction during… Continue Reading noreply@blogger.com...

Read More

The Product variants form can only be opened for a product master

When right-clicking > View Details on a Variant number you may receive the following message  “The Product variants form can only be opened for a product master.” Call Stack     Data DictionaryTablesEcoResProductMasterMethodsgetProductMasterFromCaller   34     ClassesEcoResProductVariantsCompanyHelpernewFromFormRun     … Continue Reading Dag Calafell, III’s Article on their...

Read More
How to view related roles for all duties ,related objects and license for all roles in dynamics 365?
Jun25

How to view related roles for all duties ,related objects and license for all roles in dynamics 365?

1-you can view related roles for all duties in dynamics 365 from Dynamics 365 Tab in the visual studio the system will generate the below report in Excel Format, you can access this report in documents as you see, system view related roles for all duties. 2-you can view related objects and license for all roles in dynamics 365 from Dynamics 365 Tab in the visual studio the system… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How to import counting journal with Excel in Dynamics 365?
Jun25

How to import counting journal with Excel in Dynamics 365?

In the This post, we talk about import movement journal via excel.  Some people thought counting cannot be imported because the system locks item for transactions and calculates the on hand online. In Fact, for the first point,  system lock item for transaction based on your setupso if you activate lock items during count so, if this parameter not activated, you can make any… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How to troubleshoot The service in unavailable error in dynamics 365?
Jun25

How to troubleshoot The service in unavailable error in dynamics 365?

I am trying to login to dynamics 365 finance and operation but I face the below error I follow this steps to troubleshoot  this issue 1- login to LCS and check the environment is started https://lcs.dynamics.com/ 2- check the World Wide Web Publishing Service is running Windows Run command > services.MSC > World Wide Web Publishing Service  3- check the application pool for… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How To Link inventory site to a financial dimension in dynamics 365?
Jun25

How To Link inventory site to a financial dimension in dynamics 365?

When you set up a link between a financial dimension and the site inventory dimension, your legal entity can calculate profit and loss figures for each site. For more details A-SETUP 1- Create the Financial dimensions General ledger / chart of acccounts / dimensions / Financial dimensions  click new to custom dimension and assign the name for example (Site) as you… Continue Reading noreply@blogger.com (Mahmoud Hakim)’s...

Read More
How to Clean up unused inventory dimension in Dynamics 365?
Jun25

How to Clean up unused inventory dimension in Dynamics 365?

Cleanup jobs in Dynamics 365 can help delete old data that is not needed anymore, and this reduction in database size can improve performance. In this post, we talk about clean up unused  inventory dimension, Click Inventory management > Periodic > Clean up > Inventory dimensions cleanup. this batch job to maintain the InventDim table. To maintain the table, delete unused… Continue Reading noreply@blogger.com (Mahmoud...

Read More
How to run performance test for dynamics 365 ?
Jun25

How to run performance test for dynamics 365 ?

In the Thispost, we talk about import movement journal via excel. Some people thought counting cannot be imported because the system locks item for transactions and calculates the on hand online. In Fact, for the first point,  system lock item for transaction based on your setupso if you activate lock items during count so, if this parameter not activated, you can make any transaction during… Continue Reading noreply@blogger.com...

Read More
How to Clear the AOD cache in Dynamics 365?
Jun25

How to Clear the AOD cache in Dynamics 365?

In the Thispost, we talk about import movement journal via excel. Some people thought counting cannot be imported because the system locks item for transactions and calculates the on hand online. In Fact, for the first point,  system lock item for transaction based on your setupso if you activate lock items during count so, if this parameter not activated, you can make any transaction during… Continue Reading noreply@blogger.com...

Read More
How to view the installed hotfixes in Dynamics 365?
Jun25

How to view the installed hotfixes in Dynamics 365?

To view the installed hotfixes in Dynamics 365, just go to Dynamics 365 tab in visual studio and navigate addins , then click apply hotfix you can browse your hotfix to apply or view the installed hotfixes as you see, no hotfixes applied in this Demo. Continue Reading noreply@blogger.com (Mahmoud Hakim)’s Article on their...

Read More
How to create query in dynamics 365?
Jun25

How to create query in dynamics 365?

In Dynamics 365, you can create a query from Visual studio just open visual studio and create a project add new item select data model in dynamics 365 items and choose query item set query name and click the add button I create a query on  DirPartyLocation table right click on the data source and add new select your table and don’t forget to set the dynamic fields property to yes you… Continue Reading noreply@blogger.com...

Read More
How to hide field or button in Dynamics 365 form design by extension ?
Jun25

How to hide field or button in Dynamics 365 form design by extension ?

Sometimes, customers need to hide specific fields or buttons in many pages  like delete button ..etc you can achieve this task easily by creating an extension from your form and set the visible property  NO for this control For Example, we need to hide the attachment button group from the vendor page  just open the visual studio and create a new project. search on application explore about… Continue Reading noreply@blogger.com...

Read More
How to synchronize database in Dynamics 365?
Jun25

How to synchronize database in Dynamics 365?

In AX 2012, you can synchronize database from system administration  or from AOT as the below But in Dynamics 365, no menu available from GUI to synchronize database just open visual studio and go to dynamic 365 tab to synchronize  this action for full database synchronization Also, you can synchronize on the project buildgo to project properties    set synchronize database to… Continue Reading noreply@blogger.com (Mahmoud...

Read More
MSDYN365FO: Automate repetitive tasks – the easy way
Jun22
Read More
Generating Random Numbers and Dates (AX 2012)
Jun08

Generating Random Numbers and Dates (AX 2012)

The Random class creates random integer values.  Although the range of an int (32 bit) is: [-2,147,483,647 : 2,147,483,647], Random.nextInt() generates values from 0 to 32,767, which is an unsigned 16-bit integer.  Let’s run the Random class to validate the randomness. The results of generating 1,048,574 random numbers represented as a histogram: The RandomGenerate class enables you to… Continue Reading Dag Calafell, III’s...

Read More
D365FO – Some nice excel tricks
Jun01
Read More
Dynamics AX End of Life timetable
May25

Dynamics AX End of Life timetable

  Dynamics AX End of Life timetable ” Incremental Group It inevitably depends on which version of Dynamics AX you are on. The latest version (Dynamics AX 2012 R3) will be under support until 2021, but most versions going out of mainstream support from October 2018. Below is a table with all of the dates you should be watching out...

Read More
Measure sales per Retail Category in Power BI
May21
Read More