Skip to content
Advanced Inventory Count app iconAdvanced Inventory CountReconcile and post

WIP Counting for Microsoft Dynamics 365 Business Central

In a plant, some stock is not on a shelf: it has been issued to production and is sitting on the floor as work in progress (WIP). A count that ignores it either misses that stock or counts it as an overage. Advanced Inventory Count identifies WIP and reconciles it with the rest of the counted inventory, then posts the consumption and inventory adjustment entries.

Advanced Inventory Count runs on its own for counts entered in Business Central, and works with Warehouse Insight or WMS Express, Insight Works' mobile warehouse apps, for counting on handheld barcode scanners.

How WIP counting works in Advanced Inventory Count

  1. The supervisor sets up count sheets for the production areas as well as the warehouse.
  2. Teams count the work in progress on the floor along with stocked inventory.
  3. Advanced Inventory Count reconciles the WIP with the rest of the count.
  4. Posting creates the consumption entries for WIP and the inventory adjustment entries for the rest.

Key capabilities

WIP identified in the count

Advanced Inventory Count identifies stock that is work in progress, so it is counted and reconciled rather than left out of the count.

Reconciled with other inventory

WIP is reconciled together with the other counted inventory, so the same item counted on the floor and on the shelf is accounted for once.

Consumption and adjustments

When the count posts, Advanced Inventory Count posts the appropriate consumption entries for WIP and inventory adjustment entries for the rest.

Lot and serial numbers included

Lot and serial discrepancies are reconciled and posted automatically for WIP as for other stock. See Lot and Serial Count Reconciliation.

Details that matter on the floor

Consumption, not write-offs

Material that went into production is posted as consumption rather than as an inventory shortage, so the count result reflects what happened on the floor.

Who uses WIP counting

Production managers

Account for raw materials and WIP on the floor during the count.

Inventory managers

Include production areas in the full count without separate spreadsheets.

Financial controllers

Post consumption and adjustments that match what the count found.

Questions about WIP counting

Can Advanced Inventory Count count work in progress?

Yes. It identifies WIP, reconciles it with the other counted inventory, and posts the consumption and inventory adjustment entries.

Does WIP counting post consumption?

Yes. Posting creates the appropriate consumption entries for WIP, alongside inventory adjustment entries for the rest of the count.

Can lot-tracked WIP be counted?

Yes. Lot and serial discrepancies are reconciled and posted automatically.

Advanced Inventory Count app icon

Part of Advanced Inventory Count

Finish inventory and cycle counts sooner in Business Central with barcodes and multi-user entry.

Have a question about WIP counting?

Send us a note and the Advanced Inventory Count team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions