How to Export Text file from Business Central?

Introduction:

Business Central provides you the feature to export the data in Excel in General Ledger entries, Customer Ledger entries, etc. But we can export data in a text file. In this blog, we will see how we can export data in the form of a text file.

Steps to achieve the goal:

1. Create a codeunit that will export the data in text.
2. We will be needing Temp Blob Codeunit, Instream, and OutStream to read and write the data in the file.
3. Below is the code which will read and write the data in the text file.

4. You can use dynamic filename also by assigning a field value in the FileName variable;
5. FileName: Rec_ComapanyInformation.FileNameText // FileNameText is the field present in the Company Information Page which will be used as Filename of the exported text file.
6. We will be also using an action that will call the Codeunit function (GenerateTextFile)

7. The output of the above code is

8. To avoid using multiple times Write Text function if there is a lot of data that needs to be pulled from multiple fields. You can use a variable and store all the values in that variable and then assign that variable in the WriteText function.

9. The output of the above code is

Conclusion:

   Thus we saw how we can export data from Business Central in a text file.

   Thank you very much for reading my work. Hope you enjoyed the article!

Related posts:

Resolving SSL/TLS Secure Channel Trust Errors in Dynamics 365 Finance and Operations

How to change a Bill of material (BOM) item on a production order

Shopify Meets Dynamics 365 Finance and Operations: A Guide to Integration [Part 2]

Shopify Meets Dynamics 365 Finance and Operations: A Guide to Integration [Part 1]