SBS Pharmacy Management: medicine data and one end-of-day report

Pharmacy master data on the ordinary Odoo product form, and a Daily Sales Report that splits the day's takings into Cash, Credit Card, Credit, Insurance and Branch by reading the journals that actually paid each invoice.

Tick Is Medicine and a Medicine Details tab appears with the active ingredient, strength, pack size, manufacturer, import status and prescription requirement - drawing on four small master lists you maintain yourself, so the same ingredient or manufacturer is spelled the same way every time.

The end-of-day report comes as a one-page PDF or an Excel workbook, and it does not classify sales by guesswork: each payment journal carries a Pharmacy Payment Category, and the report reads the journals that actually paid each invoice. Whatever is still outstanding is reported as credit.

Fail-closed, on both routes. We tested it with an uncategorised journal: the Excel export refused with “Set a Pharmacy Payment Category on these payment journals before generating the report: Bank”, and the PDF refused with the same message. It will not quietly produce a report that leaves money out of a bucket.

Read this before relying on the figures: cost and stock need automated valuation. The sales, tax and customer-count figures come from your invoices and are correct whatever your inventory settings. Cost of Goods Sold, Closing Stock and Gross Profit are read from Odoo's stock valuation, which only produces real numbers when your product categories use Automated (perpetual) valuation. On the default periodic valuation, Cost of Goods Sold comes out as zero, Gross Profit Margin reads 100%, and Closing Stock can be a large negative number. The report prints whatever the valuation engine returns and does not warn you, so switch your categories to Automated valuation before treating those three lines as real.

Things it changes across the database. This module is built for a pharmacy, and it makes a few changes that reach beyond pharmacy records, listed here so nothing surprises you after installing: Pharmacy Payment Category becomes required on every bank, cash and credit journal in the database, for every user - not only pharmacy ones. The Taxes column is hidden on sale order lines on every sales order; anyone who relies on it can switch it back on through the column chooser. Sales reporting menus are re-scoped so a Pharma Manager sees the Daily Sales Report rather than the full sales reporting set. Configuration lives under Inventory, so reaching it needs Inventory administrator rights as well as the pharmacy role.

We tested this on a live Odoo 19 Community database. Three sales on one day - one settled in cash, one by card, one left outstanding - split correctly into 48.00 cash, 85.00 card and 63.00 credit, totalling 196.00 net sales with three customers and 29.40 of tax, in both the PDF and the Excel workbook. We also tested the master data, the Medicine Details tab and the fail-closed guard. We have not yet tested insurance and branch categories with real data, partial payments, credit notes, multi-company use, or the optional integration with SBS Account Community's restricted journals, and we have seen the cost and stock lines only on a periodic-valuation database.