Skip to main content

How Human Expertise Reshapes AI: A Solution for Reallocating Costs in Microsoft Dynamics 365 Business Central

Consultant and Managing Partner, MGC Group LLC
AI + Human Expertise = Better Outcomes

When faced with the challenge of reallocating general ledger entries in Microsoft Dynamics 365 Business Central, the natural first step is to ask: What is the best way to structure reallocations across dimensions, especially when those reallocations need to be based on actual consumption data?

At first glance, this looks like a technical question for artificial intelligence (AI) to solve. But the process of working through this scenario revealed something more valuable: AI accelerates exploration, while deep knowledge of Business Central by a person is what delivers the right solution.

The Initial Problem

The requirement itself was straightforward:

Reallocate costs posted with dimension value MFG across several other dimension values (EXT, INJ, THRM, ROTO) each month, using a statistical measure (pounds consumed) as the basis for allocation.

This is a classic driver-based allocation problem, where financial costs must be distributed according to non-financial activity measures.

Exploring AI’s First Recommendation

Chatting with ChatGPT about Business Central
Figure 1: The beginning of my conversation with ChatGPT 5

AI’s first recommendation was to use Recurring General Journals with Allocation Lines in Business Central.

This method works in principle:

  • It can reallocate already posted entries.
  • It allows costs to be split across multiple dimension values.

However, one limitation quickly became clear: the allocation percentages must be entered manually each month. Even though this tool works, it becomes inefficient without a direct connection to actual usage data since there is no native statistical account integration for allocations.

Interjecting Human Expertise

Chat discussion about Business Central
Figure 2: Asking about using a different BC function

At this point, human expertise began to shape the conversation more directly.

By asking “Can I use standard Allocation Accounts for this?” I was provided with another set of options. While the AI assistant had not raised this newer feature initially, my knowledge of Business Central’s product roadmap brought it into the discussion.

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

About Cynthia Priebe - Microsoft MVP

Cynthia Priebe works directly with end users and finance professionals daily — often brought in where others have not been able to find a solution. That field work is the source of everything she writes. After more than 20 years with Microsoft Dynamics NAV and now Dynamics 365 Business Central, her focus is on why the system behaves the way it does, not just what it can do.

Her work centers on the scenarios that don't always behave as expected and aren't always documented — particularly permissions and security behavior, financial reporting, and post–go-live configuration. Much of her content addresses functionality that didn't get fully configured at go-live, capabilities organizations didn't know existed, or setup that needs to evolve as the business changes.

Cynthia is a Microsoft MVP in Business Applications — Dynamics 365 Business Central, a Microsoft Certified Trainer (MCT), and has held the MB-800 Business Central Functional Consultant certification since it first became available. Before the exam launched, she was part of the worldwide team that wrote the original exam items. She also works with Microsoft Partners and ISVs, contributing practitioner-level knowledge to how BC is built, documented, and taught.

A regular presenter at DirectionsNA, DynamicsCon, and Community Summit, she is also a co-leader of the DUG Mentorship Meetup Group, owner of the Sharing the Righter Way™ LinkedIn community, and served on the Programming Committees for both Community Summit 2024, 2025 and DynamicsCon 2026.

You can connect with Cynthia on LinkedIn or join the Sharing the Righter Way™ LinkedIn community. In addition to her contributions here ...

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here