Calculate fields and totals in D365FO

Calculate fields and totals in D365FO

Always wanted to calculate in fields of D365FO? Or want totals of numeric columns in your D365FO screen? Today I had time to write about some nice functionalities of the ‘New grid control’ feature, added by Microsoft in October 2019:

No alt text provided for this image

When you activate this feature you get new grid functionality in D365FO. By example it is possible then to calculate in fields. Like in the general journal line you enter ‘=5+8’ in the debit field to calculate:

No alt text provided for this image

One tab to the next field and the result of the calculation will be shown:

No alt text provided for this image

Also you can right click on column headers of numeric columns and click on ‘Total this column’, by example in the open vendor invoices screen for the column 'Amount not settled':

No alt text provided for this image

Result is that the total will be shown in the D365FO screen:

No alt text provided for this image

When you open this screen later again, the total still exist.

When the feature 'New grid control' is enabled, you also can activate the feature ‘Freezing columns in grid’, added by Microsoft in March 2021:

No alt text provided for this image

This feature enables functionality where you can freeze a column in a screen. With this option the columns appear at the front of the grid and do not scroll out of view:

No alt text provided for this image


?

?

Kamesh Kamalanathan

Lead Digital Engineer at Sonata Software

1 年

Wow. Gud one

Hylke Britstra

Microsoft MVP for AI ERP / Trainer & Consultant & Manager Innovation D365 FO at Mprise

3 年
回复
Stefan van Collenburg

Application specialist D365F&O

3 年

Nice

要查看或添加评论,请登录

Hylke Britstra的更多文章

社区洞察

其他会员也浏览了