How to Use the Business Central Warehouse Physical Inventory Journal
Managing inventory efficiently is crucial for any business. Accurate inventory tracking ensures smooth operations and financial stability. In this blog post, we’ll explore how to use the Physical Inventory Journal feature in Microsoft Dynamics 365 Business Central to maintain precise inventory records.
This quick video will show you how to use the journal, capture discrepancies, and register physical inventory counts, as well as how to adjust your item journal ledger if necessary.
For step-by-step instructions on performing specific tasks in Microsoft Dynamics 365 Business Central, see our collection of How-To blogs.
Transcript follows
Hello and welcome to this ArcherPoint presentation on using the Warehouse Physical Inventory Journal. In a previous session, we looked at the warehouse item journal. Today we’re going to look at what it looks like to do a physical count using WMS. You’ll notice when you open the Warehouse Physical Inventory Journal that the location code is already populated. This is based off of the warehouse employee setup table. So if you go and change your default location in that table, that will reflect here. When you reopen this, you start off by going to process and calculate inventory. You enter your warehouse document number. This is what’s going to be used when you register any positive or negative adjustments in this journal, and then enter any other relevant filters such as zone data code, item number, and so on. Say okay, and it pulls in the calculated amounts.
You can export this to Excel if you would like and do things like remove the calculated columns so that if you print this out and give it to warehouse employees, they won’t know what the expected value is. When you get your results back, enter the actual amount in the quantity physical inventory column. So, for example, if I were to enter my 90 here, it will automatically enter my adjusting amount for me. When you’ve made all of your entries, you go to registering and register. After you register, make sure you go to the item journal because my Warehouse physical inventory journal is just making the adjustments in my warehouse ledger entries. When I go to my item journal, I can then say, process, calculate warehouse adjustment, and this will bring in all of my posted transactions from my warehouse journals into here so that I can post them. And this is where it actually hits the item ledger and posts cost adjustments. Thanks for your time today. If you have any questions, please ask them in the comments or reach out to ArcherPoint so that we can assist you.