DevNexa.
Digital Product Engineering Studio

We build digital products that move businesses forward.

System Status● WebGL & 3D Shaders Initializing
0%

ERP & POS

Selected Work

Medical ERP

An offline Windows billing and stock app for a local medical shop, with batch and expiry tracking and PDF invoice import.

Client

Local Medical Shop

Industry

Pharmacy / Retail Healthcare

Services

Enterprise ERP & POS Systems, Cross-Platform Desktop Apps, Inventory Management

Status

Production

The Challenge

A pharmacy needs very fast billing, correct batch and expiry handling and GST compliance, on a single PC that may have no reliable internet.

The Solution

We built a keyboard-first billing screen that picks the nearest-expiry batch automatically, suggests same-salt substitutes, and imports distributor invoices from PDF, photo or CSV, all backed by local SQLite with scheduled backups.

My Contribution

  • Electron and React desktop application with local SQLite
  • Keyboard-driven billing with hold bills and substitutes
  • Batch, expiry and reorder-level stock logic
  • Purchase entry with PDF, photo and CSV invoice import
  • Returns that restore stock to the original batch
  • Dashboard with sales, profit, expiry and dues alerts
  • Role-based access to cost and margin data

Key Features

  • Offline-first with automatic daily backups
  • Search by medicine, salt or barcode
  • Nearest-expiry batch selection
  • Substitute medicines by salt and strength
  • Purchase costing and margin display
  • CSV import and export
  • Bills, returns and reprint
  • Daily sales reports

Technology

ElectronReactTypeScriptSQLitebetter-sqlite3Tailwind CSSVite

Results

The shop bills faster with fewer expiry and stock errors, and keeps full records on its own PC with no server or subscription.

Have a similar project?