Skip to main content

Posts

How to Export CSV Files from Business Central Using CSV Buffer (Developer Guide)

Hi Readers, In this article we will discuss regarding how to export data from business central in CSV Format. CSV Export is built in feature of Business Central.  Overview This article explains how to export CSV files from Microsoft Dynamics 365 Business Central using the CSV Buffer table , including common problems developers face and the best practices to avoid them. It is written for Business Central developers who need a reliable, integration-safe CSV export , not an Excel-based workaround. What Problem Does This Solve? Business Central customers often request “Excel export” , but in most real-world scenarios, the actual requirement is: Data transfer to an external system Import into another ERP, WMS, or reporting tool Automation or scheduled data exchange In these cases, CSV is the correct format , not Excel. What Is CSV Buffer in Business Central? CSV Buffer is a built-in table in Business Central (and legacy NAV) designed specifically for CSV file hand...
Post a Comment
Read Complete Article »
Recent posts

How to Group and Consolidate General Journal Lines Using Query Object in Business Central.

Hi All, I received a question from a fellow developer to create consolidation entries from general Journal Lines. In this blog we will discuss how to customize business central the correct way. How you can write code to sum up lines with multiple fields in a journal for consolidation. Short Answer You can consolidate General Journal Lines in Business Central by using a Query Object to group records by Posting Date, Account No., and Dimension Set ID, aggregate amounts using SUM, and then insert the consolidated results into a target journal batch using AL code.
Post a Comment
Read Complete Article »

Why No. Series Break After Upgrading to Business Central 27 (And How to Fix It)

Hi All, During this weekend we did multiple customers upgrade to Business Central 27 Cloud customers. They did basic testing and expected upgrade to go smoother, but an unexpected issue was found after upgrade to Business Central 27. Impact: Business Central On-Prem Business Central SaaS In this article we will discuss, how to solve it before Microsoft fix the code for the upgraded environments.
Post a Comment
Read Complete Article »

🚀 Exploring Vibe Coding with GitHub Copilot for Business Central.

Hi All, In a recent #BCOpenDiscussion session, we delved into the fascinating concept of Vibe Coding —a new way of building software where developers collaborate with AI (like GitHub Copilot) to co-create solutions.  The session covered practical setup, how AI understands context, and even touched on Microsoft's new Model Context Protocol (MCP) integration for enhanced learning. Let’s break down the journey, step by step.
Post a Comment
Read Complete Article »

Understanding Business Central Cloud Infrastructure: Tenant ID, Environments & More!

 Hi, Introduction Microsoft Dynamics 365 Business Central operates on a powerful cloud-based infrastructure designed to deliver seamless ERP functionalities. But how does Business Central Cloud actually work behind the scenes? Understanding key elements like Tenant ID, Environments, Environmental Quotas, and Extending the Default Tenant is crucial for IT admins, developers, and businesses looking to maximize their Business Central Cloud experience. In this blog, we’ll break down Business Central Cloud Infrastructure, discuss its components, and explain how businesses can extend and optimize their usage.
Post a Comment
Read Complete Article »

Developing a Custom Sales Order Report.

 Hello everyone!  I hope you all are doing well. This is the second installment in our report development series. If you haven’t already watched the first video, which covers the basics of report components, I recommend checking out the playlist to get a foundational understanding before diving into this guide. In today’s post, we’ll take a step forward and start building a document report, specifically a  Sales Order Report . While working on this report, we’ll cover many essential aspects of RDLC report development that are crucial to understanding the overall process. This guide will focus on printing the  report body , and in future posts, we’ll tackle the header and footer.
Post a Comment
Read Complete Article »

Getting Started with RDLC Report Development.

Hi everyone,  I hope you're all doing well! Today, I’m excited to introduce a new blog series focused on RDLC Report Development in Microsoft Dynamics. Throughout this series, I'll share insights, best practices, and step-by-step guides on how to develop reports in Dynamics NAV. As a developer, I’ll be covering everything I know, so if this interests you, make sure to stay tuned! In this first post, we’ll go over the basics: what a report is, its components, and how RDLC reports function in the developer environment. For the demonstration, I’ll be using Microsoft Dynamics NAV 2016, but most of the concepts discussed will apply to NAV 2013 R2, NAV 2015, and even newer versions with only minor changes.
Post a Comment
Read Complete Article »