Saurav Dhyani - #MSDynNAV & #MSDyn365bc

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...

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.

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.

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.

 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.

 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.