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.
Everybody loves the power of CalcDate, but what about calculating time? In this video, I set out to create a CalcTime function that gives the same power as CalcDate. Check out the video:
In Dynamics 365 Business Central, pages are the main way to display and organize data. A page is defined in code as an object composed of controls, properties, actions, and triggers.
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.
Excel is one of the most used tools worldwide. In this post, you will learn 7 tips to export data from Business Central to Microsoft Excel. Also, you will learn how to connect OData Feed and Power Automate to Business Central.
With Business Central 2022 Wave 2, we got Exclude Permissions, but many people, including myself, tried it and failed due to a few bumps on the way. In this video, I show you how easy it works. Check it out:
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.