Building Business Central Excel Reports with Copilot

Organizations rely on Business Central for operational and financial reporting, but many teams still export data to Excel when they need flexible analysis, custom layouts, or presentation‑ready visuals. Traditionally, this meant a significant amount of manual work: formatting, building pivot tables, adding calculated fields, and assembling dashboards.

What’s changed recently isn’t just one new feature, it’s the combination of Copilot capabilities across M365, and how they now naturally show up inside of Excel. When you put Excel Copilot, Agent Mode, and in‑place editing together, Excel stops being a passive spreadsheet tool and starts acting like an active reporting assistant.

Read More »

#HumpDayHacks: RecreateSalesLines

Have you ever seen a custom Sales Line field’s data just disappear? You sit there wondering why is that getting cleared out.

There is a procedure on the Sales Header RecreateSalesLines() that deletes and rebuilds all lines for the document after key header changes. It copies existing lines into temporary tables, validates header-driven changes, and then re-inserts lines via CreateSalesLine().

Read More »
GitHub Copilot Playbook

GitHub Copilot Playbook: Chat Modes

GitHub Copilot is more than a fancy auto-complete, as it offers multiple chat modes that empower developers to interact with their code in natural language to streamline development. Whether you need quick answers, automated refactoring, structured planning, or autonomous multi-step execution, Copilot’s chat modes provide tailored solutions for every stage of your development process. This playbook will guide you through each mode, illustrating how to leverage them effectively to boost productivity and maintain coding flow.

Read More »
GitHub Copilot Playbook

GitHub Copilot Playbook: Getting Started

In the ever-evolving world of software development, staying ahead of the curve is crucial. One of the latest tools making waves in the industry is GitHub Copilot, an AI-powered coding assistant developed by GitHub and OpenAI. This innovative tool is designed to boost productivity, improve code quality, and foster innovation among developers. I have been diving deep into settings, use cases, instructions and prompt generation for the past couple of months, and am very excited about the progress being made. If you are not already “pair programming” with GitHub Copilot, I urge you get a license and start dive into the world of AI-enabled programming. It has completely changed not only my workstream, but my understanding on many different coding principles. This is going to be the beginning of a series of ongoing blog posts to help support you in your GitHub Copilot development journey.

Read More »