PharmaOS Pro — Complete Pharmacy POS System

A fully-featured pharmacy point-of-sale system built with VB.NET Windows Forms and MySQL. Covers every daily pharmacy operation — from selling drugs at the counter to managing suppliers, tracking stock batches, recording expenses, and generating professional end-of-day reports.

This is not a demo. You receive 100% of the source code, the complete MySQL database schema with 38+ tables, and ready-to-use sample data so the system runs from day one.

What the system does

• Sell drugs by packet or by piece with barcode support
• Manage batches with expiry dates, locations, and alert quantities
• Receive stock via supplier invoices and track payment status (paid / partial / pending)
• Record supplier payments with full balance and remaining amount tracking
• Daily report (F8 shortcut) with total sales, profit, cash collected, expenses, and top products
• Advanced cashier report with 12 sections: sales detail, by cashier, payment methods, top products, profit margin, voids, expenses, cash drawer, shift log, prescriptions, and exchange rates
• Multi-cashier login tracking with individual performance reporting
• Void and returns management with admin approval
• IQD and USD dual-currency support with live exchange rate module
• Prescription drug tracking and reporting

All modules included

• POS sales screen
• Drug catalog with generics, classes, brands, dosage forms, and strengths
• Purchase order and stock receiving form
• Supplier management and payment form
• Batch tracker with expiry alerts
• Stock adjustment and history log
• Interactive dashboard with live KPI cards
• Daily report (F8) — simple, clean, fast
• Advanced cashier report — 12 report tabs
• Profit and margin analysis
• Void and sales return module
• Cash drawer session log
• Expense tracker
• Shift login and logout log
• Exchange rate manager
• User and role management
• Audit log

Database

38+ tables covering every aspect of pharmacy management including products, batches, stock-in, sales, cart, payments, voids, returns, users, suppliers, expenses, cash drawer, daily sessions, exchange rates, and audit logs. Full entity relationships with proper foreign keys and indexes.

Technology stack

• Language: VB.NET (Windows Forms, .NET Framework 4.7+)
• Database: MySQL 5.7 or later
• IDE: Visual Studio 2019 or later
• UI library: Guna UI2 (dark professional theme)
• Connector: MySql.Data NuGet package

What you receive

• Full VB.NET project with all forms and modules
• MySQL database creation script (38+ tables)
• Sample data SQL — 40 pharmaceutical products, suppliers, batches, and transactions
• Setup and installation instructions

Built and tested for real pharmacy use. Clean code structure, professional dark UI, and complete documentation. Modify it freely for your pharmacy.

• 100% VB.NET source code — no compiled files, no encryption
• 38+ MySQL tables — complete professional database schema
• POS screen with barcode, packets, pieces, discount, and VAT
• Batch tracking with expiry dates, locations, and stock alerts
• Supplier invoices with paid / partial / pending payment tracking
• One-click supplier payment form with live balance preview
• Daily report via F8 — sales, profit, cash, expenses, top drugs
• Advanced cashier report — 12 sections, date filter, per-cashier filter
• Interactive dashboard with live KPI cards and drill-down detail
• Multi-cashier support with individual shift tracking and performance
• IQD and USD dual currency with exchange rate management
• Prescription drug flagging and dedicated Rx report
• Void transactions with admin approval workflow
• Sales returns with item-level reason and condition tracking
• Expense tracker and net cash reporting
• Cash drawer open/close session log
• Audit log for all user actions
• Sample data included — runs immediately after setup
• Dark professional UI built with Guna UI2
• Fully modifiable — customize for your pharmacy

• Operating System: Windows 7, 8, 10, or 11 (64-bit recommended)
• IDE: Visual Studio 2019 or later (Community edition is free)
• Framework: .NET Framework 4.7.2 or later
• Database: MySQL Server 5.7 or later (MySQL 8.0 recommended)
• Database Tool: phpMyAdmin, MySQL Workbench, or HeidiSQL to import the schema
• NuGet Package: MySql.Data (already referenced in the project)
• UI Library: Guna UI2 (trial version works — download free from Guna.io)
• RAM: 4 GB minimum, 8 GB recommended
• Storage: 200 MB free space for project and database
• Screen Resolution: 1280 x 720 minimum, 1920 x 1080 recommended

No internet connection required — the system runs fully offline on a local machine or local network.

Step 1 — Set up the database

1. Open phpMyAdmin, MySQL Workbench, or HeidiSQL
2. Create a new database and name it pharmacypos
3. Import the file pharmacypos_schema.sql — this creates all 38+ tables
4. Then import pharmacypos_sampledata.sql — this loads products, suppliers, batches, and test transactions

Step 2 — Open the project in Visual Studio

1. Extract the downloaded ZIP file
2. Open Visual Studio and click Open a project or solution
3. Select the .sln file inside the extracted folder
4. Wait for NuGet packages to restore automatically (requires internet on first open)

Step 3 — Configure the database connection

1. Open the file MainUI.vb or the module named DBConnection.vb
2. Find the connection string — it looks like this:

Server=localhost; Database=pharmacypos; Uid=root; Pwd=yourpassword;

3. Replace yourpassword with your actual MySQL root password
4. If your MySQL runs on a different port, add Port=3307 (or your port) to the connection string

Step 4 — Install Guna UI2

1. Go to Tools → NuGet Package Manager → Manage NuGet Packages for Solution
2. Search for Guna.UI2.WinForms and install it
3. Alternatively download the free trial from guna.io and add the DLL reference manually

Step 5 — Run the project

1. Press F5 in Visual Studio to build and run
2. The login screen will appear — use the default credentials included in the instructions document
3. The POS main screen loads after login

Default login (sample data)

• Username: admin
• Password: admin123

Key shortcuts inside the system

• F5 — Refresh / search products
• F7 — Open expenses form
• F8 — Open daily report
• F9 — Change password
• ESC — Close current form

If you have any issues during setup, use the support message button on the Codeester product page and describe the error — support response within 24 hours.