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
- The supervisor sets up count sheets for the production areas as well as the warehouse.
- Teams count the work in progress on the floor along with stocked inventory.
- Advanced Inventory Count reconciles the WIP with the rest of the count.
- 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.
Related Advanced Inventory Count features
All Advanced Inventory Count features →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.