Category Archives: Inventory

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

Displaying the Serial Numbers by Bins in Bin Contents

Overview In standard Dynamics 365 Business Central, if you enabled the Lot Warehouse Tracking in the Item Tracking Codes, you’re able to see a nice breakdown of what’s in the Bins when you go to the Bin Contents page: You can show this factbox using the Personalize tool in the Setup page. The Serial NumberRead more

Unlocking Efficiency: The Power of New Landed Cost Features in Freight Container Management for Business Central 365

We’re excited to introduce the latest updates to our Freight Container Management app for Dynamics 365 Business Central. Our mission has always been to make container management a breeze for businesses dealing with overseas vendors. With these new enhancements, we’re taking efficiency to a whole new level. Let’s dive into the exciting features: 1. MultipleRead 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 in Dynamics 365 Business Central. We would investigate and find out why and provide solutions on how to fix them. Some of the reasons are pretty common so I’dRead 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 in Dynamics 365 Business Central. 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 dueRead more

Properly Setup Bin Code for Warehouse Management in Dynamics 365 Business Central

Overview One of the most often asked about features when dealing with inventory is the ability to keep track of inventory by bins in the warehouse. While The Warehouse Management System will benefit the accuracy of the items that are stored in the bins, careful consideration must be made during setup so when you goRead 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

Accounting Cost vs. True Cost – Analyzing Costing in Business Central

Overview In Microsoft Dynamics 365 Business Central (formerly Dynamics NAV), when doing costing and profitability analysis, you need to differentiate between a transaction’s True Cost and Accounting Cost. These terms will not appear on any official documentation or manuals, I made them up for a lack of better terms. To better explain the difference betweenRead more