Saurav Dhyani - #MSDynNAV & #MSDyn365bc

Hi All, Do you know about application of entries in business central?   Have you ever opened a drawer full of socks and wondered where all the matching pairs went? Now imagine your business transactions facing the same problem. In Microsoft Dynamics 365 Business Central , this exact situation happens when invoices, payments, or shipments are not properly matched. That matching process is called Application of Entries —and while it is critical for accurate accounting, it often feels confusing. In a recent video, I tried to explain this concept using a simple, unforgettable analogy: matching socks . Let’s break it down.

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.