Automating California Sales Tax with Dynamics 365 Business Central

Overview If you’ve ever tried to keep your California sales tax tables up to date in Dynamics 365 Business Central, you know what a nightmare it can be. California changes district rates all the time. The rules around destination-based tax are complicated. And if you ship from your facility to customers within California, one smallRead more

Prevent Inventory Adjust Cost – Item Entries from Back Dating

Overview Hopefully, by now every company that uses the inventory module in Dynamics 365 Business Central knows that they MUST run the Adjust Cost – Item Entries process. Whether you set the process to run on a Job Queue or set the Automatic Cost Adjustment to Always on the Inventory Setup, you must run thisRead more

Implementing a System You Should Rarely Use

Overview I was talking with a client the other day about what the real goal of an ERP implementation is. And in the middle of the conversation, it hit me. As much as I’ve tried to dress it up over the years with methodology talk and solution architecture diagrams, the truth is actually pretty simple:Read more

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