🔄 Tap to sync latest data from Google Sheets
Total Orders
0
All time
In Production
0
Active
Delivered This Month
0
This month
Today's Delivery
0
Due today
On Hold
0
Out for Try-in
0
OverDue
0
Delivered
0
Complete
0
Repeat/Repair
0
Cancelled
0
Recent Orders
| Model # | Date | Doctor | Patient | Work Type | Units | Due Date | Status |
|---|
Doctor & Patient
Enclosures
Add Enclosures
No Enclosures found
+ Add System
Work Type
| #TRYIN | SCHEDULED | STATUS |
|---|---|---|
| 1 Wax Trial | ||
| 2 Metal / Coping | ||
| 3 Bisque Trial |
Dates & Routing
Notes
Log Work Done
Live Production Board
New Correction Case
All Correction Cases
| Challan # | Model # | Date | Doctor | Patient | Work Type | Tooth | Units | Due Date | Status | Stage | Amount | Actions |
|---|
| Challan No | Dispatch Date | Doctor | Clinic | Patient | Work Type | Units | Rate (₹) | Status | Actions |
|---|
Expenses
Payments & Invoices
Orders & Workflow
Logistics
Daily Expense
📊
Expense tracking coming soon.
Add expenses via Accounts module.Orders
Shipped
Bills
Collection
Generate Invoice
Record Payment
Payment History
Invoice Report
Outstanding
Total Received
₹0
Total Expenses
₹0
Net Balance
₹0
Amount Received
No entries yet
Total Received
₹0
Total Expenses
₹0
Net Balance
₹0
Expenses
No expenses yet
📊 Dashboard
TOTAL ITEMS
0
tracked
OUT OF STOCK
0
need reorder
LOW STOCK
0
below reorder level
EXPIRING ≤90D
0
0 already expired
STOCK VALUE
₹0
at purchase price
TOTAL PURCHASED
₹0
since inception
TOTAL ISSUED
₹0
consumed/dispensed
● Items Needing Attention
✅ All items in good standing
● Recent Transactions
No transactions yet
📥 Stock IN
Category → Item → Fill details → Submit
Step 1 — Category
›Step 2 — Item
›Step 3 — Details
›Step 4 — Submit
🏷 ITEM SELECTION
🛒 ITEM DETAILS
📦 BATCH & PURCHASE
🧾 RECEIPT
📤 Stock OUT
Category → Item → Batch → Issue Details → Submit
● Select Item & Batch
🤖 AUTO-FILLED
● Issue Details
📋 Current Stock
0 items of 0 · Click Reorder to edit
| ITEM NAME | CATEGORY | BRAND | COMPANY | BATCHES | IN | OUT | STOCK | REORDER | AVG PRICE | VALUE | EARLIEST EXPIRY | STATUS |
|---|
⚙ Manage Items
Add or delete products — changes save instantly
● Add New Product
● Delete Product
⚠ Permanently removes item. Transactions preserved.
🗒 Transactions
0 total records
| DATE & TIME | TYPE | ITEM | CATEGORY | BATCH | QTY | PRICE/UNIT | TOTAL | PERSON | ISSUED TO / VENDOR | OUT TYPE | EXPIRY | EDIT |
|---|
⚙ Settings
Manage Categories
Inventory Summary
Loading...
COMPANY PROFILE
DEPARTMENTS
Doctors / Clients
| # | DOCTOR NAME | CLINIC | ADDRESS | PHONE | CONTACT PERSON | ACTIONS |
|---|
ORDER SERIAL (JOB SHEET)
Generated as PREFIX-YEAR/NUMBER e.g. KB-26/111
Next order: KB-26/1
DELIVERY CHALLAN NUMBER
Challan number is always the order's Model No (e.g. KB-26/195) — no separate series to manage.
BILL / INVOICE SERIAL
Generated as PREFIX/FY/NUMBER e.g. KB/26-27/001 — assigned when an order is marked Invoiced or its invoice is first printed
Next invoice: KB/26-27/001
GENERAL PRINT SETTINGS
PAGE SETUP — PER DOCUMENT
Set paper size, orientation and margins for each document type. These are applied when you print.
📋 Job Card
📄 Delivery Challan
🧾 Invoice
📊 Account Statement
Invoice
Tax invoice with order details
Delivery Challan
Dispatch challan for delivery
Job Card
Internal production job card
Account Statement
Doctor account statement
Status Colors
Messaging
Send WhatsApp or SMS messages to doctors
MESSAGE DETAILS
0 characters
PREVIEW
—
GOOGLE SHEETS CONNECTION
This app connects to Google Sheets via a Google Apps Script Web App. Orders, doctors, and billing data sync automatically when you save or update.
Paste the Web App URL after deploying the script below
Protects your data — without it anyone with the script URL could read/write all orders. Set the same value in the TOKEN line at the top of the Apps Script.
Paste the URL of the actual Google Sheet — adds an "Open Sheet" button in the sidebar
TALLY CONNECTION
Pushes billed orders into Tally as Sales (Item Invoice) vouchers via Tally's local XML/HTTP gateway. Tally must be running on this same computer with F12 → Advanced Configuration → Enable ODBC/HTTP → Yes.
Test against a duplicate/test company in Tally before pointing this at your live company.
WHAT GETS SYNCED
✓ Orders Sheet
Model No, Challan, Date, Doctor, Patient, Work Type, Teeth, Units, Due Date, Status, Amount, Billing Status
✓ Doctors Sheet
Doctor Name, Clinic, Address, Phone, Email, Contact Person
⬆ Push (App → Sheet): Saves every time you create/update an order or master.
⬇ Pull (Sheet → App): Click "Pull from Sheet" to import changes made directly in Google Sheets.
Orders newer in the sheet override app data. New sheet rows are added to the app.
⬇ Pull (Sheet → App): Click "Pull from Sheet" to import changes made directly in Google Sheets.
Orders newer in the sheet override app data. New sheet rows are added to the app.
SETUP INSTRUCTIONS
Step 1. Open your Google Sheet → go to Extensions → Apps Script
Step 2. Delete any existing code, paste the script below, click Save
Step 3. Click Deploy → New Deployment → Web App
Step 4. Set Execute as: Me | Who has access: Anyone → Deploy
Step 5. Copy the Web App URL, paste it above → Save & Test
Step 6. Click Full Sync to push all 110 existing orders to your sheet
Step 2. Delete any existing code, paste the script below, click Save
Step 3. Click Deploy → New Deployment → Web App
Step 4. Set Execute as: Me | Who has access: Anyone → Deploy
Step 5. Copy the Web App URL, paste it above → Save & Test
Step 6. Click Full Sync to push all 110 existing orders to your sheet
The sync script now lives in the file apps-script/Code.gs in this app's repository (v2 — adds token security, server-side serial numbers and server-side doctor PIN check). Click Copy Script below, paste it over the old script in Extensions → Apps Script, set the TOKEN line at the top to a long random secret, then Deploy → New Deployment (a NEW deployment URL — the old one was public in the repo). Paste the new URL and the same token in the settings above.
🔐 DOCTOR LOGIN LOG
Click Refresh to load login history.
💬 DOCTOR REMARKS
Click Refresh to load remarks.
Reply to Doctor:
🔗 DOCTOR PORTAL LINKS
Go to Masters → Doctors → click 🔗 Link next to a doctor to copy their private portal link, or 📲 Send to share it with them on WhatsApp.