LIN MAN INVENTORY SYSTEM V1.00
⚙

Inventory

Inventory & Meter Lifecycle Management — PostgreSQL-backed. Production requires an explicit Production Request. Calibration PASS is required only for products that follow the calibration workflow. Total Assets includes Received + Ready + Calibration + Production + Meter Shop + Failed.

▣
0
Total Assets
click to view all assets →
☑
0
Ready
post-Meter Shop
🔬
0
Calibration
click for detail →
⚙
0
Production
request required →
🔧
0
Meter Shop
click for detail →
⚠
0
Failed
click for detail →
📦
0
Received
available inventory
Received + Ready + Calibration + Production + Meter Shop + Failed = Total Assets
Active Vendor – PO
Vendor PO Vendor Model Ordered Received Remaining Status
Loading…
Open Vendor POs only. View opens receiving details and history for that PO.
Active Client – PO
Client PO Client Model Ordered Delivered Remaining Status
Loading…
Active Client POs (Confirmed / Partially Fulfilled). View opens Client PO detail.

Master Inventory

Central Asset Register — meters, cabinets, DCUs, repeaters and other controlled property.

All AssetsTotal Assets excludes sold/disposed assets
Asset IDTypeMeter Type / ModelDescriptionPhysical SerialLin Man SerialStatusLocationVendor POClient POUnit CostUnit Price
Loading…

Calibration Cycle

Request → Issue → calibrate on external tool → Upload results Excel (multi-tranche) · Client PO link optional

0
Issued to Calibration
0
Pending results
0
PASS Results
calibration results
0
Total in Calibration
Open Calibration Requests
Request ID Model Qty Req Issued Passed Failed Still needed Uploads Status
Loading…
Scanning is done on the external calibration tool. Results enter this system only via Excel upload (multiple tranches per request allowed). Request closes when unique Passed = Requested. Fail/Duplicate do not count toward close.
Recent result uploads
When Request File Rows Pass Fail Dup Uploaded by
Loading…

Issue to Calibration

Handoff from Received stock · Quantity only · Physical calibration runs on external tool

Request context
After issue, meters are calibrated on the external system. Results come back via Upload results (Excel), not via in-app scanning.
New issuance
Issuance history — this request
WhenQtyCalibratorIssued by
No issuance history for this request.

Upload Calibration Results

Accuracy Test Report (.xlsx) from Calibration Department · Stored per request · Multi-tranche · View full results

Request context
Standard upload format — Accuracy Test Report (Lin Man Calibration Department)
Serial No Meter No. * Error COS=1.0 @ 0.1Ib Error COS=1.0 @ 1Ib Error COS=0.5L @ 1Ib Result *
No sample data. The uploaded Accuracy Test Report is parsed and stored here after processing.
Matches external tool export Accuracy Test Report. Parser skips title/header rows; data rows require Meter No. + Result (Pass/Fail). All columns stored in DB against the Calibration Request + upload tranche.
Upload tranche
The request is quantity-based. At Issue, the system assigns the physical meter serials from Master Inventory. During upload, Meter No. is matched to those issued serials; extra Excel rows are marked Unassigned and do not affect PASS/FAIL totals. PASS → CALIBRATION - PASSED · FAIL → CALIBRATION - FAILED · Duplicate → no count. Multiple uploads are allowed until the issued meters are fully processed.
Upload history — this request (tranches)
TrancheWhenFileRowsPassFailDupUnassignedBy
No uploads for this request

Calibration Results (stored)

Selected request · All tranches · DB-backed line items

0
Pass rows
0
Fail rows
0
Duplicate
0
Total stored rows
Assigned to request: 0 · Stored results: 0 · Remaining assigned: 0
Line results linked to this Calibration Request Filter: All · Pass · Fail · Dup
Tranche Serial No Meter No. Err COS1 0.1Ib Err COS1 1Ib Err COS0.5L 1Ib Result Stored at
No calibration results stored for this request.
Data is persisted against the calibration request. Closed request → Excel 1 exports PASS rows only.

Calibration Request

Selected calibration request · Model / quantity loaded from DB

0
Requested
0
Issued
0
Passed
0
Failed
0
Still needed
Issuance log
WhenQtyCalibratorIssued by
No issuance history
Result upload tranches
TrancheWhenFilePassFailDupUnassignedBy
No result uploads
Each Excel row is stored against this request. Use View full results for the complete calibration data set.

Production Cycle

Request → Capture meters (scan ENERTEK + Lin Man Serial) → automatic completion → View / Export

0
Issued to Production
after explicit Issue
0
In Production
0
Production Complete
0
Total in Production
Open Production Requests
Request IDModelQtyIssuedCompletedStill neededStatus
Loading…
Capture opens the meter scan grid (one row per issued unit). Assigned serials come from the exact physical assets issued from Master Inventory. Scanner fills the matching row (VLOOKUP by assigned serial).
Recent capture sessions
WhenRequestQty issuedAssigned toIssued by
Loading…
Automatic completion: once the scanned/matched quantity equals the requested quantity, the Production Request is automatically marked COMPLETE. Use View to review the captured meters and generate the output files.

Production Meter Capture

One row per request qty · Assigned serial pre-filled · Scan ENERTEK serial → system matches row, then scan Lin Man Serial

Request context
On open, staff sets units per box. Box numbers are assigned automatically (row 1…N → Box 1, 2, …). Assigned serial is the exact physical Master Inventory serial issued to this request. Scan ENERTEK serial → match the assigned physical asset. Then scan the Lin Man serial to complete the row.
Scanner
Meter lines (Assigned serial pre-filled) 0 / 0 matched
# Box No. Assigned serial (reserved) ENERTEK serial (scanned) Lin Man Serial Status

View Production Request

Review captured meters · Production is automatically completed when scanned quantity equals requested quantity

Request context
Automatic completion: the Production Request status is updated to COMPLETE automatically when the number of successfully scanned/matched meters equals the requested quantity. There is no separate Complete button.
Captured meter details
#BoxAssigned SerialENERTEK SerialLin Man SerialStatus
Loading…
Output files
MeterShop output is generated from the captured product/ENERTEK serials and the calibration results already stored in the database.

Failed / Exception Statuses

For Return to Supplier · Returned · Repair · Scrap

0
For Return to Supplier
0
Returned
0
Repair
0
Scrap
For Return to Supplier (Failed Calibration / Duplicate Serial)
Vendor SerialReasonOriginal RequestVendor PODate
Loading…

Create Calibration Request

Production Manager only · Client PO / Product Configurator item + quantity · Results via Excel upload from external tool

New Calibration Request
Select a Client PO when applicable. The PO line automatically determines the model, and availability is read from actual Received Master Inventory. Without a PO, the request remains model-based.

Create Production Request

Hierarchy: Client PO (optional) → Model / Product → Master Inventory stock → Quantity · Availability is based on actual physical assets in Master Inventory

New Production Request
Workflow gate: Production availability is read from Master Inventory. Calibrated models use physical assets marked CALIBRATION - PASSED; products without a calibration workflow may proceed from RECEIVED stock. Submitting creates the Production Request only; physical assets remain in their current status until Issue.
1. Select Client PO only when you want to restrict the available Master Inventory to that Client PO (optional).
2. Select a Model / Product that has available physical stock.
3. Quantity cannot exceed the actual available Master Inventory stock. Serial Min/Max are informational and come from the actual available assets; Issue/Capture uses the exact physical serials.
Calibrated models use PASS stock. Other products may proceed directly from received inventory.

Meter Shop Cycle

From Production Complete → Meter Shop → Ready · Client PO mandatory

0
In Meter Shop
0
Ready (post-MS)
0
Open MS Requests
0
Available for Meter Shop
Open / Active Meter Shop Requests
Request ID Client PO Model Qty Completed Status
Loading…
Client PO is mandatory. Production explicitly routes the physical meters to METER SHOP first. Creating the request automatically starts Meter Shop work; Complete moves the meters to READY.

New Meter Shop Request

Client PO is mandatory · Source: Production Complete only

Request
Select PO first; model and available Meter Shop stock will populate automatically. Draft POs are not listed.
Without a Confirmed / Partially Fulfilled Client PO, submit is blocked. Serials are bound to the Client PO when the Meter Shop request is explicitly issued.

PO – Client

Client Purchase Orders · NEA Electric Cooperatives · Links to Inventory

Open / Active Client POs
PO – Client Client Date Status Qty Ordered Qty Delivered Remaining
Loading…
Only Confirmed and Partially Fulfilled POs appear in workflow selectors. Calibration, Production, and Meter Shop can use Client PO traceability.

New PO – Client

Commercial order from NEA coop · Must link a Pending quotation · Header fields editable · Line product/price locked to quote

Source quotation (Pending only)
Only issued Pending quotes. Selecting a quote loads client + line items. Product, quantity, and unit price stay locked to the quote.
Header
Taken from quotation (not free-selected)
Line Items (from quotation — product & price locked) Select a Pending quotation to load lines
# Item / Model * Qty Ordered * Serial Min (optional) Serial Max (optional) Unit Price Line Notes
No quotation selected — line items load from the Pending quote

PO – Client

—

—
0
Qty Ordered
0
Qty Allocated
0
Qty Delivered
0
Remaining
Lines
#ModelOrderedAllocatedDeliveredRemaining
Loading…
Inventory / Supply Check
The system checks physical stock in Master Inventory. On Hand includes received/in-process units; Ready can be allocated immediately. A Vendor PO is needed only when physical on-hand stock is below the Client PO requirement.
ModelOrderedOn HandReadyIn ProcessAllocatedShortageAction
Checking Master Inventory…
Vendor PO Supply SourcesLink supplier PO quantities to this Client PO before individual meters are READY.
Loading Vendor PO sources…
Supply Sources / Physical Assets
Loading asset supply…
Vendor POVendorModelAssetsStatus
Loading…
Linked Inventory Requests
RequestTypeModelQtyStatus
No linked inventory requests
Link existing Calibration, Production or Meter Shop requests to this Client PO for traceability.

SIM Management

Manage SIM inventory, assignments and deployment information.

0
Total SIMs
0
Available
0
Active
0
Other Status
SIM Inventory
SIM IDSIM NumberTelcoEC CodeDeployment StartDeployment EndStatusRemarksActions

Reports

Operational reports for inventory, procurement, receiving, client fulfillment and calibration.

Operational Reports
Inventory Position

Current stock by model and inventory status.

Vendor PO Status

Ordered, received and remaining supplier quantities.

Receiving History

Delivery receipts and received quantities by Vendor PO.

Client PO Fulfillment

Ordered, allocated, delivered and remaining quantities.

Calibration Results

Pass/fail/duplicate result counts.

Report Output
Select a report above.

Analytics

Management KPIs and operational trends from the current database.

0
Vendor POs
0 remaining
0
Active Client POs
0
Quotes
₱0.00
0%
Calibration Pass Rate
Inventory by Status
StatusQuantity
Commercial Pipeline
StatusQuotesValue

Vendor PO

Create & track supplier POs · Receive opens Goods Receipt for that PO only · Status Open until fully received

Vendor PO Dashboard
Vendor PO Vendor Model PO Date Ordered Received Remaining Status Last Receipt
Loading…
Workflow: Click Receive on an Open PO → Goods Receipt opens with that PO locked in the header. Open POs may also be Cancelled before completion; cancellation stops further receiving while preserving any quantity already received. Receiving is not a separate side-menu item.

Goods Receipt

Receive the physical shipment. Enter the supplier Delivery Receipt and the physical serial range; the system creates the corresponding Master Inventory assets automatically.

Vendor PO Receiving Summary Open
Locked to the selected Vendor PO
Must match the Vendor PO item
Required and must be unique
If linked to this Vendor PO, Client PO Serial Min/Max are prefilled but remain editable before posting. Client PO unit price is carried to Master Inventory Selling Price.
Commercial unit price from the selected Client PO; carried to Master Inventory Selling Price.
Automatically taken from the logged-in user
System-generated after posting
0
Ordered
0
Already Received
0
Assets Created
0
Remaining
Select a Vendor PO to see its receiving balance.
Shipment Details
Enter the quantity that physically arrived and its supplier serial range. The system validates that the range contains exactly the quantity.
Waiting for serial range
# Item / Model Qty Received Physical Serial Min Physical Serial Max Assets to Create
Example: Qty 1,000 · Serial Min KFA000001 · Serial Max KFA001000 → 1,000 Master Inventory assets created automatically.
Receiving Notes
What happens when you post: Each physical serial becomes one Master Inventory asset with the Vendor PO, Receiving, Model, Description, Vendor and received date linked automatically. Status starts as RECEIVED at Warehouse. Lin Man Serial stays blank until Production Capture / Packaging.
Receiving History This Vendor PO only
Receiving ID Delivery Receipt Date Model Qty Physical Serial Range Assets Created Posted By
No receiving history yet.
Receiving history will appear here after a receipt is posted.

Issue Quotation

NEA Electric Cooperatives only · Wizard: EC → Product & Plan → Review → Confirm · PDF on demand (not stored)

1 · Electric Cooperative
2 · Product & Plan
3 · Review Pricing
4 · Confirm & Issue
Step 1 — Electric Cooperative

Product Configurator

Reference master data for products and pricing templates. Existing quotation calculation remains unchanged.

Template header
Line items
CategoryDescriptionCost typePricing basisCurrencyCostPHP
Historical versions
Config IDProductRateMarkupInflationItems

Pricing Dashboard

Sales pipeline · Status is informational only · Workflow: Pending → Draft PO → Converted to PO · Cancelled

0
Total Quotes
0
Pending
₱0.00
0
Converted to PO
₱0.00
0
Completed
₱0.00
Quotations
Ref / DateECConfigQty / TermTotalStatus

Electric Cooperatives

Reference master data used by quotations.

Electric Cooperative Master List
AcronymCooperativeRegionMain OfficeGeneral ManagerGM Contact

Vendors

Vendor master records for purchasing.

Vendor Master List
CodeVendorContactNumberEmailStatus

Payment Terms

Reference payment terms. Supports one-time, day, month and year terms.

Payment Term Master List
CodeNameTermDescriptionStatus

User Management

Manage users, status, roles and passwords. Authentication remains in inv.users; authorization is stored separately.

Users
NameEmailRoleStatusActions

Roles & Permissions

Create roles and assign exactly which modules/actions each role can access.

Roles
RoleDescriptionPermissionsStatusActions
Permission Catalog
ModuleActionCodeDescription

Authorization Audit Log

Recent user, password and authorization changes.

Audit Log
DateUser IDActionTargetDetails

Change Password

Change the password for the currently signed-in database user.