Editing an existing medicine. Batch/price fields below are for new medicines only and are hidden while editing — use Stock Adjustment to change stock/batches. Cancel edit
Quick Add Category / Manufacturer
Stock Movement
Use this to test stock in/out. Later purchase and sales modules will create these movements automatically.
Bangladesh pharmacy workflow: first see supplier/company list, then view products supplied by that supplier.
Supplier Code
Supplier Name
Address
Contact Person
Contact Number
Product Count
Action
Products Under Supplier
Product Name
Generic Name
Group
Company
MRP (Tk)
Last PP
Current Stock
Reminder Stock
Rack
Link Product to Supplier
Use this when a supplier supplies an existing medicine/product.
Purchase Request Workflow
Pick a supplier, then either add items one by one or click Auto-fill Low Stock to instantly pull in every one of that supplier's medicines that is at/below its reminder stock level. No stock changes happen at request stage.
Adds every product below reminder stock, linked or defaulted to the selected supplier.
Add Request Item (manual / one at a time)
Purchase Request Cart (edit quantities directly, then save)
Product
Generic
Current Stock
Reminder Stock
Requested Qty
Estimated Price
Total
Note
Action
Estimated total: 0.00
0Total Requests
0Submitted
0Approved
0Converted to PO
Purchase Request List
Request No
Date
Needed
Supplier
Priority
Status
Items
Estimated Total
Note
Actions
Purchase Order
Create Purchase Order (PO)
Add Purchase Item
Purchase Cart
Product
Qty
Est. Purchase Price
Est. Sale Price
Total
Action
Cart total: 0.00
0Purchase Orders
0Total Purchase Value
0Total Paid
0Total Due
Purchase Order List
PO Number
Date
Supplier
Status
Grand Total
Paid
Due
Note
Action
Receive Purchase Order / GRN
Use this when goods physically arrive. This creates batches, expiry records, purchase receive records, and IN_PURCHASE stock movements.
PO Items to Receive
For converted purchase requests, batch is empty. Enter batch number and expiry date during receive.
Product
Ordered Qty
Receive Qty
Batch No
Expiry Date
Purchase Price
MRP
0Pending/Ordered POs
0Received POs
0GRN Records
0Total Received Qty
Receive History
GRN No
Date
PO
Items
Total Qty
Received By
Note
Pharmacy Alerts Center
Fast management view for low stock, expiry, pending purchase requests, and pending purchase orders.
0Low Stock
0Expired/Expiring
0Pending PR
0Pending PO Receive
Low Stock Alert
Product
Generic
Current Stock
Reminder Stock
Default Supplier
Rack
Expiry Alert
Product
Batch
Expiry
MRP
Status
Pending Purchase Requests
Request No
Needed Date
Supplier
Priority
Status
Items
Purchase Orders Waiting Receive
PO No
Date
Supplier
Total
Status
POS Cart & Checkout
Product
Qty
Price
Total
Stock Now
Action
0Items
0Total Qty
0Subtotal
0After Discount
Change Due
৳ 0.00
Cart total: 0.00
Find Medicine
Searches only when you press Enter — stays fast even with thousands of products.
Select the original invoice first — only medicines actually sold on that invoice can be returned, up to the quantity sold. Price and refund are calculated automatically (discount included) and cannot be edited.
0Sales Returns
0Sales Refunds
Sales Returns List
No
Date
Customer
Refund
Note
Purchase Return
Select the original purchase order first — only medicines actually received on that order can be returned, up to the quantity received. Price and refund are calculated automatically and cannot be edited.
0Purchase Returns
0Purchase Refunds
Purchase Returns List
No
Date
Supplier
Refund
Note
Due Collection / Payments
Customer Payment Collection
0Customer Payments
0Collected
Customer Payments
Date
Customer
Amount
Method
Note
Supplier Payment
0Supplier Payments
0Paid to Suppliers
Supplier Payments
Date
Supplier
Amount
Method
Note
Human Resource Management
Choose a section below. Each card is shown only if your account has that specific permission. Attendance and Leave each open their own sub-menu, matching the Master Development Plan's nested structure.
Casual/Earned/Sick are paid and capped at the annual allocation below — the system blocks a request that exceeds the remaining balance rather than falling back to Unpaid automatically. Unpaid Leave has no cap but deducts salary. Creating a request needs hrm.leave.create; approving/rejecting needs hrm.leave.edit; withdrawing a pending request needs hrm.leave.delete.
Leave Balance
Unused Casual/Earned/Sick leave expires at year-end and does not carry forward.
-Casual (Allocated / Taken / Remaining)
-Earned (Allocated / Taken / Remaining)
-Sick (Allocated / Taken / Remaining)
-Unpaid Taken (no cap, deducts salary)
Request Leave
Leave Requests
Employee
Type
Start
End
Days
Reason
Status
Action
Adjustment
Employee works a normally-scheduled day off in exchange for a different day off later — the working day does not count as absent once approved, and it stays consistent with Duty Roster and Attendance Summary automatically. Creating a request needs hrm.adjustment.create; approving/rejecting needs hrm.adjustment.edit; withdrawing a pending request needs hrm.adjustment.delete.
Request Adjustment
Adjustment Requests
Employee
Working Day
Day Off
Time
Reason
Status
Action
Duty Roster
Per-employee weekly schedule. Pick an employee, then set start/end time and Holiday Y/N for each day. One-click Save. Saving requires hrm.duty_roster.edit (or the legacy umbrella hrm.attendance).
Attendance — Check In / Check Out
Self-service attendance. Pick your action (Check In or Check Out), choose your location (In Office / Outside), add an optional note, then submit. You cannot check in twice without checking out first. Late / early flags are computed by the server against your Duty Roster.
Today's Status
Recent Attendance Events
Date
Employee
Type
Time
Location
Late?
Early?
IP
Note
Attendance Summary
Monthly rollup computed server-side from attendance events and the duty roster. Click a row to drill into that employee's daily detail for the selected month.
Monthly Rollup
Employee
Present
Late
Early Exit
Holidays
Pay Days
Absent
Action
Daily Detail
Date
Day
Roster
Status
Events
Payroll
Live, computed fresh every time this page opens or refreshes -- nothing here is cached or pre-calculated. Approve any pending Leave/Adjustment requests for the month first, since Payroll reads directly from Attendance Summary's live numbers.
0Co-workers This Month
0Total Net (Before Bonus)
0Total Already Paid
0Paid / Partial / Unpaid
Salary Summary & Details Drill-down
Employee
Days Employed
Late
Early
Unpaid Leave
Absent
Deduction Days
Prorated Base
Deduction Amt
Net (before bonus)
Already Paid
Remaining
Status
Action
Pay Salary
0Salary Payments
0Total Salary Paid
0Total Bonus
0Total Deduction
Salary Payment List
Date
Month
Employee
Basic
Bonus
Deduction
Net
Note
Action
Add Employee
Attendance Entry Deprecated
This manual entry form has been superseded by the new self-service Attendance system
(Duty Roster + check-in/check-out, under the HRM Hub → Attendance). It's disabled to
prevent two disconnected attendance histories from building up. The records already
saved here remain visible below for historical reference.
0Employees
0Present Records
0Absent Records
0Attendance Records
Employee List
Code
Name
Phone
Department
Designation
Salary
Status
Employment Status
Attendance List
Date
Employee
Status
Check In
Check Out
Note
Customer & Supplier Ledgers
0Total Sales
0Total Paid
0Net Due
Date
Type
Reference
Debit (Sale)
Credit (Paid)
Balance
0Total PO Value
0Total Paid
0Net Due
Date
Type
Reference
Credit (PO)
Debit (Paid)
Balance
Owner Dashboard (Business Intelligence)
Real-time profitability, inventory valuation, and cash standing.
0Today's Profit (Est)
0Today's Revenue
0Total Inventory Value (Cost)
0Total Inventory Value (MRP)
Top 10 Fast Moving Items
Product
Sold Qty
Revenue Generated
Slow / Dead Stock Alert
Product
Stock Qty
Capital Tied Up
Sales Report / History
Moved here from POS so cashiers get a clean, distraction-free checkout screen. Edit is only available to Owner/Manager/Super Admin.
0Sales Invoices
0Total Sales
0Sales Paid
0Sales Due
Invoice
Date & Time
Customer
Sold By
Status
Total
Paid
Due
Method
Action
Advanced Reports & Export Center
This report center calculates totals from your current Supabase data. Use it for demo/testing and management review.
0Net Sales
0Purchase Value
0Cash Balance
0Inventory Value
Management Summary
Export Data
Download CSV or JSON backup of your demo data. This is useful before making big AI-generated changes.
Inventory Valuation Report
Product
Current Stock
Reorder Level
Avg Purchase Price
Stock Value
Status
Due Summary
Type
Total Amount
Paid/Collected
Due
Customer Due Report
Customer
Phone
Opening
Sales Due
Payments
Net Due
Supplier Due Report
Supplier
Contact
Opening
Purchase Due
Payments
Net Due
Fast / Slow Moving Medicines
Product
Generic
Sold Qty
Sales Value
Current Stock
Movement
Profit Estimate Report
Estimated from sale price minus batch purchase price. Use as an estimate until accounting rules are finalized.
Product
Sold Qty
Sales Value
Estimated Cost
Estimated Profit
Pharmacy / Invoice Settings
These settings are used in sales invoice and purchase order printing.
Safety Checklist Before Real Use
This is still a demo/MVP. Before real use: strict permissions, backups, paid domain, reviewed RLS policies, and production testing are required.
Use fake data while testing.
Export JSON backup before every big update.
Never expose Supabase service role key in frontend.
Do not give all staff admin-level access in production.
Super Admin Permission Control
Only Super Admin can control user permissions. Select a user, tick the functions they are allowed to use, then save.
Super Admin always has full access. For other users, missing permission means not allowed.
0Users
0Functions
0Selected for User
0Super Admins
Link Staff Accounts to Employee Records
Master Plan foundational step: link each login account (profile) to its HR record (employee). This unlocks Attendance self-check-in and Payroll's attendance-based deductions. One-time setup — new hires only need this done once when their account is created.
Login Account
Linked Employee
Action
Permission Matrix
Grouped by system module. Tick/check the allowed functions for the selected user.
User Permission Summary
User
Roles
Allowed Functions
Status
Low Stock Report
Product
Current Stock
Reorder Level
Status
Expiry Report
Product ID
Batch
Expiry Date
Sale Price
Status
Roadmap
This is only the first Supabase-connected starter version.