Business Central physical inventory counts that finish on schedule

Choosing a Business Central physical inventory method

The simplest tool is the physical inventory journal. Calculate Inventory fills it with items and expected quantities per location. Counters write down what they find. Posting then creates positive or negative adjustments. It suits a small stockroom that a few people count in one go.

Physical inventory orders add structure for larger counts. One order lists what to count. Several recordings capture what each team found. So you can divide the work by area and combine it afterward. Locations with directed put-away and pick count by bin in the warehouse physical inventory journal instead. We match the method to each location.

Business Central physical inventory by cycle counting

Closing the warehouse for a full count is disruptive. A physical inventory counting period sets how often an item or stockkeeping unit is counted. The journal can then propose only the items that are due, location by location, round after round.

We sort items with you. Typically, fast-moving and high-value items get counted more often than slow ones. We assign periods to match. A short count on a regular rhythm replaces the big shutdown for many companies. Errors turn up while someone still remembers the cause. Your auditors should agree to the approach first, and we help you describe it to them.

Preparing for a Business Central physical inventory

A count is only as good as its cut-off. Post open shipments and receipts, or hold them clearly. Finish picks in progress. Stop movement in the counted area. The system works out expected quantities as of a posting date. Documents dated on either side of it then land in the right count.

We prepare a checklist with your warehouse lead that covers those points. It also covers labeling of bins and the handling of damaged and quarantined stock. It says what to do with items found without a label. Count sheets can print without expected quantities. Then counters record what they see, not a number they confirm.

Investigating differences before adjustments post

Counters enter quantities into the journal or recordings. The system shows the difference per line. Large differences deserve a recount, not an instant posting. A surplus of one item next to a shortage of a similar one usually means a mix-up. You should fix that as a reclassification.

Our tolerance rules say when a recount is required and who approves the final journal. Posting creates physical inventory ledger entries alongside the item ledger adjustments. That gives auditors a record of expected, counted and adjusted quantities. Lot and serial numbered items count per tracking number when that option is on.

Scanning during a Business Central physical inventory

Paper sheets work. But every handwritten number gets keyed again later. With barcodes on items and bins, a handheld scanner records counts directly. Standard Business Central accepts scanned input in fields. Warehouse scanning add-ons add guided count screens that write into the same journals and recordings.

If you already scan picks and receipts, extending the devices to counting is usually simple. If not, a count is a good first use. It is contained, and the benefit is clear at once. We help you pick an approach and test it on one aisle before the full count.

Business Central physical inventory questions

How often should we count?

That depends on your auditors, your stock value and how accurate your records are today. Many companies combine regular cycle counts of important items with a less frequent full count. We help you set a schedule that your finance team and auditors accept. Then we build the counting periods into Business Central, so the lists appear without a manual plan.

Can we keep shipping during a count?

With cycle counting, yes. Only the bins or items being counted stop moving for a short time. For a full count in one location, movements in that location should stop. They stop between the calculation of expected quantities and the end of the count. We write that rule into the count checklist, so every shift follows it.

Does a Business Central physical inventory use recordings or orders?

A physical inventory order defines which items to count. It holds the expected quantities. A recording is where one counter or team enters what they found. Several recordings feed one order. The order then works out the differences, and you post it. So a big count can split across teams and still end in one clean posting.

How do bin counts reach the item ledger?

In locations with directed put-away and pick, the warehouse physical inventory journal adjusts bin contents first. The Calculate Whse. Adjustment action in the item journal then posts the net difference to the item ledger. So warehouse and inventory stay aligned. We test the whole path on one bin before we use it for a full Business Central physical inventory.

Where do count adjustments post in the ledger?

Differences post to the inventory adjustment account set in general posting setup for the item's posting groups. A reason code or a separate general business posting group for counts lets finance split count losses from other adjustments. We agree the accounts with your accountant. Then the count result shows up where finance expects it.

Related inventory and warehouse pages

Counting confirms what the other inventory processes record. These pages cover stock control, warehouse handling and the scanning that makes counting faster and more accurate. Read them next if your Business Central physical inventory plan should link to wider warehouse work, so the counts you do keep the stock figures right all through the year. For the product detail, see Microsoft Learn: count, adjust and reclassify inventory.