Skip to content

On demand · Webinar recording

Beyond the physical inventory journal: Accurate counts in Business Central

Counts with bins, several locations, or lot and serial tracking often end in spreadsheets, highlighters, and long nights of reconciliation. This is relevant for warehouse, inventory, and finance teams on Business Central, and their partners, who want counts they can trust.

Recorded November 18, 2026 · 61 minutes · Presented by Mark Hamblin, Senior Solution Advisor

Video still: Beyond the physical inventory journal: Accurate counts in Business Central

Summary

This session compares Business Central's physical inventory journal and physical inventory order with Advanced Inventory Count, then shows a full count from setup to posting. The demo covers count sheets filtered by shelf or bin, the as-of date, predefined and blank counts, and paper or scanner data entry. Lot, serial, and package numbers reconcile automatically, and differences are reviewed by value and sent to recount sheets with an audit trail. The count then moves to the journals with reclass entries, and a posting test catches errors before the batch runs. It closes with handheld scanner counts, text scanning without barcodes, licensing, and live answers on license plates, bins, reclass rules, expiration dates, and ABC classification.

Key topics

  • Where the physical inventory journal and physical inventory order fit
  • Count sheets filtered by bin, shelf, zone, or any item field
  • Predefined, blank, and cycle counts, including random item selection
  • Automatic lot, serial, and package number reconciliation with reclass entries
  • Difference review, recount sheets, and the audit trail
  • Posting test report and segregation of duties for posting
  • Handheld scanner counts with WMS Express or Warehouse Insight, including text scanning

Attendee questions, answered

10 questions asked during this webinar, each answered in its own article.

Show all 10 questions
Read the transcript

Introduction

Good afternoon, or good morning for some of you, and thanks for joining us. Today we’re going to focus on how to do inventory counts in Business Central. We’ll show you mostly Advanced Inventory Count, but we’ll talk about all of your options for counting inventory in Business Central.

The plan is a quick PowerPoint to go over the options, and then we’ll jump right in and look at the software. If you have questions, enter them in the question box in the GoToWebinar panel, and I’ll try to answer them as we go or at the end.


About Insight Works

If you don’t know who we are, we mostly work with physical inventory. Any time you need to touch inventory, that’s where we can likely help you: manufacturing, distribution, warehousing, and retail, like a parts counter or a retail outlet. Today, though, we’re focused on the inventory count side of things.

We have a lot of apps. If you have questions about pricing or functionality, and your Business Central partner is one of our resellers, talk to them, or contact us directly through the website.


Free Apps That Help with Counting

Let’s talk briefly about some of the apps we have that are free, because these are good.

Planning and Forecasting

At the top we have planning and forecasting. Whether you’re in warehousing or manufacturing, the Enhanced Planning Worksheet is what you need, especially in warehousing for automated purchasing. A lot of people in warehousing use spreadsheets for that type of purchasing, and the Enhanced Planning Worksheet solves that. We also have a forecasting capability, plus more technical tools your partner is likely to use.

Graphical Scheduler

Graphical Scheduler is more production oriented: drag and drop production orders. If you’re using warehouse picks, it also includes the ability to schedule and assign pick documents. Really, any data you want to visualize in Business Central, you can use Graphical Scheduler for.

DocXtender

If you do paper-based inventory counts, maybe you want to scan those count sheets and attach them in Business Central. DocXtender is drag-and-drop document management that stores documents in SharePoint or in Business Central itself. Having them in SharePoint is really nice, because you can use automations and AI with your documents once they’re there.

Order Ship Express

If you need to do domestic parcel shipments from within Business Central, Order Ship Express generates the label and gets the price and tracking information for you automatically.

WMS Express

The last one is the most relevant today. If you want to do your inventory counts with barcode scanners, WMS Express is free, and you can use it with the physical inventory journal, which might be sufficient for you. You can also use it with Advanced Inventory Count. With the physical inventory journal, there’s no cost other than buying scanners, or using phones, so you can go out and scan your inventory for the count.


Counting Options in Business Central

There are really three options for counting inventory in Business Central, or technically four. The ones built into Business Central are the physical inventory journal, or, if you have directed put-away and pick enabled, the warehouse physical inventory journal.

The Physical Inventory Journal

You can use the physical inventory journal with WMS Express at no cost, or with Warehouse Insight, so you don’t need a separate extension for your counts. The problem is that it’s quite limited.

Number one, you can’t record the serial numbers and lot numbers you counted. The physical inventory journal wants to know the difference between what you counted and what was expected. If you had ten lot numbers and you counted eight, it doesn’t want to know which eight you counted. It wants to know which two you didn’t count, so you have to track that manually. That manual reconciliation of serial and lot numbers is one of the biggest issues with the physical inventory journal.

The Physical Inventory Order

A few years ago, Microsoft added the physical inventory order, which is better than the physical inventory journal in some ways. It has basic lot and serial number reconciliation, but it still causes problems. You can easily get to a situation where you’ve counted what’s physically there, but the physical inventory order won’t let you post it. You’d have to post what was expected and then fix it manually in an item journal.

It does let you have what we’d call count sheets, so multiple people can count different areas, which works well if you’re in bins. If you don’t have bins, it becomes problematic.

We don’t officially support physical inventory orders in Warehouse Insight, but it can be set up so you can record inventory into a physical inventory recording document on the scanner.

Where the Built-In Tools Work Well

The built-in tools work reasonably well if you have locations with bin mandatory and no item tracking, or if you track lot and serial numbers with warehouse tracking enabled. They also work if you have locations with no bins and each item is only in one place.

If you don’t have bins, but you store some items in the parts room and some out in the shop, or you’re a retail outlet with stock in the back and at the front, that’s really hard to do with the built-in tools.


Advanced Inventory Count

Given those limitations, we have Advanced Inventory Count. There was a question: is it a different app? It is, completely different. It was built about 18 years ago, so it’s been around a long time.

It exists because people using the physical inventory journal, and even the physical inventory order, end up using Excel or stacks of paper with highlighters. Advanced Inventory Count lets you do everything inside Business Central that you’d otherwise do in Excel or on paper.

Full Counts and Cycle Counts in Any Configuration

You can create full inventory counts and cycle counts, and it works with any Business Central configuration, from no bins to full advanced warehousing. That matters if you’re a distribution center with retail outlets. You can count the same product in multiple places within a store without bins enabled, reconcile it, and track where you counted it.

Predefined and Blank Counts

You can create predefined counts, which is typical for paper-based counts today: you generate a list of items to go out and count. You can also do undefined item counts, sometimes called blank or blind counts, where you just say go count everything you find. Ideally you use these with scanners. People scan everything they find, and the reconciliation on the back end tells you what was there that shouldn’t be and what you missed.

Multi-User Paper-Based Counts

If you’re not using scanners, data entry is much simpler. You can have multiple count teams out there submitting paperwork for other people to enter.

Reconciliation Tools

The count is often not the problem. A bunch of people finish the count in a day or less, and then you’re there until four in the morning, or all weekend, trying to reconcile it. The reconciliation tools in Advanced Inventory Count are really useful: automatic recounts, manual spot checks, posting validation, and, best of all, lot, serial, and package number reconciliation. If you count eight lot numbers and two are missing, Advanced Inventory Count tells you which two are missing and automatically posts that difference for you.


Counting with Barcodes

If you want to do inventory counts with barcodes, using handheld scanners, phones, or even a laptop, you can.

The simplest way, not necessarily the best way, is to take a laptop or tablet out with a USB or Bluetooth scanner. You scan, and it injects the text you scanned right into the count sheet page. The technology is simple: you’re just injecting text into a Business Central page.

The other two ways use dedicated devices running WMS Express or Warehouse Insight, ideally on a barcode scanner. They also work on Android phones. You can scan into the physical inventory journal with either product without Advanced Inventory Count. If you have Advanced Inventory Count, both automatically work with it.

If you don’t have barcodes, talk to us. We can set you up with devices that read text as quickly as barcodes in a lot of cases. If your labels only have human-readable text, we can potentially still scan that, so you can count with scanners even without barcodes.


Demo: The Physical Inventory Order

Let’s look at the software, starting with the built-in Business Central tools. With the physical inventory order, you generate a list of items you want to count, which is your master list. Then you create a new recording. A recording is what we’d call a count sheet in Advanced Inventory Count: a subset of items, or everything, for people to go out and count. With several count teams, you’d probably generate one recording per team. They fill it in, and then you enter that information.

In this recording, I’ve entered the quantities I counted. You can print it for paper-based counts, and someone types in the quantities and any lot, package, and serial numbers. I counted 91 of one lot number and 55 of another, and finished the recording. Back on the physical inventory order, you can see what was recorded, including an extra 81 of one item. If I post, it will make the negative and positive adjustments.

When I preview the posting, I get an error telling me I need to assign a lot number. The problem is, I did assign a lot number. It doesn’t want to do the positive adjustment because it has gotten confused. So even though you can record lot numbers and see the differences, it doesn’t carry that through when it posts. It’s not ideal, but it’s much better than the physical inventory journal in a lot of ways.


Demo: The Physical Inventory Journal

In the physical inventory journal, I’ve calculated inventory for a location with bins, so it brought in all the bins. I can enter the physical inventory quantity, and it makes my adjustments. That’s fine.

With lot and serial numbers, though, I’m not entering the ten I counted. I have to figure out which ten I didn’t count, and enter the lot number that needs to be negative adjusted, not the lot number I counted.

The other issue: if I find items in another bin, I can’t add them manually to the physical inventory journal. I’d have to use an item journal. Lots of people use these tools and they work fine, but there are limitations in how Business Central works.


Demo: Setting Up a Count in Advanced Inventory Count

This is where Advanced Inventory Count comes in. Each count has its own count card, a bit like the physical inventory order. The list shows whether each count is active, along with the difference analysis, so you have historical data to track whether your counts are improving. I’ve got standard counts and cycle counts for different locations.

The Count Card

I’ll create a new count for my main location. You technically can have a count with multiple locations, but typically you count one location at a time.

The as-of date is nice because it does all the difference analysis as of that date. Say my year-end count is at the end of the month. I can set the as-of date to the end of the month and do all my preparation well in advance. If I start doing transactions the day after the count, they aren’t included in the reconciliation.

Below that, you can have it reconcile lot and serial numbers, and set the journal batches: the physical inventory journal and a reclass journal, which I’ll explain later. You can set a specific dimension for inventory adjustments, or it uses the item’s default dimensions. You can also save a count as a template and copy it whenever you want a new count for that location.

Count Sheets and Filters

I’m going to have team one and team two counting, and I want each team to count a specific area. There are filters for zone, bin code, item number, and more, plus a custom filter on the item for any field, including custom fields. This location doesn’t have bins, so I’ll filter by shelf number: team one counts everything up to shelf E, and team two counts shelf F onward. With bins, I’d set a bin filter instead.

That’s a directed or predefined count, where you list items for people to go find and count, usually on paper. For scanner-based counts, I’d send people out with blank sheets and they’d fill them in with whatever they found.

Generating Count Sheets

Next, I generate the count sheets, and there are a lot of options:

  • Include inventory: always on, so anything with an on-hand balance is included.
  • Empty bins activity period: normally an empty bin wouldn’t appear on the count sheet, but if a bin has been empty for a day or less, you can include it to confirm it really is empty.
  • Include active items: items not in stock that had a transaction in a recent period, typically a week or a month, so you can make sure you don’t have one or two sitting around.
  • Include inactive items: great for startup counts, such as a new location or a move to Business Central with no transaction history.
  • Stockkeeping units: counts only stockkeeping units, which is useful in warehousing.

There are also cycle count options. You can use the standard Business Central fields, like the physical inventory count period code. If you’ve assigned A, B, and C codes, you can use those, and Advanced Inventory Count can calculate that ABC code automatically based on item velocity. You can also use the next count period, which Business Central sets each time you post a physical inventory journal.

The one I prefer for cycle counts is random items. I can say, give me 30 random items I haven’t counted in the last couple of weeks, months, or years, by item or by item and bin.

When I generate, team one has 67 items to count and team two only has three, so I might change the filters to even that out. Anything with a lot or serial number appears with its lot, serial, and package number, and those are reconciled automatically. If I don’t count an item, it’s negative adjusted. If I count extra, it’s positive adjusted.

Here’s what’s kind of cool. Say I counted two extra of one lot and two fewer of another lot of the same item. The net difference is zero, but the lot quantities differ. Instead of a negative and positive adjustment, it creates a reclass journal entry, which maintains the costing. You don’t get a physical inventory ledger entry for it. It reclasses the lots so they match the count.


Demo: Count Sheet Data Entry

I can print the count sheets, with a few layout options, including one with the shelf number instead of the bin code, and an option to include blank sheets for additional items. People write in what they counted. Then someone enters the quantities, and if there are lot and serial numbers, they enter those too.

If they found something that wasn’t on the count sheet, no problem. I can add the same item again, and it sums the quantities automatically. Those lines can have different shelf numbers, so during reconciliation I know where I counted each one. That can be entered manually or scanned.

Baseline Sheets

For a cycle count, I might also create a baseline sheet. It’s like the master sheet in the physical inventory order: it tracks everything you’re supposed to count, and the count is compared to it. You typically need it for cycle counts, counts of a subset of inventory, or blank counts where people scan everything they find. It doesn’t hurt to have one.


Demo: Reviewing Differences

Once I’ve entered all the data, I review the problems. I show all differences, sort by the dollar amount difference, and show lot, serial, and package number issues. It shows exactly which lot numbers I’m missing or have extra, across lot, serial, and package numbers. On one item the net difference is zero, but there are lot and package numbers to adjust, so it handles that automatically.

At the bottom, it shows the total difference amounts and quantities, and the absolute differences. A total difference of zero might mean I counted $50,000 extra of one item and am missing $50,000 of another. That’s actually a $100,000 discrepancy I want to know about, and the absolute difference shows it.

The count difference summary shows the same information and can be exported to Excel. You can also use Copilot in Business Central for more analysis, like finding items that offset each other.


Demo: Recounts and the Audit Trail

This is a bad count. Instead of printing it and using highlighters or sticky notes to send people back out, I want the system to do that.

I can generate recount sheets automatically for anything out by more than a set amount, say $500, or a percentage, and add those items to a new recount sheet. Here I’ll do a manual spot check instead: I select the items I want recounted and add them to the recount sheet.

Now if I try to change the original count quantity, it won’t let me. I have to go to the recount sheet, and that gives you the audit trail. I know the original count, the recount, and who did each one, and I can recount on top of recounts. If auditors want you to spot check certain items, add them to a recount sheet. This works on paper or on the scanner.


Demo: Posting the Count

Transfer to the Journals

Once I’ve done the recounts, I transfer the count to the Business Central journals I set on the count card. Whoever has permission to post the journals does the posting. That’s segregation of duties: warehouse staff manage the counts and copy them to the journals, and someone in accounting or the warehouse manager posts to the item ledger, which affects the general ledger.

In the physical inventory journal, it has made all the adjustments. It knows which serial numbers were missing and makes those negative and positive adjustments automatically.

Reclass Entries

Here’s a cycle count for another location with a baseline and some lot-tracked and serial-tracked items. When I copy it to the journals, the reclass journal has entries. I counted 27 of an item in bin S01 that were supposed to be in S02, so instead of negative adjusting 27 out of S02 and positive adjusting 27 into S01, it creates a reclass entry to move them from bin to bin. Other entries are in the same bin but have a lot number issue, so it changes the lot number based on the count. Others just move from bin to bin.

In the physical inventory journal, one setting posts zero quantities, so you have a record of the count. Another line adjusts a specific lot and package number negatively, because we counted one less than expected.

The Posting Test Report

The preview posting in Business Central tells you what will pass or fail, but it has to go through all the posting logic. The test report lets us quickly see whether there are any error messages, such as blocked items or missing serial or lot numbers. You can count a blocked item and transfer it to the journal, but you won’t be able to post it until you’ve reviewed that error.

What usually happens is you have 5,000 lines in the journal, you hit post, it fails at line 4,900, you find and fix the error, post again, and it fails at line 4,901. The test report solves a lot of that, because it tells you what’s unlikely to post before you hit post.

Directed Put-Away and Pick Locations

This works with any location configuration. With directed put-away and pick, the standard Business Central approach is to post a warehouse physical inventory journal, then calculate the warehouse adjustment in the item journal. That doesn’t create a physical inventory ledger entry, which Business Central uses in a lot of places, such as updating count period codes. Advanced Inventory Count saves you from calculating the warehouse adjustment, and posts as a physical inventory, which gives you a lot of tracking capability. You can see the physical inventory ledger entries mapped to the count.


Demo: Counting on a Handheld Scanner

Here’s my scanner with the count application. If you don’t have Advanced Inventory Count, this shows up as the physical inventory journal, which we call basic count or standard count. I have Advanced Inventory Count, so I see my count sheets. Some have lines, which forces people to find and count those items. Team one’s sheet is blank because I haven’t generated count sheets.

I’d give someone the scanner and say, go scan everything you find in aisle one. In this location there are bins, so they scan the bin, scan the item, and enter the quantity. That adds a count sheet line automatically. The physical inventory journal works exactly the same way: you can start with a blank journal and scan everything into it.

About counting without barcodes: if I fold over the barcode and scan the printed text instead, it reads it as quickly as a barcode. You can set the scanner to remember or forget the last bin you scanned. We can set you up with the right scanner to scan text as quickly as you can scan a barcode, so you don’t necessarily need barcodes to count with a handheld device.


Licensing

Advanced Inventory Count is licensed by company. Even with 20 warehouses, you pay one cost for the entire company.

If you want to use handheld scanners for your counts, you can use WMS Express. You get up to five concurrent licenses for free, and you can buy more if you like. That’s five count teams doing inventory counts with barcodes at no cost other than the scanners.

Warehouse Insight gives you a lot more. It’s a full-fledged warehouse management solution, subscription based, and you pay based on the number of devices in your environment.

If you have more questions, go to the website, insight-works.com, or InventoryForDynamics.com. There are additional videos on setup and year-end counts. You can also reach us in the chat or talk to your partner.


Questions and Answers

Is Advanced Inventory Count the same as Insight Works Inventory Count in Business Central?

It is. In Business Central, we call it Insight Works Inventory Count to differentiate it, but it’s the same module as Advanced Inventory Count.

How does scanning text instead of barcodes work?

It’s all built into the scanner. You’re not using the camera. You point the imager at the text and it reads it, as fast as scanning a barcode.

Can you count license plates?

If you’re using license plates, you can count them in Advanced Inventory Count. It works a little differently on the scanner: you scan the license plate, and by default it records everything that’s supposed to be on that license plate on the count sheet line. If you need to adjust quantities on a license plate during the count, there’s an add-on in our add-on catalog for that.

If you track serial numbers, can you scan a license plate to bring in the serial numbers on it?

Scanning the license plate brings in all the contents of that license plate. You can’t scan a serial number on the license plate and have it bring in the license plate automatically. You have to scan the license plate barcode. By default, if I scan a pallet, everything on that pallet comes onto the count sheet line as it is. To edit quantities on the license plate as part of the count, you need the add-on from our add-on catalog.

Can you add items to the count sheets during a predefined count?

I think I answered that in the demo. Absolutely, both on the scanner and in Business Central.

Does the reclass journal work with directed put-away and pick locations?

It does. The reclass works everywhere, and it does its best to compare positive and negative differences on specific lot numbers and bins to decide when it can use those offsetting quantities to reclassify instead of adjusting. It won’t always reclass, even when you think it could have. There’s a setting to control whether it reclasses partial quantities or only full quantities. For example, with ten in bin A and zero in bin B, if I count zero in A and ten in B, that’s a full quantity. If I count eight in A and two in B, you can allow or prevent a partial reclass.

Will it reclass across locations if a count includes several locations?

It currently does not. It only reclasses within the same location. If I count ten in location B that should be in location A, it negative adjusts A and positive adjusts B. There are reasons for that, such as different posting groups.

Can you prevent people from scanning bins they weren’t supposed to count?

Yes. If you set a bin filter on the count sheet line, the scanner respects it. If someone scans a bin that doesn’t match the filter, it warns them, so they can’t add bins they weren’t supposed to count.

Can the scanner be configured so you don’t need to scan a bin?

Absolutely, but only with a predefined count. If I’ve listed 100 item and bin combinations to count, you can set it up so you just scan the item, and it won’t force you to scan the bin. With a blank count sheet, you do have to scan a bin, but you can have it remember the last bin you scanned. If I have 600 items in one bulk bin, I scan the bin once and then just scan the items. That’s a setting in the device configuration.

Will the reclass adjust expiration dates?

Yes. If a different lot number has a different expiration date, it adjusts that expiration date as well. You can enter expiration dates on the count sheet lines, but you can’t have different expiration dates for the same lot number. Positive adjustments use the latest expiration date it finds.

How does the automatic ABC classification work?

It’s the physical inventory count period calculation, part of Advanced Inventory Count, and there’s a knowledge base article on how to use it. It looks at the movement of your items by dollar amount and assigns the appropriate physical inventory count period code based on your configuration. For example, your top 10% are A items, the next 30% are B items, and the rest are C items.

Can you change the design of the count application on the scanner?

Yes, in Warehouse Insight. If you’re running Warehouse Insight and want to change how the Advanced Inventory Count application works, or change the view to a tile view instead of the grid view, you have full access to that application in the Application Designer.


Closing

I think that’s everything for the questions. If you have anything else, get hold of us on the website or check with your partner. Thanks for sticking around, and we’ll talk to you again next time.

Questions about this webcast?

Send your question and the Insight Works team will reply by email. Ready to plan a project? Contact your Microsoft Partner.

Ask a question

Webcast Questions