New Grid controls in Dynamics 365 Finance and Operations

Dynamics 365 F&O has introduced a new grid functionality. You need to enable it from feature management:

Enable highlighted features.

Old grid looks like below for all sales orders:


New Grid looks like below:


I have highlighted some changes. 

  • It is very easy to move the columns in Grid, Simply grab the column with :: in front of the column and drag-drop it in the sequence you want.

  

  • Calculating Totals on any columns just like Excel, once you click total this column, Footer will be displayed in grid:

 

 
 Footer shows total number of rows by default, one or more total of numeric columns as configured.  If you have selected rows more than one rows then it also shows the number of rows selected 
 

  •  Grouping on the data and showing subtotals


once the grouping is done, it looks like below:
 
 
Header rows show 
    •  Data value for the group
    • Column label
    • Number of data rows in this group
    • Subtotals for any column configured to show total

  • New typing ahead of the system is introduced. This lets the user keep editing the data while the validations are happening in the background and the user doesn't have to wait for it to finish before jumping to next row.

 
 There are 4 indicators:
    • Blank: this means row is successfully saved to DB. 
    • Processing pending: this means validation is still happening and row is not saved yet, the row is also italicized to show that.
    • Invalid: this means row is not valid and data needs to be fixed, the indicator also shows actions on hovering  as below:
 
    • Paused: This is when the server is paused because validation of the row triggered a pop-up dialog box that requires user input.

  • Pasting from Excel: You can directly copy paste Excel data of multiple columns into D 365 Grid.
 
  • Evaluating math expressions   You can directly add the math expression in Cell like below:
 

Which shows the result of math expression immediately 
 


Comments

Post a Comment

Popular posts from this blog

How to : get the Deep URL for a particular form with filter in Dynamics 365 Finance and Operations

Image
 If you are a developer and need to generate the Deep-link then you can follow the code mentioned in MS docs at https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/user-interface/create-deep-links But if you want to share a few URLs with filters already applied to other users then you can use the feature of  'Get a link' in D365FO. Suppose I want to share the list of all sales orders for customer 'US-001'. Go to Account Receivable -> Orders -> All sales orders  Filter by customer account 'US-001' Then in the navigation ribbon, go to Options and click on 'Get a link'   Copy all and paste the URL into new browser window. You will only see the sales orders for US-001. If you want to generate lot of deep URLs then you can also enable  'Automatically update query parameter' Once you enable this, as soon as you apply a filter on forms URL will be updated with the query parameters like below: You can copy and share the link directl
Read more

How to: Solve issue when DVT script for service model MRApplicationService on machine XXX failed

Image
I was running binary update from LCS when my deployment failed. The step which failed had a description " DVT script for service model MRApplicationService on machine XXX failed" When I checked the log, It was showing "Financial Reporting DVTs ran with 2 failures". To resolve it, I just reset the DataMart and resumed the deployment from LCS which then completed successfully. Those who do not know how to reset DataMart, We have to run the following command in Windows PowerShell. cd J:\MROneBox\MRInstallDirectory\Server\MRDeploy Import-module .\MRDeploy.psd1 Reset-DatamartIntegration -Reason OTHER -ReasonDetail "DB Refresh" 1st line is to change the directory where MRDeploy.psd1 script exists. depending on the environment typologies  some other common places where it can be found is G:\MRApplicationService\MRInstallDirectory\Server\MRDeploy K:\MROneBox\MRInstallDirectory\Server\MRDeploy 2nd line is to import the Script 3rd line is for
Read more

How to: Display individual financial dimension value in grid control

Image
To display inventory dimensions in the grid we have control of dimension display which can be set up as per the requirement.  But there is no control in D365FO to display financial dimensions in grid control.  There are 2 ways it can be done.  1. Create display methods to display particular financial dimensions like the below method which displays division. I have seen many examples on the internet using multiple find methods but I prefer it by doing one query with joins to improve performance issues. public display DimensionValue getDimensionDivision() {         DimensionAttributeValueSetItem  dimensionAttributeValueSetItem;         DimensionAttributeValue                dimensionAttributeValue;         DimensionAttribute                        dimensionAttribute;               select DisplayValue from dimensionAttributeValueSetItem             join dimensionAttributeValue             join dimensionAttribute             where dimensionAttributeValueSetItem.DimensionAttributeV
Read more