What’s new or changed in Dynamics Finance version 10.0.7 , – (January 2020)

Below are summary about the new update of Microsoft Dynamics Finance and Operations apps version 10.0.7

  1. Budget Register Entry Enhancements
  2. Ability to export records from the accounts payable invoice pool
  3. Ledger Settlements by User
  4. Forecast position reports(Public sector)
  5. Mark a Purchase agreement as closed
    • Users can now mark a Purchase agreement as “Closed” to signal the agreement is no longer actively used, making it so users will not be able to create release orders from the purchase agreement.
  6. Delayed Tax calculation on journal
  7. Reverse Journal posting
  8. Stop workflow submission when there are unallocated charges on a vendor invoice
  9. Account group selection for Chinese voucher types
  10. Sort resource in the project by invoice proposal
  11. Run Settle and post sales tax in batch mode
  12. Tax engine GTE (only available for India

For more details visit Microsoft Documentation using below link

 

Whats changed in 10.0.7

Entity Relationship – Common Data Service – CDS

Entity Relationships:

Entity relationships are metadata. Entity relationships define the different ways of entity records can be associated to different entity records from other entities or the same entity. Entity relationships allows the query to retrieve data efficiently.

Types of Entity relationships:

There are two types of entity relationships

One-to-many relationships:

Many related entity records associated with a single entity record (1:N) ,a parent/child relation.

Many-to-many relationships:

Many entity records are associated with many other entity records. A N to N( N:N) relation.

Entity relationship (1:N) do the following tasks, other than define the relations between the entities:

  • If record deleted on the parent entity then the record associated in the child entities also deleted.
  • When assign a record to a new owner, associated records also assign to the new owner.
  • How the record and related records will be visible to the users.

 

Previous Topic:

Entities – Common Data Service – CDS

 

 

Entities – Common Data Service – CDS

Entity:

Data is stored in the Common Data Service database is defined as entity. Entity corresponds to a database table and each field within an entity represents a column in that table.

Common Data service, metadata(data about data), is a collection of entities. Entity metadata controls the kinds of records you can create and type of actions performed on them. When we create or edit the entities,fields relationships, we are editing this metadata.

Common data service comes with a number of  standard entities that support the core business applications.We need to become familiar with the catalog of standard entities.

For minor changes we don’t need to create new custom entities:

  • To change the field display name or label we don’t need to create custom entity.
  • We cannot delete the standard entities but we can hide them by changing the security role assignment.

 

Previous Topic:

What is Common Data Service?

Next Topic:

Entity Relationship – Common Data Service – CDS

How delete a specific model/package? Uninstall deployable package. Microsoft Dynamics 365 for Finance and Operations

Sometimes we need to delete the model and deployable package from the dev environments.

 

Model Deletion:

use Modelutil.exe to delete the model file from the packages local directory.

 

Package installation or deletion:

 

  1. Stop IIS (kill the IIS worker process from the task manager)
  2. Stop batch job DynamicsAXBatch job
  3. Delete the package folder located on C:\ or K:\AosService\PackagesLocalDirectory (make sure folder completely deleted)
  4. Open VS Dynamics -> Model Management -> Refresh models

 

 

 

Failure! Status check of Report Server – The remote server returned an error: (500) Internal Server Error – Report design not found – Microsoft Dynamics 365 for Finance and Operations

Scenario:

Sometimes users facing below issue in generating the reports from Dynamics 365 for Finance and operations or Developers while deploying the reports 

  • Failure! Status check of Report Server –
  • The remote server returned an error: (500) Internal Server Error – Report design not found
  • Report design not found

Solution:

Restart the below services by going on the services list window of the report server or from the LCS

  • Restart the service report server
  • Check and restart the Microsoft SQL Server instance service

Note: If the server is sandbox environment managed by Microsoft then go the Power BI (report server) VM and restart the above services

 

 

 

What is Common Data Service? Common Data Service – CDS

Common Data Service allow you securely store and manage data that is used in the Business Applications. 

Data within common data service is stored within set of records called entities. An entity is a set of records used to store data, similar to how a table store data within the database.

 

platform

 

 

Entities – Common Data Service

Chain Of command – Forms – Dynamics 365 for Finance and Operations – X++

Chain of Command now supports the more scenarios for the extensions on forms:

Now you can wrap the methods on forms, Forms data sources, Datafields and on form control methods.

  1. Forms
  2. Form Data Sources
  3. Form Controls
  4. fields in data sources

Below is the complete example of Form Data source and just a code snippet for the rest. In below example we are updating the ratingmodel based on our custom logic that is global variable on the form.

Note: use element.FormToExtendVariable to access the form variables and datasources

Use element.FormToExtendMethod() to call the form methods

Screen Shot 2019-11-03 at 3.20.34 PM.png

 

  1. [ExtensionOf(FormStr(FormName))] // for form extension
  2. [ExtensionOf(FormControlStr(FormName,FormControl))] // for form control method extension
  3. [ExtensionOf(FormDataFieldStr(FormName,FormDataSource,DataField))] // for form datasource method extension
  4. [ExtensionOf(FormDataSource(FormName,FormDataSource) // for form data source extension

How to Extend form init(Pre or Post) Methods in D365FnO? – Microsoft Dynamics 365 for Finance and Operations – D365FnO – X++

Scenario: Sometimes you need to extend the form init method in Dynamics 365 for Finance and Operations.

Below is sample code to extend:

Code:

 

/// <summary>

    ///

    /// </summary>

    /// <param name=”args”></param>

    [PostHandlerFor(formStr(HcmRatingLevelIdLookUp), formMethodStr(HcmRatingLevelIdLookUp, init))]

    public static void HcmRatingLevelIdLookUp_Post_init(XppPrePostArgs args)

    {

        FormRun fr = args.getThis();

       //you have form run object to access the controls and datasources of form

       

    }

According to Azure Active Directory, your Identity, is currently Deleted within the following Azure Active Directory: Please contact your AAD administrator to resolve this. devops 403 – Uh-oh, you do not have access. – DevOPs

Scenario: Below issues comes when some user deleted from the active directory and then restore the same user.

 

  1. According to Azure Active Directory, your Identity, is currently Deleted within the following Azure Active Directory: Please contact your AAD administrator to resolve this.
  2. devops 403 – Uh-oh, you do not have access. – DevOPs

 

Resolution: Delete the user from the DevOps organization and projects completely. Then add again. Everything will work as it as after this.

 

Sometime user sync with DevOPS after restoring will take sometime in hours or may be a day. So wait for it, If the issue is still exists put your issue in comments here or in the DevOps community.

Package deployment fails – not enough disk space – Microsoft Dynamics 365 for Finance and Operations – LCS

Scenario:  Sometime during deployment users facing low space issue and deployment got failed.

Reason: The reason is deployable packages folder having many files that increase the drive used space. Microsoft by default deployable packages will delete after 30 days. If you deploy packages many times during the last 30 days. then you need to reduce the time of delete deployable packages

Solution:

 

  • Under the HKLM:\SOFTWARE\Microsoft\Dynamics\Deployment registry key, you can create the following keys to customize when cleanup should occur. The automated cleanup task will consider these values.
    • CutoffDaysForCleanup – The number of days that old packages and logs should be retained. The default value is 30.
    • CutoffDiskSpaceLimitForPackages – The minimum free disk space (in gigabytes [GB]) on the service volume drive where the package folder is located. For example, if the disk space is 200 GB, the cleanup task will remove the packages, based on the number of days.
    • CutoffDiskSpaceLimitForLogs – The minimum free disk space (in GB) of the system drive where the log folder is located. For example, if the disk space is 100 GB, the cleanup task will remove the servicing-related logs, based on the number of days.

Power Apps Related technologies – Power Apps – Part 3

Power Apps related technologies

Microsoft power apps works with other technologies o help you to create powerful apps for your organization.

List of technologies used to build power apps

  • Data Sources:
    • Data source bring cloud and On-premise data into the power apps.Data can be accessed thru build in connections, custom connectors or gateways
  • Common Data service
    • Common data service is a reliable and scalable service that allows to store and manage data that’s used by business applications. It is stored with in the set of entities.
  • Microsoft flow
    • Microsoft flow is used to automate the process based on some conditions. example is triggering of an event in the connected service. like when new customer creates in  the Dynamics 365 send an email to the users.

Power Apps Building Block – Power Apps – Part 2

This unit explores each part of the following PowerApps components:

  • web.powerapps.com – Apps start here, whether you build them from data, a sample app, or a blank screen.
  • PowerApps Studio – Develop your apps further by connecting to data, adding and arranging user interface (UI) elements (known as controls), and building formulas.
  • PowerApps Mobile – Run your apps on Microsoft Windows, Apple iOS, and Google Android devices.
  • PowerApps Admin Center – Manage PowerApps environments and other components.

 

web.powerapps.com

 

Screen Shot 2019-10-27 at 11.50.11 AM.png

 

PowerApps Studio

Screen Shot 2019-10-27 at 11.52.10 AM.png

 

Power Apps Mobile

1572162996276.JPEG

 

 

Power Apps admin Center

 

Screen Shot 2019-10-27 at 12.20.06 PM.png

 

What is Power Apps? Power App – Part 1

  • Power Apps

    • PowerApps is a suite of apps, services, connectors, and a data platform that provides you with an opportunity to build custom apps for your business needs.
    • By using PowerApps, you can quickly build custom business apps that connect to your business data that is stored either in the underlying data platform (Common Data Service) or in various online and on-premises data sources (SharePoint, Excel, Office 365, Dynamics 365, SQL Server, and so on).
  • With PowerApps, you can:

    • Build an app quickly by using the skills that you already have.
    • Connect to the cloud services and data sources that you’re already using.
    • Share your apps instantly so that coworkers can use them on their phones and tablets.
  • PowerApps building blocks

    • To create, share, and administer apps, you’ll use the following sites:
      • web.powerapps.com – On this site, you can open apps, specify the type of app that you want to create, share your app, and create data connections and flows. To use this site, you’ll need to log in by using your organizational account.
      • PowerApps Studio – On this site, you build apps by configuring user interface (UI) elements and Excel-like formulas.
      • PowerApps admin center – On this site, you’ll define environments and data policies.
    • Note:To use these sites, you’ll need to sign in by using your organizational account.