Category Archives: Inventory

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

Why You Should Set Automatic Cost Adjustment to Never in Dynamics 365 Business Central

Overview This was one of the topics that came up frequently while working with users at the last NAV/BC User Group Summit at Phoenix. Many people have different opinion to setup their inventory so costing is done properly. Naturally, knowing a few things on how Dynamics 365 Business Central (aka Dynamics NAV) inventory and howRead more

Is Inventory Periods Needed to Control Inventory Posting?

Overview Over the years, I’ve written a lot of articles about inventory and inventory costing. I realize there are some tools that I do not mention that are in the inventory module. This is not because I don’t know about them, it’s because I don’t think companies need them. Everyone is super busy these days,Read more

Prevent Inventory Adjust Cost Entries from Back Dating

Overview Hopefully, by now every company that uses the inventory module in Dynamics 365 Business Central (aka Dynamics NAV) knows that they MUST run the Adjust Cost – Item Entries process. If not, please check out my other articles on the subject on how to properly care for the inventory module in Dynamics 365 BusinessRead 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

Doing a Physical Inventory Count with Warehousing in Dynamics NAV or Dynamics 365

Overview Here’s a quick video about doing a physical inventory count in Dynamics NAV (or Dynamics 365) when you have the Directed Pick and Put-away feature turned on. There are basically 5 steps: Go to the Whse. Phys. Invt. Journal Run the Calculate Inventory process Fill in the Qty. Physical field Register the journal GoRead more

Properly Setup Bin Code for Warehouse Management in Dynamics NAV

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

Common Mistake in Updating Standard Cost in Dynamics NAV

Overview Recently, I’ve been contacted by one of our readers on why their inventory cost was wrong. This particular company utilizes standard cost and the inventory cost never matched their inventory G/L account. Learning about how they updated standard cost, it was very apparent what went wrong. It was how the user updated their standardRead more

Undo Receipt with Directed Put-away and Pick for Dynamics NAV

Overview Undo receipt has become a necessity in some warehouse environments where the staff may not be able to keep up with the paper flow. Strictly speaking, the undo receipt process shouldn’t be necessary because the process in place should be able to accommodate. However, if there is a situation where a department “can’t keepRead more

Unexpected Changes the Expected Receipt Date in Dynamics NAV

Overview This is one issue that I hear from customers using Dynamics NAV (formerly Navision) quite often is why does the Expected Receipt Date keep changing? The Expected Receipt Date in Dynamics NAV is the main driver for inventory planning. Dynamics NAV uses this field to calculate the availability of the item. Based on thisRead more