Reference · built on requestOperator by FibricInventory & supply

Count Variance

Reconciles count results against system quantities, proposes adjustments above tolerance and a root-cause task when a bin repeats.

About

A count is only useful once someone decides what to do with the difference. Count Variance reads each completed count, the system quantity it was taken against, the unit cost that turns units into value, and the adjustments already posted for the same item and bin. It applies the tolerance you set per item class.

Variances inside tolerance are proposed for approval as a batch. Each variance above it is proposed as its own adjustment, or as a recount when the number is large or the item is serialized. When the same bin or item varies again inside the window, a root-cause task is proposed in your work tool with the counts attached. An inventory manager approves every one.

This is a reference listing. It documents what Fibric would read from Count Variance and what it could propose, based on the vendor's published interfaces. Fibric builds it under a managed deployment when you request it; selecting it here installs nothing.

Inputs

  • Completed NetSuite inventory counts with Count Quantity, Snapshot Detail, Adjusted Quantity, and Variance Detail per item and bin
  • Count sheets or stock take results from your WMS or a spreadsheet, with a counted quantity per SKU and bin
  • System on-hand at count time, from the NetSuite snapshot or the Business Central item inventory figure
  • Inventory adjustments already posted, so a variance fixed once is recognized when it comes back
  • Unit cost per item, to state each variance in value as well as units
  • Tasks already open in Jira, Asana, or monday.com for the same bin or item

Proposed actions

  • Target capability: propose approving a count whose variances sit inside tolerance, so NetSuite posts its positive and negative adjustments
  • Target capability: propose an inventory adjustment for a variance above tolerance, with the count, the snapshot, and the value at stake
  • Target capability: propose a recount before adjusting when the variance is large or the item is serialized
  • Target capability: propose a root-cause task in Jira, Asana, or monday.com when the same bin or item varies again within the window

Proposed actions are target capabilities. Every action runs propose-first and needs a validated deployment and the appropriate permissions.

What you can build

  • Approve or hold each NetSuite count

    Counts in Completed/Pending Approval status are read. Those inside tolerance are proposed for approval. Lines above it are held with an adjustment proposal, and a repeat bin opens a Jira issue.

    With NetSuite, Jira

  • Reconcile a 3PL stock take against the ERP

    Counted quantities from ShipHero are set against the Business Central inventory figure per item. Differences above tolerance become adjustment proposals for the inventory manager.

    With ShipHero, Microsoft Dynamics 365 Business Central

  • Open a task when a bin keeps drifting

    The same bin varies on two counts inside the window. An Asana task is proposed with both counts, the adjustments posted between them, and the value involved.

    With Asana, NetSuite

Requirements

  • Count results with a system quantity to compare against: NetSuite Inventory Count, a WMS stock take, or a sheet with both columns
  • A tolerance per item class, in units or value, set by the inventory manager
  • A work tool for root-cause tasks: Jira, Asana, or monday.com
  • An inventory manager named to approve adjustments and recounts
Authentication
ERP credentials with inventory count approval and inventory adjustment rights, plus an API token for the work tool where root-cause tasks are created.

Limits

  • It compares. It does not count. A missing counted quantity is listed as uncounted, never treated as zero.
  • Tolerance is yours. No adjustment is posted without approval at any size of variance.
  • Value per variance uses the unit cost on the item record at the time of the count.
  • A bin repeats when it varies again inside the window you set. Two counts in one day do not make a pattern.

Access and pricing

Reference listing. Fibric builds the operator under a managed deployment when you request it. Your quote covers the build, capabilities, usage, and support.

Request Count Variance ↗

Questions and answers

What does the inventory manager approve?
Per count: approval of the count when variances are inside tolerance, an adjustment per line above it, or a recount. Each shows counted quantity, system quantity, the difference in units and value, and past variances on the same bin. The manager can change the quantity or decline.
What happens in NetSuite when a count is approved?
NetSuite creates up to two inventory adjustment transactions: one positive to raise on-hand, one negative to lower it. The proposal names the count and the adjustments that will follow. Rejecting returns the count to Started.
What record is left?
A receipt per count: each line's counted and snapshot quantity, the tolerance applied, adjustments approved, recounts ordered, tasks opened, who approved, and when. Each adjustment receipt states the reverse entry that undoes it.
Ask about Count Variance

Ask about the capabilities and requirements in this listing.

For project-specific requirements, contact Fibric.