Business Central Online, quick comparison and detection of differences between table data structures using Powershell

Previously it was possible to export data structures to files (available in runtime1), the functionality was blocked from runtime 2 onwards.

Interesting function that in my opinion should be reinserted and made usable at least for On-premise.

Source : Roberto Stefanetti
Read more…

Export SQL data to CSV or XML File via Powershell

Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file.

Source : Roberto Stefanetti Blog
Read more…

How to group data in AL? Best practicies. Performance review.

Data manipulation is one of the most trivial things for Navision/Business Central Developer. We are constantly working with data in tables, adding, deleting, modifying, and so on. Today we’re going to discuss data grouping. What does it mean to group data? How do you do it in AL? What is the best and fastest way to do it? I hope we can find answers to all these questions.

Source : Volodymyr Dvernytskyi
Read more…