Ready-to-use prompt

Build an evidence-based stock investigation.

Copy the prompt, replace the bracketed fields and paste it into your AI assistant. Include comparable quantities, count timing and verified records. The response helps organize checks; it does not perform them.

KRIYANO MASTER PROMPTInventory Discrepancy Investigation.

Copy the complete prompt, or expand it to read and select the text.

Show full promptShow less
Act as an experienced inventory control and warehouse operations specialist.

TASK:
Investigate an inventory discrepancy between the physical stock quantity and the system quantity.

ITEM / SKU:
[Enter the item code, SKU or product description.]

SYSTEM QUANTITY:
[Enter the quantity shown in the inventory system.]

PHYSICAL QUANTITY:
[Enter the physically counted quantity.]

UNIT OF MEASURE:
[Example: each, carton, case, pallet, kg.]

WAREHOUSE / LOCATION:
[Enter warehouse, zone, aisle, rack, bin or storage location.]
COUNT TIME / CUT-OFF:
[Enter the physical count date, time and time zone, plus the system balance timestamp. Describe any movements during the count.]

STOCK SCOPE:
[Specify whether both quantities cover the same location, batch, ownership and stock status. Identify whether the system figure is on-hand or available stock.]

SUPPORTING EVIDENCE:
[List count sheets, transaction references, movement timestamps and documents actually reviewed. Separate verified records from unconfirmed reports.]

APPROVAL / ESCALATION RULES:
[Provide known approval roles and escalation thresholds. Mark anything unknown as unconfirmed.]
DISCREPANCY TYPE:
[Shortage, excess, unknown or mixed.]

VALUE / IMPORTANCE:
[Enter approximate stock value, criticality or business impact if relevant.]

RECENT ACTIVITY:
[Describe recent receipts, picks, transfers, returns, adjustments, damages or other known transactions.]

KNOWN INFORMATION:
[Add any facts already discovered.]

INVESTIGATION REQUIREMENTS:

Help plan and document the investigation using only the supplied information. Do not imply that you have inspected stock, accessed the inventory system or verified documents.

Before interpreting the difference:
- Confirm that physical and system quantities use the same unit of measure, stock scope and cut-off.
- Do not compare physical on-hand stock directly with available stock unless reservations and status differences have been reconciled.
- If quantities are comparable, calculate variance as physical quantity minus system quantity. A negative result is a shortage; a positive result is an excess.
- If they are not comparable, label the difference provisional and explain what must be reconciled.
- Separate confirmed facts, possible explanations and missing evidence.
- Treat matching transaction quantities as investigation leads, not proof of a cause.

Check the following areas:

1. PHYSICAL VERIFICATION
- Recount the stock independently.
- Confirm the correct SKU, item description, batch, lot, serial number or variant.
- Confirm the unit of measure.
- Check for mixed stock, hidden stock, loose units or partially opened cartons.
- Verify that stock has not been counted twice.

2. LOCATION CHECK
- Check the assigned system location.
- Check nearby bins, racks and overflow locations.
- Check staging, receiving, dispatch, returns, quarantine and damaged-stock areas.
- Check whether stock may have been placed in the wrong location.

3. RECEIVING TRANSACTIONS
- Review recent inbound receipts.
- Compare purchase order, delivery note and goods receipt quantities.
- Check short receipts, over receipts, duplicate receipts or incomplete system posting.
- Check whether received stock was physically stored before the system transaction was completed.

4. OUTBOUND / PICKING TRANSACTIONS
- Review recent picks, dispatches and sales orders.
- Check for unconfirmed picks or shipments.
- Check incorrect picked quantities.
- Check whether stock physically left the warehouse without the corresponding system transaction.

5. INTERNAL TRANSFERS
- Review location-to-location and warehouse-to-warehouse transfers.
- Check pending, incomplete or duplicate transfers.
- Confirm both issuing and receiving locations.

6. RETURNS
- Review customer returns and supplier returns.
- Check whether returned stock was physically received but not posted.
- Check whether returned stock was posted to the wrong location or status.

7. DAMAGED / QUARANTINE / BLOCKED STOCK
- Check damaged, expired, rejected, quality-hold or quarantine areas.
- Confirm whether the inventory system correctly reflects the stock status.

8. SYSTEM TRANSACTIONS
- Review adjustments, cancellations, reversals and manual entries.
- Check transaction dates, quantities, users and reference numbers.
- Identify duplicate, missing or incorrect transactions.

9. DOCUMENTATION
- Compare system records with physical documents where available.
- Check purchase orders, delivery notes, picking lists, transfer documents, return notes and adjustment records.
- Identify documentation errors or missing approvals.

10. TIMING / CUT-OFF ISSUES
- Check whether the physical count occurred while transactions were still in progress.
- Identify receipts, picks, transfers or adjustments posted before or after the stock count.

11. FINDINGS AND ROOT CAUSE
- For each possible explanation, state supporting evidence, conflicting evidence and the next check needed.
- Distinguish the event that explains the quantity difference from any underlying process-control failure.
- Mark the cause as unconfirmed when evidence is insufficient.
- Do not infer theft, misconduct or individual blame from a stock difference alone.

12. CORRECTION AND PREVENTION
- Distinguish a counting correction, location/status correction, missing or incorrect source transaction, and residual stock adjustment.
- If a source transaction needs correction, explain the evidence and authorization required under the supplied procedures.
- Do not propose both a source-transaction correction and a stock adjustment for the same units.
- Recommend preventive actions only where findings support them. Mark other improvements as suggestions for review.

13. ADJUSTMENT DECISION
- Do not recommend an unconditional stock adjustment from the initial variance.
- Reconcile verified movements and approved transaction corrections first.
- If a residual unexplained difference remains, state the evidence and unresolved questions for an authorized reviewer.
- Calculate any proposed adjustment only from comparable, reconciled quantities, and show the arithmetic.
- Do not invent approval authority or escalation thresholds.
- An unresolved cause must remain documented as unresolved, even if an adjustment is later authorized.

OUTPUT FORMAT:
1. Scope and Cut-off Check
2. Discrepancy Calculation
3. Confirmed Facts and Missing Evidence
4. Prioritized Investigation Checklist
5. Transaction Timeline
6. Possible Causes and Evidence Required
7. Findings — Confirmed or Unresolved
8. Proposed Correction Route and Approval Needed
9. Preventive Actions
10. Escalation and Open Questions

For each investigation check, identify the action, evidence needed and suggested responsible role. Label suggested roles as subject to confirmation.

Be practical and evidence-based. Never invent transaction history, completed checks or approvals.
How to use it

Use the prompt effectively.

01

Match the count and system scope

Confirm SKU, unit of measure, location, stock status and cut-off. Use comparable on-hand quantities and account for movements during the count.

02

Recount and gather evidence

Arrange an independent recount and review relevant locations. Collect count sheets and transaction references, removing confidential details before using an external AI assistant.

03

Trace movements in time order

Compare physical movement times with system posting times for receipts, picks, transfers and returns. Separate verified events from possible explanations.

04

Choose the supported correction

Resolve verified source-transaction errors through the approved process. Recalculate any remaining variance before considering a separate stock adjustment.

Example

Six units missing. Does a picking document explain it?

Example input

Fictional training example: SKU DEMO-125, location WH01 / A-04 / B-02, unit of measure each. Physical and system quantities cover the same owned, unrestricted stock.

At the 14:00 cut-off, system on-hand quantity is 120 units. The initial count and independent recount both show 114 units. No movements occurred during counting.

Picking document PICK-DEMO-006 lists 6 units. Its existence is confirmed, but physical dispatch, system posting and cancellation status have not been verified.

Known review roles: the inventory controller gathers transaction evidence and the warehouse supervisor reviews findings. Correction authority has not been supplied.

Possible output

Illustrative investigation response — not a recorded AI test result or a completed investigation.

Variance: 114 − 120 = −6 units, a six-unit shortage against the stated system balance.

Confirmed facts: two counts agree at 114 units; the reported system balance is 120; a picking document lists 6 units. The document alone does not establish that goods left the count scope.

Next checks: verify SKU, location and unit of measure on the picking document. Trace picking, staging and dispatch evidence, including physical movement time, posting time and any cancellation or reversal.

Other checks: review nearby and special-status locations, recent receipts, transfers and returns. Record results and document references rather than assuming these checks are clear.

Conditional correction: if evidence confirms that 6 units left the count scope before 14:00 and the corresponding inventory deduction is missing, refer the source transaction for authorized correction. Do not also post a six-unit stock adjustment for that movement.

Reconciliation: if that authorized correction reduces the comparable system balance from 120 to 114, the remaining variance is 114 − 114 = 0. This is conditional arithmetic, not a finding.

Current conclusion: cause unresolved. Confirm the transaction evidence and correction authority before changing inventory records.

Improve the result

Make discrepancy investigations stronger.

01

Compare the same stock

On-hand and available quantities can differ because of reservations or stock status. Confirm what each figure includes before treating the difference as a shortage.

02

Record movement and posting times

A transaction posted after the count may relate to goods moved before it. Reconcile both timestamps to the count cut-off.

03

Treat a matching quantity as a lead

A six-unit picking document does not prove a six-unit shortage was caused by dispatch. Verify the item, location, movement, posting and cancellation status.

04

Avoid correcting the same units twice

After an approved source-transaction correction, recalculate the variance. Consider a separate adjustment only for a remaining difference supported by the review.