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.
In the earlier version of Business Central, the only way to copy data between companies was either to copy the company or upload the data through Configuration Packages or Rapid Start.
Microsoft introduced Copy Data from Companies to copy data from specific tables in companies to your respective table in your company.
Today I would like to talk about how to copy an existing company via AL (Create multiple companies in one go).
As you might know, Microsoft will add a new company limit in 2023 wave 1 (BC22).
The List data type in AL language represents an ordered collection of objects that can be accessed by their index. Unlike an Array data type, a List does not have a fixed size and does not need to have its dimension specified when it is declared.
The List data type has several useful methods that can be used on its instances.
As companies grow, your Microsoft Dynamics 365 Business Central system needs to adapt and scale due to organic growth or via acquisition. In this video, ArcherPoint shows how to copy data from one company and transfer this information to another company within Business Central via the configuration worksheet. In Business Central, the configuration worksheet is the central location that allows you to plan, track, and perform your configuration work.
One of the things that totally slipped by me, is the new app from Microsoft that apparently was released in the last wave called “Data Search“.
It’s a simple, but powerful concept: Search for “any” record in your data. Well, any record that you have set up to search for at least ;-).
In this video, I explore how we can pull telemetry data into Business Central. Check it out: