Inventory position
Catalog SKUs
—
Active Product Master rows
Stocked SKUs
—
— active lot rows
Available Units
—
Inventory available by LOT
Checked-Out Units
—
Units currently outside store
Stock ownership
Purchase Stock
—
Swami-owned available units
STC Stock
—
Short-term consignment units
LTC Stock
—
Long-term consignment units
Movement Ledger
—
Canonical stock events
Management attention
Reorder Alerts
—
Only configured reorder levels count
Expiring ≤ 90 Days
—
Active stocked lots needing rotation
Expired / Blocked Lots
—
Should not be dispatched
LOT Expiry Conflicts
0
0 lot row(s) need expiry review
Active Challans
0
0 not returned · 0 unreconciled
Pending Vendor Receipts
0
0 line(s) · 0 invoice(s)
Pending Consignment Receipts
0
0 line(s) · 0 DC(s)
Pending Billing Instructions
0
0 STC/LTC usage line(s)
Reorder Attention
Top configured low-stock exceptions
Catalog-only rows with reorder level 0 are not treated as low-stock alerts. Set reorder levels only for items you actively stock.
| SKU | Name | Category | On Hand | Reorder | Shortage | Location |
|---|
Recent Transactions
| Date / Time | SKU | Product | Type | Delta | Balance | By |
|---|
Inventory
Active Catalog Items
—
Product Master rows
Stocked Products
—
Has active lot stock
GTIN Mapped
—
Barcode-ready products
Missing GTIN
—
Needs mapping before scanning
Pending Candidates
—
Need GTIN / approval
Available Units
—
From inventory lots
Checked-Out Units
—
Outside warehouse
Expiring ≤ 90 Days
—
Lot-level risk
Expired / Blocked
—
Do not dispatch
Inventory
Product Master, current stock position, exceptions and lot detail.
On-hand values below are aggregated from inventory_lots. SKU is derived from normalized REF and no longer needs manual entry.
Loading products…
Daily Operations Dashboard
Business action view for DCs, check-ins, pending receipts, candidates, expiry, reservations, and audit exceptions.
Today
Draft DC soft reservations
Stock held by Draft DC lines until the draft line/DC is deleted, cancelled, or dispatched.
| Draft DC | Hospital | REF / Product | LOT | Warehouse | Reserved | Updated |
|---|
Expiry Report
Inventory lots with stock already expired or expiring soon. Default view is within 60 days from today.
Lot Rows
—
Rows in selected view
On Hand Units
—
Physical stock in warehouses
Checked Out Units
—
Outside store but still expiry-risk stock
Total Units
—
On hand + checked out
Expiry detail
Expiry dates display as YYYY-MM-DD.
| REF / Product | LOT | Expiry | Days | Warehouse | Owner | On Hand | Checked Out | Total | Status |
|---|
Quick Product Lookup
Kiosk-style REF, GTIN, barcode scanner and product photo lookup. Lookup only; it does not create Product Master rows or stock.
Barcode scanner
Photo lookup
Manual search
Type at least 3 characters to search.
Quick Lookup · Phone Companion
Audit-style phone session review for lookup-only barcode and photo submissions. Successful results flow into the staging table below.
Quick Lookup Phone QR
Lookup-only companion session
Mobile link
Scan this QR code with the phone used for lookup-only barcode and photo submissions.
Barcode evidence
Lookup alerts / errors
Latest unresolved scanner/search/photo errors appear first and stay until you leave the screen.
Lookup staging area
Latest successful lookup result appears first. Reference-only rows mean Stryker knows the REF, but IMS Product Master is missing it.
Draft DC basket
Review rows available in the selected source warehouse. Qty defaults to 1.
Admin Product Candidate Review
Admin-only triage for Product Master candidates captured from receipt/lookup workflows. Approving here creates the clean Product Master row but never creates stock.
Use Approve & Add Product, Needs GTIN, or Reject to triage candidates. Approval creates the Product Master row immediately; stock is still added only by receipt/invoice commit.
| REF / Candidate | GTIN | Vendor | Status | Reference | Source | Notes | Actions |
|---|
Stock Locations / Warehouses
Master data for physical/logical stock locations. Hospital/vendor links are optional by type and warehouse address is the operational shipping address.
Master Data Management: maintain Hospitals, Vendors, and Stock Locations here. Locations with inventory or product references are marked inactive instead of deleted.
| Code | Name | Type | Dispatch | Linked Hospital | Linked Vendor | Address | Default | Status | Notes |
|---|
Hospital Master
Controlled hospital list for Hospital Checkout, Hospital Parking, transfers, returns, and billing instruction reporting.
| Code | Name | City | Address | Contact | Status | Notes |
|---|
Vendor Master
Controlled vendor list for Vendor Return challans and vendor-linked hold warehouses.
| Code | Name | City | GSTIN | Contact | Status | Notes |
|---|
Manual DC Item Master
Common tray, instrument, power-tool and accessory rows used in Delivery Challans. These do not consume inventory lots.
Typeahead in + Tray / accessory row uses this list. Rows still save as separate DC lines for check-in tracking; condensed print can merge them for readability.
| Item | Category | Qty | Brand | Ownership | REF | LOT | Status | Actions |
|---|
Stock Adjustment
Controlled Stock Removal
Total Removed Units
—
Vendor returns + write-offs
Vendor Return Units
—
Purchase/STC/LTC returns
Write-off Units
—
Expired, damaged, opened, lost
Removal Actions
—
Supervisor-approved records
Controlled Stock Removal
Purchase/STC/LTC vendor returns and expired/damaged/opened/lost write-offs. Available stock only; checked-out stock must be returned first.
Use this screen only for stock physically present in a warehouse. Stock still out under a Delivery Challan must be processed through DC Check-in / Return or Billing Instruction first. Quantity cannot exceed available lot stock, ownership must match the selected return type, expired write-off accepts only already-expired lots, and supervisor approval is required. Each commit reduces inventory and writes the movement ledger.
Optional unless Swami wants a vendor-specific register later.
Only warehouse-available stock for the entered REF is shown. DC checked-out stock must be returned through DC Check-in first.
Quantity options are capped at the selected LOT's available stock.
Business date display is DD-Mon-YYYY. No MM/DD/YYYY.
Required for vendor returns.
Optional file evidence, max 20 MB. Use PDF or photo.
Vendor Return / Write-off Register
Completed removal actions with evidence and movement-ledger linkage.
| Date | Action | REF | Description | LOT | Owner | Qty | Warehouse | Reference | Approved | Evidence |
|---|
Recent Audits
Open an existing multi-day count, or start a new audit.
Physical audit capture does not update inventory. Count first, then export or reconcile. Reconciliation shows only mismatches; fully tallied rows are excluded.
| ID | Audit | Status | Started | Ended | Count | Action |
|---|
Movement Ledger
Canonical stock movement audit trail with ownership, warehouse flow, document source and user.
This is the source-of-truth movement audit trail. The old legacy transaction log is intentionally hidden from the UI.
| Date / Time | REF/SKU | Product | Movement | Owner | LOT | Qty / Direction | Flow | Document | By |
|---|
Bulk Add — Upload Image
Scan labels, scan barcodes, manually add rows, or download the opening-stock Excel template.
Upload Stryker implant label photos. OCR captures REF, LOT and expiration date, then looks up REF against Product Master.
Drop image here or browse
JPEG · PNG · WebP — max 20 MB
Batch stock ownership
OCR and scanner rows in this batch will commit to this ownership bucket.
Barcode scanner input
Works with USB/Bluetooth scanners that type into the focused box. Also accepts pasted GS1 text for local testing. Product Master must match; inventory availability is not required for Bulk Add.
or
ⓘ Scan profile selector
ⓘ One-call OCR tuning
ⓘ Relevant only outside Google-only mode
ⓘ Experimental — normally off
ⓘ Clears old debug images, then captures this scan
Implant Registry
| Brand | Family | REF | LOT | Type | Joint | Size | Taper | Fixation | Side | Expiry | Sterile |
|---|
Delivery Challan History
Latest delivery challans, dispatch/return status, and hospital/vendor movements.
| Challan # | Type | Date | Destination | Doctor | Items | Sent | Returned | Used | Status | Actions |
|---|
Purchase Invoice History
Latest purchase invoices, receipt status, and committed audit records.
| Invoice | Date | Supplier | PO Ref | Lines | Grand Total | Status | Uploaded |
|---|
Pending Vendor Receivables
Missing received quantities across all committed purchase invoices.
Use this when Stryker invoiced an item but it was missing from the carton. Receive it here when it arrives later.
—
| Invoice | CAT / REF | Description | LOT | Expiry | Pending | Warehouse | Status |
|---|
Consignment Receipt History
Latest incoming vendor DC receipts, STC/LTC ownership, and committed audit records.
| DC | Date | Vendor | Ownership | Lines | Status | Uploaded |
|---|
Pending Consignment Receivables
Missing received quantities across all committed incoming consignment DCs.
Use this when Stryker/vendor sent a DC line but one or more items were missing from the carton. Receive it here when it arrives later.
—
| DC | Ownership | REF | Description | LOT | Expiry | Pending | Warehouse | Status |
|---|
Application Users
Login users, roles, status, password resets and lockout recovery. Admin-only.
Use separate user IDs for audit contributor tracking and role-based screen access. The default admin/self-protection rules remain enforced.
| Username | Status | Role | Admin | Created | Reset Password | Actions |
|---|
Import History
Recent Product Master refresh batches. Open a batch to review, commit, rollback, export, or delete uncommitted imports.
| ID | Status | Vendor | File | Uploaded | Rows | New | Updates | Skipped | Warnings | Errors | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|
| No import history loaded. | |||||||||||
Vendor GTIN Reference Cache
Upload the official vendor GTIN/catalog reference once. Product candidates and Stryker refresh validation can reuse the active cache.
For Stryker, use StrykerGTINdownload.xlsx.
No reference cache loaded.
Product Master Refresh
Admin-only vendor-scoped Excel/CSV staging, analysis, review, commit, error export, and rollback.
Vendor is selected in IMS and does not need to exist in the file. Item Code is the canonical product key. Grouping becomes Product Short Name for Condensed DC. REF lookup normalization removes spaces and separators such as /, -, and + while preserving vendor display REF fields. Stryker refreshes use the active Vendor GTIN Reference Cache automatically; upload the cache once in the Vendor GTIN Reference Cache card before refreshing Stryker products.
Select a vendor to check validation cache status.
Detected Column Mapping
Edit source column names only if the auto mapping did not identify the vendor file correctly, then re-analyze before commit.
No import selected.
Rows
—
Uploaded rows
New
—
Products to create
Updates
—
Existing products changed
Unchanged
—
No change
Skipped
—
Skipped by rule
Warnings
—
Review recommended
Errors
—
Commit blocked
Current Import Review
No import selected.
0-0 of 0
| Status | Action | Sheet | Row | Item Code | Packing REF | GTIN | Description | Grouping | HSN Code | GST % | Finding |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Upload or open a Product Master file to review rows. | |||||||||||