Mastering Core Workflows and Features of an Inventory Management System

Overall Closed‑Loop Process

The top‑level workflow follows a closed loop: Procurement inbound → Inventory storage → Sales outbound → Financial reconciliation → Cost accounting → Procurement planning iteration.

Demand initiation: sales order triggers stock‑out alert, generating a purchase request.

Procurement execution: supplier selection, ordering, receipt, inspection, inbound, and accounts payable creation.

Warehouse operations: inbound shelving, inventory counting, transfer, assembly, returns, and stock locking.

Sales execution: customer order, order review, picking, shipping, and accounts receivable generation.

Fund settlement: collect customer payments, pay suppliers, record expenses, and clear receivables/payables.

Accounting review: automatic calculation of gross profit, inventory cost, obsolete stock, and performance reports.

Reverse flow: purchase returns, sales returns, exchanges, and repair loops feed back into inventory and accounts.

Core Modules and Detailed Flows

1. Procurement Management ("In")

Full procurement workflow: purchase request → supplier inquiry/comparison → purchase order (PO) → receipt → optional quality inspection → inbound receipt → invoice entry → accounts payable generation → payment clearing → purchase return closure.

Supplier records include name, contact, bank, payment terms, tax rate, quotation, cooperation level, status, and blacklist flag.

Product purchase baseline prices track historical cost, minimum cost, maximum limit, and suggested purchase price.

Approval flow supports small‑amount direct purchase, large‑amount multi‑level approval, and departmental budget control.

Document chain:

Purchase request automatically generated from stock‑out alerts, specifying quantity, date, and purpose.

Inquiry sheet records multiple supplier quotes and produces a comparison report for optimal selection.

Purchase order locks product, quantity, unit price, tax rate, delivery date, supplier, deposit, and breach liability; allows partial receipt, batch inbound, order change, cancellation, or termination; automatically links to inbound to prevent over‑receipt.

Receiving sheet captures delivered quantity; items await quality inspection before final storage.

Quality inspection determines acceptance, rejection, rework, exchange, or return.

Inbound receipt updates real‑time stock quantity and weighted average cost; supports multi‑warehouse, batch, serial number, production date/expiry.

Invoice management separates price and tax, matches inbound receipt, and creates payable entries.

Payment and payable clearing handle bank transfers, acceptance bills, prepayment offset, and payable reduction; prepayments can offset later orders.

Purchase return: defective or slow‑moving stock triggers a return request, warehouse issues outbound, generates a negative payable, and supplier refunds or offsets the amount.

Statistics: supplier supply ranking, cost trends, monthly budget execution, on‑time receipt rate, defect rate, and payment term utilization.

2. Inventory Management ("Store")

Complete inventory workflow: various inbound types (procurement, production, transfer, gifts, surplus) → shelving → daily control → various outbound types (sales, internal use, transfer, loss) → inventory counting → alerts → adjustments.

Warehouse architecture includes multiple warehouses (central, store, outsourced, remote, virtual) and precise location coding for picking optimization.

Inventory attributes cover batch, serial number (SN), expiry, color/size/spec, and multi‑unit conversion.

Permissions restrict staff to their own warehouse data.

Eight inbound categories: procurement, transfer, production, sales return, surplus, gifts, borrowing, repair return.

Ten outbound categories: sales, transfer, production consumption, purchase return, loss, samples, gifts, internal use, borrowing, scrap.

Key documents:

Transfer order balances stock across warehouses, supports cross‑warehouse transfer and in‑transit tracking.

Other inbound/outbound documents handle gifts, internal use, scrap, borrowing, etc.

Inventory counting modes: full, spot, cycle, blind; mobile scanning supported; generates surplus/shortage documents and auto‑adjusts accounts.

Counting freeze locks documents during audit to prevent interference.

Adjustment documents modify price, loss, damage, or unit changes manually.

Assembly/disassembly handles kit products: assembling consumes components and creates finished goods; disassembly reverses the process.

Fine‑grained control rules:

Stock alerts for minimum (stock‑out) and maximum (overstock) thresholds, with automatic procurement reminders.

Expiry alerts prioritize outbound and lock expired items.

Batch/serial management enables FIFO or FEFO for traceability.

Stock locking prevents overselling; unapproved orders do not reserve stock.

Available stock = book stock – locked stock – pending outbound + pending inbound.

Analysis reports: real‑time ledger, balance sheet, transaction detail, slow‑moving stock, turnover rate, age analysis, backlog warnings, expiry reports, inbound/outbound summaries.

3. Sales Management ("Out")

Full sales workflow: customer inquiry → quotation → sales order → order review → stock check & lock → picking & packing → outbound receipt → logistics → sales invoice → accounts receivable → payment clearing → sales return closure.

Customer master data includes classification, contacts, credit terms, credit limit, settlement method, custom pricing, region, and blacklist flag.

Pricing system supports retail price, wholesale price, tiered customer pricing, promotional discounts, and minimum price enforcement.

Credit control caps credit limit, blocks orders beyond limit, and enforces cash‑on‑delivery when necessary.

Sales documents:

Quotation retains versioned offers and can be converted to a sales order with locked validity.

Sales order captures product, quantity, price, tax, delivery date, shipping warehouse, payment method, and deposit ratio; supports split shipments, partial delivery, order change, termination, and cancellation.

Automatic stock verification prompts out‑of‑stock and triggers procurement request.

Order statuses: pending review, pending outbound, partially outbound, completed, closed.

Picking/packing list generated from order, optimized by location.

Outbound receipt deducts stock and records cost of goods sold.

Shipping document records tracking number and carrier for customer reconciliation.

Sales invoice separates price and tax, matches outbound receipt, and creates receivable.

Payment receipt handles cash, credit settlement, prepayment offset, and bill collection; prepayments can lock subsequent orders.

Sales return: customer initiates return, inbound receipt adds stock, negative receivable reduces amount, refund or offset applied; supports full, partial, or defective returns.

Promotions and special sales modes: special price, full‑reduction, bundle, member discount, tiered bulk pricing, consignment, resale, pre‑sale, cash‑on‑delivery, credit sale, installment, store retail billing.

Sales analysis: customer sales ranking, product hot‑sale ranking, gross profit details, salesperson performance, monthly revenue summary, order fulfillment rate, return rate, receivable aging, regional sales proportion.

4. Financial Management (Accounts & Settlement)

The system does not implement a full general ledger but covers receivable, payable, pre‑receipt, pre‑payment, expenses, and cost, interfacing with external accounting packages.

Core financial workflow: purchase inbound → accounts payable → payment clearing; sales outbound → accounts receivable → receipt clearing; expense entry → cost aggregation → gross profit calculation; month‑end closing.

Four core ledgers:

Accounts payable generated automatically from purchase inbound; cleared after payment; includes due‑date reminders and aging analysis.

Accounts receivable generated from sales outbound; cleared after receipt; includes overdue alerts and bad‑debt flags.

Pre‑receipts record customer deposits, later offset against orders.

Pre‑payments record supplier advances, later offset against purchases.

Financial documents: receipt, payment, expense reimbursement, other income/expense (rent, freight, labor, misc), bank deposits/withdrawals, transfer vouchers.

Inventory cost accounting uses three mainstream methods, calculated automatically:

Moving weighted average (common in trade): unit cost refreshed on each inbound, outbound pulls current weighted cost, smoothing cost fluctuations.

FIFO: earliest inbound items shipped first, suitable for batch/expiry management.

Specific identification: per‑serial‑number costing for high‑value items.

Automatic calculations produce per‑sale gross profit, monthly gross profit, total cost, and inventory book balance.

Month‑end closing locks current period documents, rolls cost forward, generates monthly operating reports, and prohibits cross‑period modifications.

Financial reports: receivable summary, payable summary, reconciliation letters, cash flow ledger, profit & loss statement, expense statistics, cash balance ledger.

Extended Functional Modules (Standard to Advanced)

Basic archive module supports all document foundations: product master (code, name, specs, unit, category, barcode, tax, min/max stock, image, attributes, multi‑package conversion), staff, department, warehouse, account (corporate/personal/WeChat/Alipay), settlement methods, tax templates, approval workflow templates.

CRM‑embedded sales‑person & customer management: performance attribution, commission rules (based on gross profit or sales), customer follow‑up records, tier maintenance, one‑click export of customer reconciliation.

Mobile support: PDA/phone scanning for inbound, picking, counting, field sales entry, real‑time stock query, mobile approval.

Production module (trade‑manufacturing integration): BOM formulation → production planning → material issue → finished‑goods inbound → process control, loss accounting, cost allocation.

Retail POS module for offline stores: cash billing, member points, stored value, receipt printing, store‑level inventory sync, store‑to‑head‑office requisition.

E‑commerce integration: automatic order pull from platforms (Taobao, JD, Douyin, Pinduoduo) → one‑click sales outbound generation → automatic inventory sync to prevent overselling.

Warning center provides multi‑dimensional alerts: stock‑out, overstock, near‑expiry, customer credit excess, receivable overdue, payable due, unreviewed document reminders.

Business Validation Rules (Data Integrity)

Strong document linkage prevents over‑inbound/outbound quantities, eliminating phantom stock changes.

Negative stock control can be toggled; strict mode forbids negative outbound to preserve cost accuracy.

Document audit workflow: draft → audit → effective; audited documents cannot be deleted, only reversed with negative entries.

Full‑process logging records creator, modifier, and timestamps for every document.

Real‑time multi‑device synchronization ensures PC, mobile, and store inventories stay consistent.

Three‑way reconciliation ties procurement, sales, and financial accounts, matching business and cash flows.

Functional Differences Across Three Business Scenarios

Pure trade wholesale version emphasizes supplier comparison, customer tier pricing, accounts, gross‑profit calculation, and multi‑warehouse transfers.

Trade‑manufacturing version adds BOM, production material issue, work orders, production cost accounting, and process management.

Retail store version includes POS cash register, membership, stored value, store transfers, promotional marketing, and offline‑online inventory integration.

Core Value Summary

Inventory transparency: real‑time view of truly available stock prevents blind purchasing, overselling, and excess loss.

Clear receivable/payable: no missing items, overdue risk controllable, bad‑debt reduced.

Precise cost: automatic gross‑profit calculation reveals per‑order profitability, guiding pricing strategy.

Standardized processes: unified procurement‑warehouse‑sales procedures enable rapid onboarding.

Decision‑ready data: diverse reports support replenishment, customer segmentation, slow‑moving stock clearance, and salesperson performance assessment.