Dynamics 365 Business Central: How to export data from tables to CSV (comma-separated values) file

Today I would like to talk about how to export data from tables to CSV (comma-separated values) file.

A CSV (comma-separated values) file is a text file that has a specific format which allows data to be saved in a table structured format. Anyone familiar with spreadsheet programs has very likely encountered CSV files before, they’re easily consumed by Microsoft Excel, and countless other applications.

Source : Dynamics 365 Lab
Read more…

How to design a high performant inventory report in Business Central

If we want to answer a simple question in Business Central – “How many items we have in each location?” then there aren’t that many great built in reports available. There is the standard “Items by Location” report that is not that great. It doesn’t offer exporting, doesn’t offer filtering, you can’t see item values etc.

Source : D365 BC & Power Apps
Read more…

Show Microsoft translations when hovering over field names in VS Code

This post is especially interesting for the people whose native language is not English. Do you know the feeling? You are looking at the source code of some .al object and you come across a field name that means absolutely nothing to you. It would be helpful for you if you could see the translation of this field name into your native language.

Source : Business Central Deep Dive
Read more…