Thursday, February 27, 2020

Grouping in grids feature in Microsoft Dynamics 365 F&SCM

Within Platform Update 33 (PU33) Grouping in grids feature has been added. In order to activate this feature, navigate to the Feature management workspace, find Grouping in grids feature on the list of System administration module and click Enable now button. Once you activate it, you can use grouping in grids capabilities.

This feature, which requires the new grid control to also be enabled, allows users to group data within grids. This empowers users to analyze data and calculate subtotals per group. Grouping can be saved as part of the saved view definition when the saved views feature is enabled.

For more details, visit this page - https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-finance-operations/grid-experience

With this new feature you can do the following:
1. In any grid decide by which field you would like to group your data.
2. Right click on that field and select Group by this column.
3. Grid will be presented in the grouped way by the column that you've set. In the example below, the grouping by Customer account on the Open customer invoice grid has been made.
Unfortunately, Totals are displayed for the whole grid and not per grouped field. In our case it doesn't make much sense, since there can be multiple currencies and the totals in this case are not correct.

New grid control in Microsoft Dynamics 365 F&SCM

Within Platform Update 33 (PU33) New grid control feature has been added. In order to activate this feature, navigate to the Feature management workspace, find New grid control feature on the list of System administration module and click Enable now button. Once you activate it, you can use new grid capabilities.

This feature replaces the existing grid control with a new control that has faster rendering, smoother scrolling, and less jumping when navigating in the grid. The new grid also allows drag-and-drop column reordering, entry of mathematical expressions in numeric cells, the ability to calculate totals at the bottom of numeric columns, and the ability to get ahead of the system when editing or creating data.

For more details, visit this page - https://docs.microsoft.com/ru-ru/dynamics365-release-plan/2019wave2/finance-operations-crossapp-capabilities/user-productivity-new-grid

With this new feature you can do the following:
1 - move/reorder columns by dragging them
2 - add columns through context menu
3 - add/hide footer to display totals for any integer/decimal columns
4 - hide columns through context menu
5-  use mathematical formulas in the numeric fields
6,7,8,9 - review totals in the footer section


Create Saved views and share with the users in Microsoft Dynamics 365 F&SCM

Within Platform Update 33 (PU33) new Saved views feature has been added. In order to activate this feature, navigate to the Feature management workspace, find Saved views feature on the list of System administration module and click Enable now button. Once you activate it, you can configure personalized view of the form.
This feature allows users to have multiple named sets of personalizations per page. Views can also be published to security roles.
For more details, visit this page - https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-finance-operations/saved-views
To create a new view of the form, navigate to any form that you would like to personalize.
Under the name of the form, you will notice "My view" option. Click arrow down and select Save as. This will trigger new view creation.
Provide a new name for the view.
After that, using Personalize this page button on the Options tab, make any changes that you would like (Add fields, hide fields, move fields etc)
Once you are done with personalization, you will need to save it. You will notice that it's unsaved view through asterisk. Click Save option and modified view will be saved.

If you need to share created view, you can click three dots icon and select Publish option.

In the opened form, you will have to specify the security role with whom you would like to share the view.
In a nutshell, this feature allows you to  create optimized views of a form that might speed up the process, simplify the user experience, and improve user productivity.

How quickly navigate to the List Page from Details form in Microsoft Dynamics 365 F&SCM

Have you ever noticed the link that is available at the top of the Details form? Let's say, Released product form (Product information management > Products > Released products).
If you click on any item, you will be drilled down into details of the selected product. If you need quickly go back into List page, you can easily click on the link, instead of clicking Close button (or Esc button on your keyboard).


Friday, February 21, 2020

Utilize ability to configure Dynamics 365 Finance and Operations - Warehousing app for multiple environments

Did you know that you can connect Dynamics 365 Finance and Operations - Warehousing app to multiple instances?
You could use it if you build your own solution and you need to test the developed solution in several environments, like Test environment, UAT etc.
In the Dynamics 365 Finance and Operations - Warehousing app there is an option to do so.

Open Dynamics 365 Finance and Operations - Warehousing app
Open hamburger menu and chose Settings
In the Connection settings window, Click on the drop-down list in the Select connection field.

In the Select connection window, click on the hamburger menu.

In the Action window, select New connection option.


 In the Add connection window, fill in required information.


Once you save it, you will be able to select environment in the Connection settings window, to which you would like to connect.

Thursday, February 20, 2020

Product identifier not found while barcode scanning in the Dynamics 365 Finance and Operations - Warehousing

If you experience an issue with the barcode scanning in the Dynamics 365 Finance and Operations - Warehousing and see an error message the Product identifier not found as presented below
You must have forgotten to turn on the Scanning flag on the barcode itself for that item.

Go to Product information management > Products > Released products > Manage inventory tab on the Action pane > Bar codes button in the Warehouse section

Switch to the General tab for the selected bar code and switch on Scanning flag.


Wednesday, February 19, 2020

Tips for Planning optimization in Microsoft Dynamics 365 for Finance and Operations

With new Planning optimization in Microsoft Dynamics 365 for Finance and Operations that will be available in the first half of the 2020, you would probably need to think about the following:

  1. Planning optimization service will be a black box. You will not be able to extend and customize calculations in the Planning optimization micro-service
  2. You would be able to customize the Pre-processing logic of the master data
  3. You would be able to customize the Post-processing logic of the master data
  4. Currently there are no extra charges announced for the improvement. Planning optimization is included in the current license. So, if you have an access to the Master planning functions (MRP), you will be able to get an access to the Planning optimization feature.
  5. Future additional planning functionality might come with additional charge.
  6. Planning is triggered add-hoc during office hours, but Planning optimization service can be cancelled while Planning is progress and no data corruptions occur. 
  7. Environment add-in needs to be installed through Dynamics Lifecycle Services (LCS) prior to using Planning optimization service.
  8. Standard planning capabilities (MRP) will be deprecated
  9. The sooner you start Planning optimization utilization (including testing, investigating different scenarios), the sooner you will find out all possible gaps for the real-time Planning optimization utilization.


Monday, February 17, 2020

Credit management in Microsoft Dynamics 365 for Finance and Operations

Within Platform Update 33 (PU33) new Credit management feature has been added. In order to activate this feature, navigate to the Feature management workspace, find Credit management feature on the list and click Enable now button.
Once you enable it and reload the page, new forms would have been added to the Credit and collections module.

All newly added forms are highlighted as Favorite on the screen below.

Turn on Business events in Microsoft Dynamics 365 for Finance and Operations (Platform version : Update31)


You must have been determined that business events parameters form is missing in the System administration module in the 10.0.7 (Platform version : Update31).



So in this version, you can activate Business events through SQL using the script below:

UPDATE [dbo].[BUSINESSEVENTSPARAMETERS]SET [ENABLED] = 1
,[PROCESSORTHREADS] = 1
,[ENDPOINTRETRYCOUNT] = 3
,[BUNDLESIZE] = 50
,[ENDPOINTSPEREVENT] = 10
GO

Do not forget to restart IIS and batch service once the script is executed.

In the 10.0.9 (Platform version : Update33) business events parameters back


How to provision user on the deployed Microsoft Dynamics 365 for Finance and Operations

You might notice that Provisioning shortcut is missing on the desktop of the deployed Microsoft Dynamics 365 for Finance and Operations environment.

To provision your user, use the following path:

K:\AosService\PackagesLocalDirectory\bin

In this opened folder you can find .exe file that is called AdminUserProvisioning.
Run that file, enter required information and wait until it's completed.

Now, you can log in to the deployed environment under provisioned user.


Friday, February 7, 2020

How to enable navigation bar in Microsoft Dynamics 365 Finance and Operations

If you would to get rid of Search and would like to display Navigation bar instead, you will need to follow the steps below:
Before:
After:


Go to System administration > Setup > Client performance option 
Turn on Enable legacy navigation bar flag

Tuesday, February 4, 2020

Dynamics 365 for Finance and Operations AOT Browser


If you would like to open and browse the contents of the AOT (Application Object Tree) from the UI, you can use the following link:
https://github.com/arbelatech/aotbrowser#what-is-the-aot-browser

Once you install a deployable package, you will be able to see new form located here:
Common > Common > AOT browser.

Next step is to run "Populate AOT objects" and wait until it's completed. After a while, you will be able to perform the following:

  1. Search/Filter
  • By AOT name or by label name
  • By object type
  1. Open from form personalization screen
  2. Open from data entities form
  3. Open in table browser (tables/views)
  4. View extensions inline
  5. View source code
  6. Jump to references
  7. View label value instead of label id