Physical Counts
Inventory → Physical Counts (/inventory/counts) is how you check that the
system matches the shelves. You count what is physically in each bin, the
system compares it with what it expected, and once a second person approves,
every difference (a variance) is posted to stock.
Do this regularly — a full count at year end, and smaller counts of busy or valuable areas through the year (often called cycle counts).
How a count moves along
| Status | What it means |
|---|---|
| DRAFT | Created, not started. Nothing has been snapshotted yet. |
| COUNTING | The system has taken a snapshot of what every bin should hold. Counters are entering what they find. |
| SUBMITTED | Every line is counted and the variances are calculated. Waiting for approval. |
| APPROVED | Approved, and each variance has been posted to stock as a COUNT movement. Final. |
| CANCELLED | Abandoned. Nothing was posted. |
Before you begin
| You need | For |
|---|---|
inventory.counts.view | Opening the page. |
inventory.counts.manage | Creating, starting, entering, submitting and cancelling counts. |
inventory.counts.approve | Approve and post and Return for recount. |
The Warehouse Manager role has all three. Whoever submits a count can never approve it — this rule cannot be switched off. Plan for a second person with the approve permission (another Warehouse Manager, or your System Administrator).
You also need Entry access to the warehouse being counted.
The snapshot is taken when you select Start count. Stock that moves in or out of the counted bins after that makes the comparison wrong. Count when the warehouse is quiet, or hold receipts and issues until the count is submitted.
Understanding the page
The page lists every count with its Count number, Warehouse, Date, Status, how many lines are Counted, the Variance value (once submitted) and By — who approved it, who submitted it, or who created it, whichever happened last. Select a count to open its detail below the list.
The detail shows the count number, status and a Blind badge if counters cannot see the system quantity, plus a summary line: warehouse, category, date, N/M counted, and once submitted the number and value of variances.
The count sheet has one line per item per bin:
| Column | Meaning |
|---|---|
| Bin | Zone / bin. |
| Item | SKU, name and unit. |
| System | What the system expected at the snapshot. Shown as — on a blind count until it is submitted. |
| Counted | What was found. Editable while counting. |
| Variance | Counted minus system, in units and pesos. Red for a shortage, green for a surplus. |
| Reason | Why there is a difference, from the Write-off Reasons list. |
| Remarks | Free text. |
Run a count
1. Create it
- Select New count.
- Choose the Warehouse (required).
- Optionally choose a Category to count only those items — useful for cycle counts. Leave Every category for a full count.
- Set the Count date.
- Leave Blind count: counters do not see the system quantity ticked unless you have a reason not to. (The default comes from Inventory Settings.) Blind counts are more accurate because people count what is there rather than confirming a number they can see.
- Add Notes if useful, then Create. The count opens in DRAFT.
2. Start it
Select Start count. You see "Count started; quantities snapshotted". The system records what every bin should hold, and at what cost, and opens the entry sheet. The status becomes COUNTING.
3. Count and enter
- Select Count sheet to print a sheet for the counters to take onto the floor.
- Enter each Counted quantity. Enter 0 for a bin that turns out to be empty — a blank line counts as not counted yet.
- Where there is a difference, choose a Reason and add Remarks.
- Select Save as you go. Several people can enter counts over several sessions.
To enter counts from a spreadsheet instead (for example from a handheld counter's export), select Import counts. Download the template, fill in SKU, Bin, the counted quantity and optionally a reason, and load it. It works like the opening stock import: the file is checked first and loads all or nothing. Rows for items and bins not on the sheet are added to it. Save any typed changes before importing — the button is disabled while you have unsaved edits.
4. Submit
Select Submit. Any unsaved entries are saved first. If any line is still blank you get "N line(s) have not been counted yet. Count every line (enter 0 for an empty bin) before submitting."
You see "Count submitted for approval". The status becomes SUBMITTED, the variances are calculated, and Variance report becomes available as a PDF.
5. Approve, or send it back
A different person with the approve permission opens the count and reviews the Variance report. Then:
- Approve and post — you see "Count approved; variances posted to stock".
Each line with a difference becomes a
COUNTmovement in Transactions, at the cost captured in the snapshot. The bins now hold the counted quantities. - Return for recount — the count goes back to COUNTING so the lines can be checked and corrected.
If you submitted the count yourself, the approve button is disabled and the page says "You submitted this count, so someone else has to approve it."
Once approved, a count cannot be reopened or cancelled. If something was wrong, correct it with a new count or a stock adjustment.
Cancel a count
Cancel is available in DRAFT, COUNTING and SUBMITTED. Nothing is posted to stock. An approved or already cancelled count cannot be cancelled.
Common issues
| Problem | What to check |
|---|---|
| "N line(s) have not been counted yet" | Enter 0 for empty bins rather than leaving them blank. |
| Approve and post is disabled | You submitted the count. Someone else must approve. |
| "Count … cannot post a shortage … stock left the bin after the snapshot" | Stock was issued from a counted bin during the count, so the bin now holds less than the shortage to post. Return for recount, recount those lines, and resubmit. |
| System shows — | It is a blind count; the figures appear after submitting. |
| Import counts is disabled | Save or discard your typed changes first. |
| "That bin belongs to a different warehouse than this count" | An imported row names a bin from another warehouse. |
Related pages
- Inventory Settings — blind count default.
- Transactions — the
COUNTmovements a count posts. - Inventory Reports — valuation after the count.