Kristen Hosman’s Dynamics 365 Business Central Blog

With the release of version 27.0, there’s a fantastic enhancement to Column Definitions : you can now include the date directly in the column header . In my example below, you’ll see that within the column definition for “12 MONTH” , I added every available date option just to show what’s possible. The second screenshot displays the report output using this setup. Tip: If you decide to use the Include Date in Column Header functionality, you may want to skip adding your own custom column header—otherwise, the results can get a little cluttered. Below is a clean example of how I would set this up for a 12-month spread. ------ Kristen Hosman is a Microsoft MVP in Denver. She works with Dynamics 365 Business Central and related technologies. You can also connect with her through this link:  Kristen Hosman | Linktree  

When evaluating the integrity of inventory balances in Dynamics 365 Business Central, it’s critical to confirm that the General Ledger and Sub-ledger remain in sync. One helpful tool for this validation is the Health Check Dashboard created by ERP Connect Consulting , which provides a snapshot of potential discrepancies especially around inventory postings and other modules as well. This blog highlights a recent review process and how the system confirmed accuracy through several reconciliation points. Inventory Posting Setup The Health Check Dashboard pulls balances directly from the G/L accounts listed in the Inventory Posting Setup specifically the Inventory Accounts that are tied to inventory transactions. In this case, the total balance for those Inventory Accounts comes to $1,086,229.20, which aligns exactly with the amount shown in the Health Check under the G/L summary. Interim Inventory Account Insight However, it's equally important to factor in the Inventory Account (Int...

We Don’t Want to Talk About How Much Time Was Wasted… You know that moment when a client sighs and says, “How much time was wasted?” Yeah… we’ve all been there. But I like to look forward — not backward. So instead, I asked: 👉 How much time will be saved moving forward? The Problem: Copy, Paste, and Chaos A client was doing something we’ve all done, copying data from Excel straight into the General Journal in Microsoft Dynamics 365 Business Central. It’s fast, it’s easy… until it isn’t. When they pasted their data, everything looked fine — but when they reviewed prior to posting, the Description field wasn’t what they expected. Instead of their carefully entered descriptions, every line showed the G/L Account Description. What happened? The Culprit: Field Order When pasting data into a Business Central journal, the system assumes your columns match the exact order of the fields in the page. In this case they matched but things were a bit out of order.  In this case, the Account T...

Business Central version 27.0 is now available. I recommend updating the update date to be the furthest date possible. Not because I don't trust the update, but because you want to test your processes in a Sandbox environment first, especially if you have customizations (PTEs). Here are the steps to set your update date. Log into the Dynamics 365 Business Central admin center Select the Production environment Select Update Settings > Set update date Update Date is the field you want to update with the desired date the Schedule update Verify the new scheduled update date on the environment page ------ Kristen Hosman is a Microsoft MVP in Denver. She works with Dynamics 365 Business Central and related technologies. You can also connect with her through this link:  Kristen Hosman | Linktree  

If you've ever received the following message when trying to Correct, Cancel, or Create Corrective Credit on a posted sales invoice, then this post is for you. You cannot use the cancel or correct functionality because the invoice line is associated with purchase order XXXX via a Drop Shipment. This error occurs because the system locks invoices tied to purchase order drop shipments, preventing you from using the standard correction tools. But don't worry, there are alternative approaches. Below are my recommendations based on different scenarios. Scenario 1: Customer was charged the wrong price If you accidentally billed the customer incorrectly (wrong item price or freight amount) you have two main options: Create a Sales Credit Memo for the difference.  Reverse the full invoice and issue a new invoice with the correct pricing. After posting the credit memo, make sure to apply it against the original invoice so everything balances out. 👉 Don’t forget about sales tax:  If yo...

Every now and then I stumble across a feature in Dynamics 365 Business Central that makes me think, "this is too good not to share." One of those hidden gems is the G/L Account Balance Budget by Period report. If you've ever wanted a quick, clear look at how your actuals are stacking up against your budget, this report is a simple but powerful tool.  Why It's Useful Instead of exporting to Excel and creating pivot tables, this report gives you an instant view of how your financial picture aligns with your plan. It's an excellent way to:  Spot variances quickly - see where your actual spend or revenue is drifting away from your plan. Analyze by time period - break down performance by day, week, month, quarter, year, or accounting period. Where to Find It To access the report:  Navigate to the G/L Budgets page. Open the budget you'd like to review. From the Budget Card, select Report > G/L Account Balance Budget by Period.  That's it. You're ready to ...