Why Your Inventory Valuation Does Not Match the Inventory Account on the General Ledger

Overview At the end of every month, we will inevitably get some questions on why their inventory valuation figures does not match the G/L inventory account. We would investigate and find out why and provide solutions on how to fix them. Some of the reasons are pretty common so I’d thought I compile a listRead more

How to Handle Tariff and Duty Calculation Using Dynamics 365 Business Central

Overview With recent tariff announcements constantly evolving, importers face increased pressure to properly allocate duty and tariff costs into their inventory valuation. For example, if an item costs $6.00 per piece and is imported from a country like China, your final landed cost per piece could jump to $14.70 due to a 145% tariff (asRead more

The Reality of Remote ERP Implementation: Lessons After Years in the Trenches

Overview A few years into doing remote implementations, I’ve come to realize that this shift hasn’t been as seamless or efficient as people like to believe. I had a recent project where a customer on the East Coast wanted me to help them implement warehousing and shipping for their Dynamics 365 Business Central. From theRead more

The Problem with Over-Receipt Functionality in standard Dynamics 365 Business Central

Overview In standard Dynamics 365 Business Central, there’s an Over Receipt functionality that allows the warehouse to receive more than what was actually ordered on a purchase order. This is helpful in scenarios where a vendor sends a little extra, whether on purpose or by mistake. Microsoft provides a nice overview of this here: https://learn.microsoft.com/en-us/previous-versions/dynamics365-release-plan/2020wave1/dynamics365-business-central/receive-more-items-than-orderedRead more

Create Financial Statements using Financial Reports in Dynamics 365 Business Central

Overview Since our last video, Microsoft has updated the Account Schedule to be called Financial Reports. In addition, they’ve made minor changes to how the Row definitions and the Column definitions are defined. Here’s the updated video on how to create your financial statements using the Financial Reports (formerly Account Schedule) functionality. The Video

How to License an App for Use in Business Central

Overview We’ve noticed a recurring question from customers: “We downloaded the app but we still don’t see it in Business Central.” If you’ve found yourself in a similar situation, you’re not alone. This common confusion stems from a crucial step that is often overlooked in the process of setting up the app. In this blogRead more

Back Dating the Inventory Aging report in Dynamics 365 Business Central

Overview The standard Business Central has two aging reports dealing with inventory. They are: Item Age Composition – Qty. Item Age Composition – Value Why the Value and the Quantity report needed to be separate reports is beyond me. When we run these reports, we see that you can define an Ending Date. When youRead more

Entering Beginning Inventory Balance in Dynamics 365 Business Central

Overview When moving from a legacy system into Dynamics 365 Business Central, one of the areas you want to try and avoid is messing with the inventory G/L accounts. Most systems are usually pretty good with open A/R (Accounts Receivable) and A/P (Accounts Payable) accounts, they can be transferred using the “posting back to theRead more