XMLports are used to export and import data between an external source and Dynamics 365 Business Central. Where we can easily map the tables and fields that are available in Business Central as well as the variables and constants to import/export data with XML format or any other format using the separator.
Today I would like to briefly talk about how to export all keys in all tables.
In AL, a key definition is a sequence of one or more field IDs from a table. You can define keys in table objects and table extension objects, depending on the type of key. There are two types of keys: primary and secondary.
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.
Last week I saw a question on the Business Central forum, how to export the Work Description in Sales Documents to excel?
As far as I know, Microsoft added this new field in Sales Documents since NAV 2017. It help users to add more details about Sales Quote or Sales Invoice.