ViviRx

Reports

Sales Report ⬇ View / Export 📅 Check Older Dates (incl. Archived)

Drug-wise Sales (for reorder decisions) ⬇ View / Export

Day-End Sales Verification 🔍 Find & Print Old Bill

Staff

Google Sheet Connection

Receipt Template

Edit the layout printed on the 80mm receipt. Click a field below to insert it at your cursor position, or type it directly. {{items}} is replaced with the full list of items bought — put it wherever you want that block to appear. Any line that's just one field (like {{phone}}) is left out automatically when that field is empty, so blank details never leave an empty line on the receipt. Select some text and click B Bold (or type **like this** yourself) to print it bold — works on your own text or around a field, e.g. **{{clinicName}}**.

Preview

Invoice Template (Day Verify Print)

Reprinting a bill from Day Verify prints a full A4 invoice instead of the small receipt — set your clinic details and terms here. Billing's own Print/Save button is unaffected and still prints the small receipt above.

Label Template (Barcode Label)

Controls the label shown in Stock/Stock Point's Label Preview and downloaded as a JPEG. Clinic name always matches Invoice Settings above.

Preview

Maintenance

Bill numbers are checked for duplicates automatically when a new bill is created, so this is only needed if you ever notice a "⚠ Duplicate #" warning on the Sales Report — it scans the full bill history and renumbers the later duplicate(s), so it's kept manual instead of running on every page load.

Stock Point items now automatically show up in Pharmacy at 0 stock as soon as they're added. Run this once to bring any older Stock Point items (added before this existed) into Pharmacy too — safe to run more than once, it skips anything already linked.

Only bills from the last 2 days are kept in the main Bills sheet so the app stays fast — older ones are moved to a separate "BillsArchive" tab in your Sheet (never deleted, just moved out of the way). This already happens automatically once a day when a bill is saved; use this to run it right now instead of waiting.

A barcode that's all digits can get silently misread by the Sheet as a plain number, which drops a leading zero if the code happens to start with one — that specific barcode then never matches what's actually scanned/typed again. Run this once to stop it from happening to any future barcode. It can't restore a digit already lost, though — if a barcode is currently failing to match, generate a fresh one for that item afterward.

Export All Data

Downloads everything in your Sheet — medicines, Stock Point, every bill (live and archived), restock requests and their send history, returns, stock write-offs, reorder log, and staff — as one Excel file, each as its own tab. Keep this on hand so your data stays accessible even if you ever move to different software.

Factory Reset

Permanently erases every medicine, every bill (live AND archived), every Stock Point item, every restock request and its send history, every return, and every stock write-off — everywhere in the Sheet. Bill numbering restarts from RX-00001. Staff logins and your Settings (receipt/invoice templates, expiry threshold) are kept, so you're not locked out afterward. Use this to clear test data before going live with real stock and customers. This cannot be undone.