How to export data from Business Central to a csv file with Power Automate (No customization) – JSON to csv

Today I would like to talk about how to export data from Business Central to a csv file with Power Automate in details.
Power Automate is a service that helps you create automated workflows (or flows) between apps and services, like Business Central. With Business Central, you’re given a license to Microsoft Power Automate

Source : Dynamics 365 Lab
Read more…

How XMLports used in Dynamics 365 Business Central for import and export the operations.

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.

Source : MADHDA
Read more…

Dynamics 365 Business Central: How to export all keys in all tables

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.

Source : Dynamics 365 Lab
Read more…

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…

Dynamics 365 Business Central: How to export Work Description (Blob) in Sales Documents to excel

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.

Source : Dynamics 365 Lab
Read more…