Fine Chemical Flow Library ← Flow library

Stock Evaluation Checking — Reconciling system stock against the physical count

Fine Chemical (FC) · WMS module · v1.1 · 17/09/2026 · Standard flow — for implementation, testing and development

Process Flow (swimlane)

WMS · Stock Evaluation Checking — Reconciling system stock against the physical countPhaseInputWarehouse StaffWarehouse ManagerOutputException — Cancel an approved adjustment slipYesNoDraftSubmitSubmit for reviewNoYesWarehouse · Location · BinItem · Barcode/QR · Lot NoMaster dataSystem stock perBarcode/QR before closingSystem (auto)Physical goods sittingin each BinPhysical goodsStart▣ Stock ClosingSearch by Close Date ·Warehouse · Location → pickthe row · Close → confirmWeb▣ Stock ClosingIn-Progress Txn — reviewSAVED / SUBMITTED entriesstill open in the periodWeb▣ Stock ClosingFreeze the stock snapshotper Barcode/QR ·Status = ClosedTransactions after the closereverse: in −, out +System (auto)Closing period Status = ClosedSnapshot Qty frozen foreach Barcode/QR▣ Stock Evaluation (Web)Create count cycle CNT-… —frequency · WH · location · PICWebCount cycle CNT-… with thesystem stock lines per Bin▣ Stock Evaluation (Mobile)Pick count cycle CNT-… ·scan the Bin to countMobile▣ Stock Evaluation (Mobile)Scan each Barcode/QR ·enter the physical Count QtyMobile▣ Stock Evaluation (Mobile)Submit Count — post resultsto Web, NO stock changeMobileCount CNT-… submitted, withSystem / Count / VarianceCompare Snapshot ↔ Countper Barcode/QR · assign1 of the 7 Barcode StatusSystem (auto)▣ Stock Evaluation CheckingSet filters: Close Date ·Eval/Trans Date · Warehouse ·Location · Item · Barcode · Lot→ SearchWeb▣ Stock Evaluation CheckingRead the Snapshot ↔ Evaluationgrid · quick-filter by statusWeb▣ Stock Evaluation CheckingExport — write the filteredresult set to an .xlsx fileWebFile StockEvaluation_[YYYYMMDD].xlsxBarcode Status= Matched?Matched row — stock agrees,nothing further to handle▣ Stock AdjustmentFilter variances by cycle · WH ·type · pick rows → CreateAdjustment (ADJ-YYYY-NNN) ·adjustment reason (optional)WebSave as Draft orsubmit right away?▣ Stock AdjustmentSlip = Draft · edit it andsubmit for review laterWeb▣ Stock AdjustmentSlip = Pending Approval ·rows leave the pending listSystem (auto)Slip ADJ-YYYY-NNN =Pending Approval▣ Stock AdjustmentOpen the slip · review theBefore → After table per rowWebApprove slip?▣ Stock AdjustmentReject — a reason ismandatoryWebSlip = Rejected (terminal)reason stored in Remark▣ Stock AdjustmentSlip = Approved · the stockadjustment runs at once, perthe variance type of each rowSystem (auto)▣ W/H Stock CheckingW/H Stock Checking(view-only lookup)WebSlip = Approved · stock nowmatches the Count: Qty / Lot /Location / WarehouseStart▣ Stock AdjustmentPick an Approved slip →Cancel · a reason is mandatoryWeb▣ Stock AdjustmentSlip = Cancelled (terminal) ·the adjustment is reversedSystem (auto)Slip = Cancelled · stock backto pre-adjustment · reason inRemark, prefixed "[Cancel]"
Startwhere the flow begins
Process steptop strip = screen used, colored tag = platform
Decisionevery outgoing branch carries its condition
Data / documentinputs in the Input lane, results in the Output lane
Main flowthe required order of steps
Optional branchmay be done or skipped
Tags on a boxMaster dataSystem (auto)Physical goodsWebMobile

Status lifecycle

Closing period (Stock Closing)OPENCLOSEDClose — freeze the snapshotRelease — reopen the periodStock adjustment slip (ADJ-YYYY-NNN)DRAFTPENDING APPROVALAPPROVEDCANCELLEDSubmit for reviewA slip can be created straight into Pending ApprovalApprove = adjust stock at onceCancel — no later actionREJECTEDReject
◻ SAVED / DRAFT / OPEN ◻ SUBMITTED / PENDING APPROVAL ◻ APPROVED / CLOSED ◻ REJECTED / CANCELLED

Input

#InputTypeUsed in step
I-1Warehouse, Location, Bin, Item, Barcode/QR, Lot NoMaster dataSearch the period · pick the Warehouse / Location row → Close
I-2System stock per Barcode/QR before the period is closed, plus any transaction dated after the closing dateSystem dataFreeze the snapshot · Status = Closed
I-3Physical goods sitting in each BinPhysical goodsScan each Barcode/QR · enter the physical Count Qty

Step ↔ screen

StepRoleScreen
Search by Close Date · Warehouse · Location → pick the row · Close → confirmWarehouse ManagerStock Closing · Web
In-Progress Txn — review SAVED / SUBMITTED entries still open in the period (optional)Warehouse ManagerStock Closing · Web
Freeze the stock snapshot per Barcode/QR · Status = Closed · a transaction dated after the closing date is reversed out: inbound is subtracted, outbound is added backSystem (auto)Stock Closing
Create count cycle CNT-… — frequency · warehouse · location · PICWarehouse ManagerStock Evaluation · Web
Pick count cycle CNT-… · scan the Bin to countWarehouse StaffStock Evaluation · Mobile
Scan each Barcode/QR · enter the physical Count QtyWarehouse StaffStock Evaluation · Mobile
Submit Count — post the results to Web, no stock changeWarehouse StaffStock Evaluation · Mobile
Compare Snapshot ↔ Count per Barcode/QR · assign 1 of the 7 Barcode StatusSystem (auto)—
Set filters: Close Date · Eval/Trans Date · Warehouse · Location · Item · Barcode · Lot No → SearchWarehouse StaffStock Evaluation Checking · Web
Read the Snapshot ↔ Evaluation grid · quick-filter by status groupWarehouse StaffStock Evaluation Checking · Web
Export — write the filtered result set to an .xlsx file (optional)Warehouse StaffStock Evaluation Checking · Web
Filter variance rows by cycle · warehouse · variance type · pick rows → Create Adjustment (ADJ-YYYY-NNN) · enter an adjustment reason (optional)Warehouse StaffStock Adjustment · Web
Save as Draft · edit the content, submit for review laterWarehouse StaffStock Adjustment · Web
Slip = Pending Approval · the variance rows leave the pending listSystem (auto)Stock Adjustment
Open the slip · review the Before → After table for each rowWarehouse ManagerStock Adjustment · Web
Reject — a reason is mandatoryWarehouse ManagerStock Adjustment · Web
Slip = Approved · the stock adjustment runs at once, per the variance type of each rowSystem (auto)Stock Adjustment
W/H Stock Checking (view-only lookup)Warehouse StaffW/H Stock Checking · Web
Pick a slip in Approved → Cancel · a reason is mandatoryWarehouse ManagerStock Adjustment · Web
Slip = Cancelled · the stock adjustment is reversedSystem (auto)Stock Adjustment

Output

#OutputProduced when
O-1Closing period Status = Closed; Snapshot Qty frozen for each Barcode/QR, with post-closing transactions already reversed outThe Warehouse Manager presses Close and confirms on the modal
O-2Count cycle CNT-… with the system stock lines per BinA count cycle is created on the Stock Evaluation (Web) screen
O-3Count CNT-… submitted, with System / Count / VarianceSubmit Count is pressed on Mobile; every scanned pallet has a Count Qty
O-4File StockEvaluation_[YYYYMMDD].xlsxExport is pressed on Stock Evaluation Checking — it writes exactly the filtered result set
O-5Row Matched — stock agrees, nothing further to handleThe Barcode/QR agrees on Warehouse, Location, Qty, Lot No and PO No
O-6Slip ADJ-YYYY-NNN = Pending ApprovalThe slip is created and submitted straight away, or a slip is submitted from Draft
O-7Slip = Rejected (terminal); the reason is stored in RemarkThe Warehouse Manager rejects a slip in Pending Approval after entering a reason
O-8Slip = Approved; stock now matches the Count: Qty / Lot / Location / Warehouse. Duplicate Scan and Invalid Barcode rows are recorded only, with no stock changeThe Warehouse Manager approves the slip — approving executes it at once, there is no waiting step
O-9Exception: Slip = Cancelled (terminal); stock goes back to its pre-adjustment value; the reason is stored in Remark with the prefix [Cancel]The Warehouse Manager cancels a slip in Approved after entering a reason