Business analytics and management cockpit (Büro: Auswertungen, Cockpit)
1. Purpose and scope
This chapter covers two back-office modules reached from the Office menu (Büro):
- Analyses (Auswertungen): a fixed catalogue of about 30 predefined analyses. Each one answers a specific operational, commercial, regulatory or CRM question. Most return a result list the user can act on directly (order, return, write off, change stock status or flags), print, e-mail or export. Users cannot design a new analysis here. They can only set and save each analysis's criteria and set up recurring reminders to run it. Free-form query building is in the separate Reports module (Reports), which is not covered here.
- Management cockpit (Cockpit): a live dashboard of the pharmacy's key performance indicators (KPIs) for one day or one month. It shows hourly or daily averages, 30-day and 12-month reference values, trend indicators, target and should-be values, and a service-level gauge. It can be filtered by branch and by front office versus back office.
Main users: the pharmacy owner or manager (Leiter), the person responsible for revenue (Umsatzverantwortlicher), the assortment/stock manager (Sortimentsverantwortlicher), and counter staff for customer-facing lists (co-payment list, purchase statements, birthday list).
What the help does not provide (see §13): drill-down charts, the internal tier boundaries of the purchasing-structure printout, the content of the prescription-billing statistics screen, and any scheduling of automatic runs or exports. Reminders only open the analysis. They never run or print it.
2. Key concepts and terms
| German term | English | Meaning |
|---|---|---|
| Auswertung | Analysis | A predefined analysis with its own criteria dialog and result view |
| Auswertungskriterien / Kriterien ändern | Analysis criteria / change criteria | Filter dialog shown before (or re-opened after) a run |
| Als Standard speichern | Save as default | Saves the current criteria as the default for future runs of that analysis |
| Relativer / Absoluter Zeitraum | Relative / absolute period | Relative = N days/weeks/months/years back from today, or named periods (current/last month, quarter or year). Absolute = date from–to. Only one of the two can be used |
| Massendatenverarbeitung | Bulk actions on results | Follow-up actions on the marked rows of an article result list: order, return, write off, change stock status, change flags |
| Aufgabe / Aufgabenserie (Notes) | Reminder task / task series | Recurring to-do in the Notes module that reminds a user to run an analysis |
| Preisänderungsdienst (PÄD) | Price/master-data change service | Periodic update (twice a month, effective on the 1st and 15th) of the national drug master data. It is first imported, then activated on the effective date |
| Taxe | National drug master file | Whole-market article and price master (from ABDATA, the German pharmacy data provider) |
| PZN | National article number | Pharmazentralnummer, the German pack-level product ID |
| Anbieter | Manufacturer / marketing company | The "offerer" of an article (pharmaceutical company) |
| Lieferant | Supplier | The party that delivers goods: a wholesaler (Großhändler) or a direct supplier (Direktlieferant) |
| ApU | Manufacturer selling price | Abgabepreis des pharmazeutischen Unternehmers |
| Apo-EK | Pharmacy purchase price (list) | Purchase price from the master data |
| Apo-VK | Pharmacy retail price (list) | Retail price from the master data |
| UVP | Manufacturer's recommended retail price | Unverbindliche Preisempfehlung |
| Eigener EK / Eigener VK | Own purchase price / own selling price | Pharmacy-specific prices that override the list prices |
| Durchschnitts-EK, effektiver EK | Average purchase price, effective purchase price | Cost bases. The cockpit uses the stock-weighted effective EK at the time of sale |
| Festbetrag (FB) | Reference price / fixed amount | Maximum amount statutory insurance reimburses for a product group |
| Rabattvertrag (RV) | Discount contract | Contract between an insurer and a manufacturer that makes a product the preferred one to dispense for that insurer's patients |
| Kostenträger, IK | Payer (insurer), institution ID | Health insurer and its institution identifier |
| GKV / PKV | Statutory / private health insurance | GKV+ = dispensed on a statutory prescription under a discount contract; GKV− = statutory prescription without a contract |
| aut idem | Substitution prohibited | Prescriber crossed the box that forbids substitution |
| Lagerstatus POS / POR / Negativ | Stock status | POS = stocked article with tracked quantity. POR = stocked article without quantity tracking (in the help's text a POR article has no system stock). Negativartikel = not kept in stock, ordered on demand. "No stock status" also exists |
| Art der Lagerhaltung | Stock-keeping mode | System-wide choice between POS and POR stock keeping |
| Auslaufartikel | Discontinued (phase-out) article | Flag: sell off, do not reorder |
| Bevorzugt abzugeben | Preferred for dispensing | Flag that pushes an article at the counter |
| Neinverkauf | No-sale / lost demand | A customer asked for the item but it was not sold |
| Besorgung / Besorger | Procurement / special order | An item ordered for a customer because it was not in stock |
| Dauerbesorger | Permanent special-order article | Article always procured on demand, never stocked |
| Nachlieferung / Abholung | Back-order / pickup | Goods owed to a customer and kept for pickup |
| Abschreibung (M/W) | Write-off (quantity / value) | Removing stock quantity, or reducing value, for loss, expiry and similar reasons |
| Lagerwertverlust / -gewinn | Stock value loss / gain | Revaluation of on-hand stock caused by a list-price change |
| Antrag auf Lagerwertverlustausgleich | Stock-value-loss compensation claim | Claim sent to the manufacturer to recover the loss caused by a price cut |
| Kommissioniersystem (KS) | Automated picking system / robot | Dispensing robot with its own inventory |
| Offizin / Backoffice | Front office (sales floor) / back office | Classification of transactions in the cockpit |
| Bruttoumsatz, Netto-Netto-Umsatz | Gross revenue, net-net revenue | See KPI definitions in §6 |
| Wareneinsatz | Cost of goods sold | Sold quantity valued at cost |
| Rohertrag | Gross profit | Net-net revenue − cost of goods |
| Spanne (theoretisch/real) | Margin (theoretical/real) | (net VK − effective EK) / net VK |
| Lieferbereitschaft / Besorgerquote | Service level / procurement rate | Service level = 100 % − procurement rate |
| Korbumsatz | Basket size | Gross revenue / number of customers |
| Betriebsergebnis | Operating result | Gross profit minus operating costs, adjusted by cash pay-ins and pay-outs |
| Zuzahlung | Patient co-payment | Statutory co-payment on prescriptions |
| Mehrkosten | Extra cost | Patient-paid difference above the reference price |
| Kassenabschlag / KK-Rabatt | Statutory-insurer pharmacy discount | Fixed € discount per Rx pack that the pharmacy grants to statutory insurers |
| ARZ | Pharmacy billing centre | External centre that bills statutory prescriptions to insurers |
| IBV | Internal business comparison | Standardised monthly KPI sheet |
| M-Bon / T-Bon / Z-Bon | Monthly / daily / closing receipt | POS closing reports |
| Filial- und Partnerverbund | Branch and partner network | Group of pharmacies that exchange data |
| Lagerort | Storage location | Hierarchical location, e.g. drawer, robot, behind-counter shelf |
| DDD | Defined daily dose | WHO measure used in the antibiotic consumption analysis |
3. Data model
Entities the analyses read or write, as far as the help reveals them:
- Analysis definition (fixed catalogue): name; criteria schema; saved default criteria (per analysis, or per tab for multi-tab analyses; whether per user or per pharmacy is not stated); available result actions; required permission or licence.
- Reminder task series (Notes): assignee (default: current operator); subject (analysis name); recurrence (default: 1st of each month, 09:00–09:15, starting the 1st of the current month); link to the analysis; optional end date. Several series per analysis are allowed. Criteria are not stored with the task.
- Article (read): PZN, name, dosage form (DAR), pack unit, standard pack size (NP: N1/N2/N3, nb = not affected, nt = not therapy-appropriate), manufacturer (Anbieter), dispensing regulation (Rx, narcotic, T-prescription, blood/haemophilia product, substitution exclusion, pharmacy-only, additional monitoring), distribution status (AV out of trade, RR recall, Z withdrawn, plus deleted variants and predecessor/successor links), safety letters (red-hand letter, information letter, training material), stock status (POS/POR/negative/none), stock quantity, reserved quantity, back-order quantity, ordered quantity, fixed and variable minimum stock, storage location(s), status date (date POS status was last assigned), earliest expiry, last order date, last sale date, flags (discontinued, preferred for dispensing, expiry article, slow mover, permanent assortment, emergency-service article, permanent special order), prices (ApU, Apo-EK, Apo-VK, UVP, FB, own EK, own VK, average EK, effective EK), fixed supplier.
- Change service (PÄD) snapshot: import date, activation date, service date. Old/new values per article: prices, FB, distribution status, discount-contract/payer assignments, deletions and new listings (with predecessor PZN). History of the last 24 change services can be browsed. Stock at the activation date is kept for revaluation.
- Stock value change line: article, supplier no./name, stock at activation, ApU old, Apo-EK old/new (net of the statutory reimbursement amount), difference, loss or gain, transmission state (none / electronic / printed).
- Manual POR stock entry: per POR article, an on-hand quantity entered for the revaluation.
- Stock-value-loss claim (submitted): send/print date, transmission type (electronic or printed/fax), PÄD date, recipient (manufacturer), status, note (internal, not transmitted), loss value, requested value, refunded amount (only when status = refund received). Article lines: article, stock, ApU old (also net of the reimbursement amount), Apo-EK old/new, loss, requested value, per-article acceptance icon. Claims of the last 12 months are listed.
- Status values: in processing (sent, no answer yet), order accepted, order rejected, transmission error, refund received, no refund received. Accepted and rejected can be switched manually later.
- Write-off record: article, date, reason, voucher number, type (M quantity / W value), quantity per expiry date, value, rate % or amount, purchase-price basis, with/without stock posting, "already on a voucher print" flag, cancelled flag (an undone write-off stays visible in red italics).
- Reasons: expiry, loss, loss from discount contract, theft, damage, recall, buy-back, loss from return, narcotic destruction, blood-product destruction, plus user-defined reasons.
- Sale / prescription data (read): sale positions with customer, date (prescription print date or last activation), sale type (normal sale, GKV, private, green prescription), payer, discount-contract status, aut-idem, co-payment, extra cost, fees (procurement, emergency service, narcotics, T-prescription, delivery), insurer discount, position discounts, total discount, VAT, cost of goods at sale time (stored per position), theoretical revenue (stored per position), workstation, back-office classification, transaction chain (predecessor links), cancellations.
- Purchase data (read): goods receipts with invoice date and value, returns with credit-note date, unposted returns, deliveries per supplier with EK at delivery, batches (lot numbers) across movements (receipt, receipt correction, return, sale, stock transfer).
- Customer/contact (read): name, address, birth date, active flag, origin pharmacy (in branch networks), roles (care home, family contact person, employee, company), customer group (can be flagged "back-office customer"), hidden/anonymised sales data, e-mail with or without encryption password, VAT ID and country (EU business customers), app registration ("Meine Apotheke").
- Clinic structures (antibiotic analysis): clinic → units → sub-units with separate delivery; monthly occupancy data (patient days, cases); DDD per reference substance and ATC code; article-to-ATC assignment; DDD per pack.
- Picking-system inventory (read): robot quantity, expiry dates and storage per article.
- Company master (read): address, tax number, bank details, phone (needed for electronic claims); main IK; monthly operating costs (used by the cockpit's operating result).
- Self-declaration print log: period (month), IK, operator, print date, time.
4. Features
4.0 Catalogue of predefined analyses
Output: L = interactive result list, PV = goes straight to print preview, CSV = file export, XLS = Excel export from preview. Actions: O = order (cart), R = return, W = write off, S = change stock status, F = change flags (discontinued / preferred), D = article details, P = print, E = e-mail.
| # | Analysis (German) | Business question | Dimensions / rows | Measures / columns | Main filters | Time basis / comparison | Output, actions | Tag |
|---|---|---|---|---|---|---|---|---|
| 1 | Price change service (Preisänderungsdienst), 7 tabs | What does the latest master-data update change for my stock and prices? | Article; supplier subtotals in the value tab | Old/new prices, differences in € and %, FB changes, loss/gain | Stock-status scope or whole market file, storage location, dispensing regulation, minimum change in € or %, FB-only, articles without own price, minimum loss value per article or per supplier | Before vs after one change service; the last 24 services can be browsed | L; O R F D P; labels; electronic claims | DE (idea generic) |
| 1a | – Price change list | Which prices went up or down? | Article | Apo-VK, UVP, diff €/%, Apo-EK diff €/%, own VK/EK, stock | as above | previous → current service | L; O R F D; price list + shelf labels | GENERIC idea |
| 1b | – AV/Z/RR articles | Which of my articles went out of trade, were withdrawn or recalled? | Article | status icons, back-order qty, stock, valid-from date | stock-status scope | selected service | L; O R F D P | GENERIC idea |
| 1c | – Fixed amount changes | Where does the reimbursement ceiling change? | Article | Apo-VK, diff, FB, FB diff, new/deleted/up/down icons, price > FB flag | scope, dispensing regulation, change types, minimum difference | before vs after next activation | L; O R F D P | DE |
| 1d | – Deleted articles | Which articles disappear from the master file? | Article | stock, back-orders | scope | next activation | L; R F D P (no ordering) | GENERIC idea |
| 1e | – New listings | What is new on the market? Which successors arrive? Which of my pre-registered items now exist? | Article | Apo-VK, UVP, Apo-EK, old PZN | all / with predecessor / pre-registered only | since the last service | L; O R F D P (after activation only) | GENERIC idea |
| 1f | – Stock value changes | How much did my stock gain or lose through the price change? | Article, grouped by supplier | stock at activation × (new − old Apo-EK) | gain/loss, minimum €, dispensing regulation, include POR | before vs after the chosen service | L; P; send claim | DE (idea generic) |
| 1g | – Submitted stock value losses | Status of my compensation claims | Claim → article | value, requested, refunded, status | transmission type, status types, period, value range | last 12 months | L; edit, resend, delete | DE |
| 1h | – Rx stock articles (RxAktuell add-on) | Which stocked Rx items lose or lack discount contracts with the payers that matter to me? | Article; payer group | EK, VK, GKV+, GKV−, PKV, aut-idem counts, payer share stars | contract status, change scope, dispensing types, EK/VK range, minimum stock, sort | active vs imported service; dispensing window (90 days by default) | L; O R F D P | DE |
| 2 | Write-off book (Abschreibebuch) | What was written off, when and why? Accounting vouchers | Write-off record | qty, value, voucher no., reason, type M/W; totals | voucher no., article, reason, rate, on-voucher status | relative/absolute | L; undo, correct, O, D, P (voucher) | GENERIC |
| 3 | Manufacturer (Anbieter) | What do I carry from manufacturer X and how does it sell? | Article | avg EK, earliest expiry, last order, stock, delivery value sum; monthly sales for 3 years | manufacturer, all vs fixed-supplier articles, stock statuses, dispensing regulation, branch scope | current year + 2 previous years by month | L; O D P (with monthly statistics) | GENERIC |
| 4 | Article prices (Artikelpreise) | Expensive items, items with missing prices, under-priced items | Article | VK, last sale, stock | dispensing regulation, location, negative articles, price basis, price missing, EK range/comparison, VK comparison | none | L; O R D P, set/remove discontinued flag | GENERIC |
| 5 | Drug recall – customers (Arzneimittelrückruf) | Which customers bought the recalled product or batch? | Customer | – | period, article(s), batch | period | L; recall letter per customer | GENERIC |
| 6 | Drug recall – purchasing (Arzneimittelrückruf (Einkauf)) | From which suppliers did I get this product or batch? | Article × supplier | – | period, article(s), batch | period | L; P/PDF; printable "not obtained" proof | GENERIC |
| 7 | Discontinued articles (Auslaufartikel) | Which stocked items are flagged for phase-out? | Article | stock, supplier, location | none | – | L; S W, remove flag, D P | GENERIC |
| 8 | Antibiotic consumption (Antibiotikaverbrauchsauswertung) | Antibiotic use density for a supplied clinic | ATC code × route → article | DDD, daily doses, density per 100 patient days / 100 cases | clinic/unit, patient days, cases | year, month range or whole year, optional previous-year comparison | L; DDD and occupancy maintenance; P/XLS | DE (idea generic) |
| 9 | Batch analysis (Chargenauswertung) | Full movement history of one batch | Movement | receipt, receipt correction, return, sale, stock transfer | article, batch no. | period | L; P | GENERIC |
| 10 | Purchasing structure (Einkaufsstruktur) | How is my purchasing spread across wholesale price tiers? | Price tier | purchase volume (Rx; total) | wholesalers only | relative named periods / absolute | PV (two printouts) | GENERIC idea |
| 11 | Birthday list (Geburtstagsliste) | Who has a (round) birthday soon? | Customer | birth date, age now, age on birthday | age range, round birthdays, active only, origin branch | relative/absolute window | L; customer details; P list or address labels | GENERIC |
| 12 | Wholesale stock value losses (GH-Lagerwertverluste) | Price-cut losses on goods the wholesale department bought directly | Article | – | change service, period | chosen service + purchase window | PV | DE |
| 13 | IBV analysis (IBV-Auswertung) | Standard monthly KPI sheet for benchmarking | Sale type (private/green, normal, GKV) | revenue, # GKV Rx, packs, month-end stock value (4 cost bases), customers, high-price split | month | one past month | PV | DE format, GENERIC idea |
| 14 | Insurer discount change calculation (Kalkulation Kassenabschlagsänderung) | What would a retroactive change of the per-pack insurer discount cost or yield? | Total; per payer; per manufacturer | difference €, # Rx, # positions, # packs | old/new discount, payer, manufacturer | billing period | L (linked tables); P | DE (idea generic) |
| 15 | Picking-system stock differences (KS-Bestandsdifferenzen) | Where do robot and system inventory disagree? | Article (4 tabs) | robot qty, system qty, back-order qty, difference cause | difference formula | now | L; adopt robot stock; D P | GENERIC |
| 16 | Supplier (Lieferant) | Which delivered items no longer sell? | Article | delivered qty, EK at delivery, delivery value, last sale, last delivery; total | supplier or category, delivery period, last sale before N, no sale since last delivery, permanent assortment, emergency items, minimum stock, expiry within N, stock status | delivery period | L; O R D P | GENERIC |
| 17 | Supplier purchase volume (Lieferantenumsätze) | How much do I buy from which supplier? | Month | purchases, returns, net; unposted returns | all / direct / wholesalers / one supplier | current year vs previous year by month | L; P | GENERIC |
| 18 | Negative articles with stock ≠ 0 | Data-quality check on stock | Article | stock, reserved | none | – | L; S D P | GENERIC |
| 19 | Newly stocked articles (Neu an Lager gelegte Artikel) | Which new stock items have not sold since they were listed? | Article | listing date, Apo-EK, stock; estimated stock value | listing date range | listing period | L; R S D P, discontinued flag | GENERIC |
| 20 | POS articles without stock (POS-Artikel ohne Bestand) | What is out of stock or below minimum? | Article | stock, reserved, ordered, minimum stock | below minimum, consider ordered qty, memo defects, scheduled notes | now | L; P (always whole list); O R | GENERIC |
| 21 | Prescription billing (Rezeptabrechnung (ARZ)) | What did I bill to the billing centre? | Prescription | gross, co-payment, packs; cancellations | zero-amount Rx, care aids, customer, Rx no. | dispensing date, relative/absolute | statistics + detail L; P | DE (idea generic) |
| 22 | Covid-19 vaccine self-declaration (Selbsterklärung) | Monthly claim voucher for vaccine vials | Billing position (max 3) | vial count, special PZN | period | month | voucher print, print history, task series | DE |
| 23 | Suggestions for new stock listings (Vorschläge für Lagerneuaufnahmen) | Which non-stock items are demanded often enough to stock? | Article | qty sold + no-sales, ABDA-EK | no-sales, sales, permanent special orders (with/without/only), minimum qty | relative/absolute | L; O D P | GENERIC |
| 24 | EC sales list (Zusammenfassende Meldung) | Monthly tax report of VAT-exempt B2B sales to other EU countries | Customer VAT ID | country, VAT ID, whole-euro amount, supply type L | month | month | CSV | EU-SPECIFIC |
| 25–29 | Customer statements: total purchases, self-medication, prescriptions, prescriptions + self-medication, co-payment list | Annual purchase and co-payment evidence for a patient (insurer exemption, income-tax deduction) | Customer → sale line | VK, co-payment, extra cost, fees | all/one customer, home residents, family, branch scope, fees not charged to customer, co-payment-free lines | current/previous year or range | L; P (tax-office mode), E, PDF, in-app delivery | GENERIC core, DE details |
There is also a cross-cutting cockpit (§4.11–4.13), which is a separate module from the analysis list.
4.1 Analysis list, running, criteria and defaults [GENERIC]
- Purpose: one place from which every predefined analysis is started.
- Trigger: Office › Analyses. The user picks an analysis and runs it.
- Behaviour:
- Depending on the analysis, the result appears immediately (no-criteria analyses such as Discontinued articles and Negative articles with stock ≠ 0) or a criteria dialog opens first.
- In the result view, "Change criteria" re-opens the dialog and re-runs the analysis.
- "Save as default" stores the criteria for future runs. For multi-tab analyses this is per tab. Some values are never saved: the chosen change service in the stock value tab always defaults to the current one, and absolute periods and customer selections in customer statements are not saved.
- The result header repeats the evaluated period and the filter criteria with their labels.
- Long-running analyses show that they are working. Some warn about slow periods (prescription billing over more than 3 months).
- Common result-list behaviour:
- Checkbox marking per row, with a "mark all" / "remove marking" toggle. "Mark all" is offered only when not all rows are marked, and vice versa.
- Multi-select: select-all key, range select, ctrl-select followed by toggle.
- Column sort: first click ascending, second descending, third back to the default order. Ties keep the default order.
- Details: opens article details for the marked rows. The user pages through the marked rows and the same details page stays open. Starts at the focused row.
- Standard status column legend (for article lists):
- blank = POS article
+= negative articleA= POR article- a digit = current stock
P= stock above the displayable range (> 99, or > 999 in wider columns)-P= stock below the range (< −9, or ≤ −100 / < −99 in wider columns)- POS stock in bold, negative-article stock in normal weight (in some lists)
- Order-status icons take precedence: open order, sent order, not deliverable (defect), open return, returned, scheduled order, in a back-order job, in a dispo job. Then flag icons: preferred for dispensing, expiry article, slow mover, discontinued, no-sale. Plus back-order quantity from open pickups.
- Article icon priority: distribution status (AV/RR/Z, incl. deleted and predecessor/successor variants) > red-hand letter (active during its validity or up to 6 months after publication, then an "expired" icon) > information letter (same rule) > training material > predecessor/successor > self-created article. Clicking a predecessor/successor icon opens a successor search. Special articles (physician samples) have their own icon.
4.2 Recurring reminders for analyses (Aufgabe anlegen) [GENERIC]
- Purpose: make sure periodic analyses are run (monthly checks; the price change service twice a month).
- Trigger: "Create task" on the selected analysis in the list.
- Inputs: Notes task-series dialog, prefilled as follows:
- assignee = current operator
- subject = analysis name
- recurrence = 1st day of every month, 09:00–09:15, starting the 1st of the current month (editable via "series type")
- Behaviour:
- The analysis list shows a one-task or several-tasks indicator. Clicking it opens Notes filtered on the task view.
- On the due date the task appears in "Today's tasks" when the assignee opens their operator session. Analysis tasks have their own icon.
- "Execute" opens the analysis with its default criteria. Criteria saved at task creation are not passed. Printing is manual. There is no automatic run, print or export.
- Exception, self-declaration voucher: (the start page calls it the self-declaration for the emergency-service fund, Selbsterklärung Notdienstfonds, while the detail pages describe the Covid-19 vaccine self-declaration; the mechanism is the same) the series is created from inside that analysis. Default recurrence is the 1st of each month at the creation time. It can be set to the "first working day" day category (printing is legally due then). Setting an end date is recommended. Executing the task opens the analysis ready to print, and the voucher's print icon then switches to "printed" for that period and IK.
- Permission: right "Notes: edit task", contained in roles Manager and "Notes: edit task".
4.3 Sharing: print, e-mail, PDF, Excel, CSV, app delivery [GENERIC]
- Print:
- If no row is marked, the whole list is printed.
- If at least one row is marked, a print-options dialog asks "marked only" or "entire list". This choice also applies to any print extras chosen earlier (e.g. monthly statistics).
- Then the print preview opens, then Print/Send.
- Exceptions: POS articles without stock always prints the whole list. Customer statements and the price change list have their own dialogs.
- E-mail:
- Any analysis can be e-mailed from the print preview through the system mailbox.
- Customer-related analyses (total purchases, self-medication, prescriptions, prescriptions + self-medication, co-payment list) can e-mail directly from the result list to contacts with a stored address.
- In multi-customer results the user can mark all customers with an e-mail address (to send) or all without one (to print).
- Attachments are encrypted when the contact has an encryption password. Addresses without one are visually flagged.
- PDF: through printer selection in the preview (e.g. recall purchasing list, customer statements).
- Excel: antibiotic consumption analysis (from the preview).
- CSV: EC sales list.
- App: customer statements via "Digital output" to the customer's in-app mailbox (licence "Meine Apotheke"; customer fully registered).
4.4 Bulk actions on result lists (Massendatenverarbeitung) [GENERIC]
All bulk actions need at least one marked row.
Order list (Warenkorb)
- Supplier choice:
- supplier from automatic cart determination
- last supplier (of the last delivery)
- a specific supplier
- option: ignore the article's fixed supplier
- inactive suppliers are skipped
- Quantity, option A: quantity optimisation
- Standard: the order-quantity optimisation model.
- Or a custom coverage period (Dispozeit) in days, e.g. 90. It applies to this order only, does not shorten the coverage for direct orders, and ignores fixed/variable minimum stock.
- Optional custom evaluation period: current year and the previous 2 years are allowed.
- Toggles, all on by default: subtract stock on hand; subtract quantities already in carts; subtract open orders.
- Rule: with optimisation, non-stock articles are silently skipped (stock articles have priority).
- Quantity, option B: fixed stock quantity (e.g. 10), ordered for stock without reservation.
- Result: the rows go into one or more carts (per supplier settings).
- Coverage period = days of stock to hold. It can be static (recommended) or shrink dynamically toward month end.
Return list (Retournieren)
- Reason: default "buy-back", selectable.
- Supplier: chosen supplier or last supplier.
- Quantity:
- complete stock (for POR articles: the quantity of the last goods receipt)
- quantity of the last goods receipt
- manual quantity
- Rows are checked for returnability and written into a return order. Stock is reduced. Packs stored in the picking robot are ejected automatically.
- If "last supplier" cannot be found for some articles, an error list appears and the user assigns one supplier for all of them.
- Not possible: returning articles without stock (e.g. in the deleted-articles tab).
Write-off list (Abschreiben)
- Available e.g. in Discontinued articles.
- Wizard per marked article (Next / Back / Finish):
- type: with stock posting or without stock posting
- reason: predefined, free text, or a user-defined reason (persisted)
- purchase-price basis (EK) selectable; the resulting EK is shown; a price can be typed manually if none exists
- write-off by % or by amount; the computed write-off value is shown
- quantity per expiry-date stock line for POS/negative articles; one quantity field for POR articles
- Result: entries in the write-off book.
- Permission: right "Write off", or role Assortment manager or Manager.
Change stock status (Status ändern)
- Choose a new status for the marked articles. The dialog lists name, DAR, unit, NP, location icon and status.
- Rule: changing a POS or negative article to POR deletes its stock and existing reservations without warning.
- Permission: Manager or Assortment manager.
- The stock-keeping mode is a system parameter ("Type of stock keeping", article management settings, page Stock keeping).
Change flags (Kennzeichen ändern)
- Available in the price-change-service tabs.
- Set or remove "discontinued" and "preferred for dispensing". Each flag has a "change this flag" checkbox and Yes/No.
- With several rows marked: checkboxes off, options preset to Yes. With one row marked: preset to that article's current values.
- Use: sell off articles whose discount contracts expire; remove the flags when new contracts with relevant payers are signed.
Set / remove discontinued flag (Auslauf-KZ)
- Available in Article prices, Newly stocked articles and Discontinued articles.
- Setting the flag prevents reordering without asking. Removing it keeps the article stocked.
- In Discontinued articles, removed rows disappear from the list.
4.5 Price change service analysis (Preisänderungsdienst) [DE-SPECIFIC]
Idea underneath: after every update of supplier or market price and master data, show its effect on own stock, prices, labels, assortment and contracts, and recover price-cut losses from manufacturers.
General behaviour:
- On start, all tabs are computed with each tab's default criteria.
- The header shows the import date, the activation date and the selected service.
- The user can browse the last 24 services.
- Some actions are disabled while a service is imported but not yet activated (new listings actions; printing or sending value losses).
(a) Price change list.
- Lists price increases, decreases, and prices that disappeared or newly appeared.
- Criteria:
- scope: whole market file or selected stock statuses
- storage location(s), multi-select (to print labels location by location)
- dispensing regulation
- minimum VK change ± in € or %, applied to both Apo-VK and UVP changes
- only FB articles
- only articles without own VK
- display "plus own prices"
- Columns:
- direction arrow: up / down / none when the old or new price is unknown
- name, DAR, unit, PZN, stock
- Apo-VK new, UVP new, diff € and diff % of the selling price (the UVP change wins if both changed; blank if not determinable)
- Apo-EK new, diff € and diff %
- own VK (if it is calculated from list prices, it reflects the last activated service) and own EK, both only with "plus own prices"
- Print dialog:
- Price change list: sort criterion; print range by initial letter (e.g. B–F).
- Labels:
- label type: price label, base-price (unit-price) label, location label, price list for price marking
- quantity: "total stock" (default for price labels), optionally capped by a maximum per article; or "fixed quantity" (default 1 for base-price and location labels)
- only FB articles
- "with own prices": own EK only on location labels, plus own VK; an own VK is printed with a trailing
* - minimum VK change in € or %
- dispensing regulation
- Label quantity rules for "total stock":
- POR-status article → always 1 label
- POR stock keeping: negative articles or articles without status → none
- POS stock keeping: POS and negative articles → labels = stock; stock ≤ 0 or no status → none
- fixed quantity → always that number, and the price list shows each article once
- none of these rules apply to location or base-price labels
- Limits: warning above 1,000 entries; printing is impossible above 20,000 entries.
- Selling-price cascade on labels: with own prices: own VK → UVP → Apo-VK. Without: UVP → Apo-VK → own VK. The first available price is used.
(b) AV/Z/RR articles.
- Articles out of trade (AV), recalled (RR) or withdrawn (Z) in the service.
- Columns: icons, name, DAR, unit, PZN, back-order quantity, status, manufacturer, valid-from date (empty before activation).
- Criteria: stock status(es) or the whole market file.
- Actions: O R F D P.
(c) Fixed amount changes.
- Articles whose FB changes with the next activation.
- Columns:
- dispensing-regulation icons
- Apo-VK and its diff
- icon "FB article whose Apo-VK/UVP/own VK exceeds the FB", subject to a threshold
- current FB and FB diff
- change icons:
- new FB: none before, one after
- deleted FB: one before, none after
- FB increase
- FB decrease
- Criteria:
- scope
- dispensing regulation
- which change types to flag (new / deleted / increase / decrease)
- minimum difference ±
- "additionally flag: current VK > updated FB"
- Actions: O R F D P.
- Idea underneath: a payer's reimbursement ceiling per product, and a warning when the shelf price will exceed it so the patient would pay the difference.
(d) Deleted articles.
- Articles that will be deleted on activation. Columns include NP.
- Ordering is impossible. Return only with stock.
(e) New listings.
- New articles in the national master file.
- Icon when the pharmacy had pre-registered the PZN. Old PZN column for successors.
- Columns: Apo-VK, UVP, Apo-EK.
- Scope: all / only with a predecessor PZN / only pre-registered.
(f) Stock value changes.
- Two lists, losses and gains, sorted by manufacturer then article name.
- Columns: name, DAR, unit, PZN, manufacturer no./name, stock, ApU old, Apo-EK old, Apo-EK new (both net of the statutory reimbursement amount where applicable), diff, loss/gain, transmission icon.
- Subtotal per manufacturer ("total loss" / "total gain") and grand totals below each list.
- Stock basis: the stock at the activation date.
- Criteria:
- which change service (always defaults to the current one)
- gain and/or loss (at least one; the other list stays empty)
- minimum value € per article or per manufacturer (summed)
- dispensing regulation
- "with POR articles": enables manual stock capture for POR articles so their loss can be claimed by fax
- Print options:
- Total list: all manufacturers, gains and losses, sorted by article name, with grand totals.
- Losses per manufacturer: filtered by supplier type (with online transmission / without / all); select all or individual manufacturers from a table showing each one's total loss. Each printout ends with the loss totals net and gross, with the VAT shown separately.
- Option "add printed losses to submitted claims" so faxed claims can be tracked.
- Printing requires an activated service.
- Manual electronic send:
- The dialog lists all losses of all manufacturers regardless of the display filter.
- Choose the total list (all participating manufacturers) or selected manufacturers.
- Requires that the manufacturer supports electronic claims, and that company master holds address, tax number, bank details and phone.
- Automatic send:
- Config "Automatic online transmission".
- After each activation (1st/15th of the month) where losses exist, claims go automatically to all participating manufacturers with losses. Selection of individual manufacturers is only possible manually.
- Transport: a third-party web service (IS Informatik Systeme GmbH).
- About eight generic-drug manufacturers support it, identified by IDF number (the German pharmacy-trade participant ID).
(g) Submitted stock value losses (Eingereichte Lagerwertverluste).
- Claims of the last 12 months, newest first.
- Columns: status icon, send/print date, transmission type, PÄD date, recipient, note, value, refunded amount. Detail: article lines with per-article acceptance or "not affected / foreign article" icons (electronic claims only).
- Display criteria:
- transmission: electronic (default) / electronic + printed / printed
- status types: in processing, accepted, rejected, transmission error, refund received, no refund received
- period: default "current change service"
- requested value from–to
- savable as default
- Edit claim:
- status, note (internal) and refunded amount (only with status "refund received")
- accepted ↔ rejected can be changed later (e.g. after a letter or fax from the manufacturer)
- Resend after a transmission error. If it still fails, print and fax.
- Context menu "delete from list" removes printed entries.
- A transmission error also creates an info message.
(h) Rx stock articles (RxAktuell, paid add-on). [DE-SPECIFIC]
Idea underneath: payer-contract-aware dead-stock cleanup. Find stocked prescription items that lack a preferred-supplier contract with the payers that actually send this pharmacy prescriptions, or whose contracts are about to lapse.
- Pharmacy-relevant payers: payers with prescriptions received in the last 3 months, grouped into payer groups.
- Data comes from comparing the active service with the imported-but-not-yet-activated one. Run it shortly before activation (start and middle of the month). A Notes reminder is suggested.
- Change icons:
- contract coming soon
- payer assignment changing soon
- contract lapsing for all payers soon (red)
- the same three as faded icons for changes effective since the last activation
- partial changes at individual payers = yellow
- tooltip: date and payer group
- Columns:
- contract-article icon
- status, EK, VK
- GKV+ (dispensings on a statutory prescription under a discount contract)
- GKV− (statutory prescription without a contract)
- PKV (private prescription)
- aut idem
- Detail:
- "changes as of <last activation>"
- counts of lapsing / new / unchanged contracts
- payer-group table: added/removed icon, group name (tooltip lists IKs), importance stars (that group's share of the pharmacy's total prescription volume), dispensed quantity of this article, % = this article's share of all Rx dispensings in the period (GKV-with-contract only)
- Criteria:
- without current contract (on), optionally incl. future contracts (meaningful only between import and activation)
- with current contract: all, or only those with pending contract changes (yields nothing if no imported service exists)
- contracts lapse completely (red)
- changes at individual payers (yellow; off by default)
- dispensing window from a list
- hide GKV−, hide PKV, hide aut-idem (on by default)
- EK range, VK range, minimum stock (default ≥ 1)
- sort by EK, VK, stock or name
- Delivered default:
- Shows Rx stock articles with stock ≥ 1 that either have no current contract (excluding those about to get one) or have a current contract that lapses for all payers.
- Excludes articles with continuing contracts, articles with future contracts, and articles dispensed in the last 90 days on GKV without a contract, on PKV, or per aut idem (they evidently sell).
- The user can relax the filters stepwise.
- Recommended follow-up: set "preferred for dispensing", or return part of the stock.
- Printout:
- criteria plus an "RV-Info" column
- between import and activation: "contract from <date>", "change", "lapses"
- after activation: "contract since <date>", "contract until <date>"
- Counter integration:
- In comparison searches started from a sale (discount-contract, aut-idem, active-ingredient and import searches), and when scanning prescriptions, Rx articles show "contract lapses soon for all payers" or "… for some payers" icons.
- Only if: no AV/RR/Z flag (those win); article is Rx; RxAktuell is active; and only between import and activation.
4.6 Write-off book (Abschreibebuch) [GENERIC]
- Question: which articles were written off, by quantity or value, in a period, and what are the accounting vouchers?
- Permission: right "Run write-off book", or role Assortment manager or Manager.
- Criteria:
- voucher print for accounting (on/off)
- voucher number
- article name
- reason: expiry, loss, loss from discount contract, theft, damage, recall, buy-back, loss from return, narcotic destruction, blood-product destruction
- write-off rate % or amount
- articles: all / already on a voucher print / not yet on a voucher print
- relative or absolute period
- Result: date, reason, voucher no., type M/W. Detail splits the quantities by expiry date.
- Actions:
- Delete = undo the write-off after confirmation. The row stays, shown in red italics.
- Correct = re-open the write-off wizard per row (quantity, reason…).
- Order, details, print.
- Printout: article data, quantity, value, voucher no., date, plus the total quantity and total value.
4.7 Assortment and stock analyses [GENERIC]
- Manufacturer (Anbieter)
- Criteria: manufacturer (number, or partial name with a pick list); all articles or only those where this manufacturer is also the fixed supplier; stock statuses POS / POR / negative / none; dispensing regulation (All, self-service, behind-counter, self-service/behind-counter, Rx, Rx/self-service, Rx/behind-counter).
- In branch networks that share stock and statistics, the demand statistics scope: own pharmacy (default), all branches and partners incl. own, all excl. own, or one specific branch.
- Columns: last order date, average EK, earliest expiry, stock (−99…999; ≤ −100 → −P; ≥ 1000 → P).
- Footer: count and approx. delivery value sum = Σ(stock × average EK), which excludes POR articles and therefore may differ from the total stock value.
- Detail: monthly sales for the current year (up to the current month) and the 2 previous years; stock status; VK (own VK, else Apo-VK); wholesale margin € and markup %.
- Demand statistics show purchase data in POR pharmacies and sales data in POS pharmacies.
- When printing, the user is asked whether to include the monthly statistics.
- Article prices
- Criteria: dispensing regulation; storage location (incl. sub-locations); include negative articles (in POS mode: "with stock" or "regardless of stock"); price basis; price condition: price missing, EK from–to, EK
> < =value, VK> < =value. - Columns: VK, last sale, discontinued icon, status, expiry-article and slow-mover icons, location icon.
- Uses: find expensive items, items without a price, under-priced items.
- Criteria: dispensing regulation; storage location (incl. sub-locations); include negative articles (in POS mode: "with stock" or "regardless of stock"); price basis; price condition: price missing, EK from–to, EK
- Discontinued articles
- All POS and POR articles flagged discontinued. No criteria.
- Flag semantics: no automatic reorder when a POS article reaches 0; after the last pack is sold, the status becomes "negative article".
- Negative articles with stock ≠ 0
- Status negative or none, stock ≠ 0, and no reserved or back-order quantity. No criteria.
- Negative stock arises when an item is sold before its goods receipt is posted.
- Column: reserved quantity. Action: change status.
- Newly stocked articles
- Articles whose current status date (the date POS status was last assigned) lies in the period and that have not sold since.
- Columns: listing date, ABDA Apo-EK.
- Footer: count and estimated stock value = Σ(stock × average EK).
- Actions: return, status, discontinued flag.
- POS articles without stock
- Options, all off by default: include stock < minimum; consider ordered quantities; include defects on memo lists; include scheduled notes.
- Columns: stock, reserved, ordered, minimum stock (= mean of the fixed and variable minimum stock).
- Printing always covers the whole list.
- Suggestions for new stock listings
- Non-stock articles (no POS/POR status) with sales and/or no-sales reaching a minimum quantity in the period. AV and RR articles are excluded.
- Criteria: no-sales on/off, sales on/off (both on by default), permanent special-order articles with / without / only, period, minimum quantity.
- Columns: quantity (sales + no-sales), ABDA-EK.
- Follow-up: order, then mark as a stock article at goods receipt.
- Supplier (slow movers from deliveries)
- Criteria: one supplier, or all / all wholesalers / all direct suppliers; delivery period; "last sale before N days/weeks/months"; "no sale after last delivery" (last sale ≤ last delivery date); include permanent-assortment articles; include emergency-service articles; current stock at least N; expiry within N; stock status.
- Columns: last sale (any supplier); quantity (total ordered from this supplier in the period); EK at delivery; delivery value = EK × quantity; last delivery.
- Footer: approx. delivery value sum = Σ delivery values.
- Batch analysis: for an article plus batch number over a period, lists every goods receipt, receipt correction, return, sale and stock transfer. Printable.
- Picking-system stock differences (KS-Bestandsdifferenzen)
- Permission: Manager or Assortment manager.
- Safety prompt at start: all temporarily ejected packs must be re-stored, and no sales with ejections or pickups may be open.
- Tabs:
- Reconciliation: stock-only differences for POS articles located in the robot; adoption possible.
- Overstock: stock differences plus other differences (no location, several locations); information only.
- Robot stocking: articles with no status, stock only in the robot and the robot not yet registered as location; adoption possible; meant for opening a new pharmacy. Adoption sets the stock, adds the robot as location and makes status-less items negative articles.
- Unknown articles: in the robot but unknown to the system.
- Columns: #robot, #system, #back-order, adopt checkbox, difference cause (status: not POS / is POR or negative, which should not be stored in the robot; stock; location: missing, or "ÜV" = extra locations), other locations (sub-locations of semi-automatic robots in the reconciliation tab).
- Difference formula (criteria):
system − robot(ejected back-orders count as differences) orsystem − (robot + back-order). The second needs the parameter "Storage of negative articles" off, otherwise a warning icon appears. - Adoption rules:
- Robot expiry dates are copied into the article data.
- If the robot stock is below the article's minimum stock, the shortfall is computed by order optimisation and ordered automatically, using the live stock at adoption time.
- System stock unknown to the robot appears in reconciliation, including goods receipts that are captured but not yet posted.
- With "Storage of negative articles" on, negative articles in the robot cause no differences. With it off, they appear in Overstock.
- Overstock and unknown rows are fixed manually in article details (location, status, stock).
- Advice: investigate the cause (goods-receipt or sales errors, packs also kept outside the robot) before adopting.
4.8 Purchasing analyses [GENERIC]
- Supplier purchase volume (Lieferantenumsätze)
- Scope: all / direct suppliers / wholesalers / one supplier (by name or initial letters; a unique match is taken automatically). Selecting a manufacturer is not possible.
- Result: two monthly tables (current year and previous year) with a total row. Columns: purchases (Σ posted purchase values), returns (Σ posted credit notes), net = purchases − returns.
- Header: unposted return value (returns not yet posted and credited).
- Receipts are counted by invoice date, returns by credit-note date.
- Purchasing structure (Einkaufsstruktur) — DE context, generic idea
- Roles: Manager, Revenue manager or Report manager.
- Period: relative (last completed month / quarter / year; current month / quarter / year, today included) or absolute.
- Option: only wholesalers.
- Output goes straight to preview: "Purchasing structure Rx" and "Purchasing structure total", broken down by wholesale price tier. Purpose: a basis for negotiating wholesaler terms. The tier columns are not described in the text.
- Drug recall – purchasing
- Period, articles, batch → the suppliers that delivered them. Paper or PDF.
- An empty result can be printed as negative proof ("batch not obtained from any supplier") for insurers.
- Wholesale stock value losses (GH-Lagerwertverluste) — DE
- For a chosen service and period: articles with an ApU cut in that service that the wholesale department bought directly from the manufacturer. Straight to preview.
4.9 Customer, CRM and recall analyses
Customer statements (Einkäufe insgesamt, AM-Selbstmedikation, Verordnungen, Verordnungen + AM-Selbstmedikation, Zuzahlungsliste) [GENERIC core; DE details]
- The five variants:
- all purchases
- non-prescription drugs bought in normal sales
- prescription items
- prescriptions plus non-prescription drugs
- co-payments incurred
- Purpose: evidence for the statutory co-payment exemption (income-dependent cap; the list covers the current year across all branches and partners until a pharmacy left the network) and for income-tax deduction of health expenses.
- Trigger: usually at the counter from a customer-linked sale (buttons for co-payment list, prescriptions and purchases, with the customer preselected), or from the analysis list.
- Criteria:
- all customers (all contact roles) or one customer
- include home residents (if the customer is a care home) or include family members (if the customer is the family contact person)
- branch networks: all branches and partners, or own pharmacy
- fees not charged to the customer (purchases and prescription variants): procurement, emergency service, narcotics, T-prescription and delivery fees billed to the insurer
- include co-payment-free lines (co-payment list only; otherwise only lines with co-payment > 0)
- period: current or previous year, or a date range
- save as default, without the absolute period and the customer
- home-resident special case: when the resident has no separate invoice, or the parent unit is supplied separately, the system asks whether to evaluate the home, the unit or the resident
- Privacy: customers whose sales data were hidden or anonymised show nothing unless the user has the matching right.
- Result: "selected customers" list (A–Z) plus a detail view. The "GKV" sum field is derived from co-payments + extra costs and is not repeated in the details.
- Dates: prescription sales are dated at prescription print (later re-activations ignored); other sales at their last activation.
- Tax notice:
- The co-payment list is evidence that a co-payment was incurred, not a receipt.
- When GKV-prescription lines appear, the printout states that the insurer is the service recipient and the document does not entitle the holder to deduct input tax (so it creates no VAT liability under §14c(2) UStG).
- Print settings:
- co-payment list only: omit selling price (other lists always show VK)
- print for tax office: replaces article names with "drug" or a free text
- several customers: progress window with cancel, printed directly
- one customer: preview (can create a PDF)
- Print layout:
- lines sorted newest first by default; oldest-first is configurable in the print-forms module
- address block fits a window envelope
- in networks, lists the pharmacies where the customer bought
- variants: collective voucher; without header/footer; anonymised
- Digital output to app customers, which they can view or export as PDF.
Birthday list (Geburtstagsliste) [GENERIC]
- Criteria:
- age range (optional)
- only round birthdays: "all" = 30, 40, 50, 60, then every 5 years from 65 (65, 70, 75 …); or one specific anniversary (e.g. 50)
- window: relative from today (e.g. next 2 weeks) or absolute
- only active customers
- only customers whose origin is a given branch (networks with contact exchange only)
- save as default
- Result: name, address, birth date, age today, age on the birthday, inactive flag. Default sort by month and day of birth (next birthdays first); reversible.
- Actions: open customer details; print the list or address labels.
- Labels: standard address of the marked contacts, in list order; N labels per contact; long text shrinks to fit; Eltron label printer, 90 × 35 mm labels.
Drug recall – customers [GENERIC]
- Period, article(s), optional batch → customers who bought them.
- Select a customer → Print generates a recall letter.
4.10 Prescription, insurer and regulatory analyses
Prescription billing (ARZ) [DE-SPECIFIC]
Idea underneath: reconcile what the pharmacy claimed from payers in a period against the billing centre's statement.
- Permission: role Manager, or right "Analyses: run Prescription billing (ARZ)".
- Criteria:
- include zero-amount prescriptions (price below the co-payment threshold, so the printed amount is 0)
- include care-aid billings
- customer
- prescription number
- period by dispensing date (relative or absolute; more than 3 months is slow)
- Result: overall statistics; Details lists each prescription with prescription no., dispensing (print) date, physician, customer, gross = Σ VK − extra costs paid by the customer, co-payment, packs.
- Cancellations: shown in italics with negative values; can be shown or hidden.
- Sortable; the print keeps the sort order.
Insurer discount change calculation (Kalkulation Kassenabschlagsänderung) [DE-SPECIFIC]
Idea underneath: a what-if recalculation of a retroactive per-unit payer rebate over billed claims.
- Criteria:
- old discount (default 1.75 €) and new discount (default 2.05 €) per Rx pack
- billing period (one discount rate must have applied throughout)
- payer filter, manufacturer filter
- subtotals per payer and/or per manufacturer
- Result: difference amount, # GKV prescriptions with discounted lines, # lines, # packs.
- Per-payer table: payer + IK, # Rx, # lines, # packs, difference.
- Per-manufacturer table: # lines, # packs, difference.
- The tables are linked: selecting a payer filters the manufacturer table.
IBV analysis (internal business comparison) [DE-SPECIFIC format; GENERIC idea] (definitions in §6.3)
- Purpose: a monthly benchmarking sheet in the format of a pharmacy tax-advisory firm (Treuhand Hannover). Not required by tax law.
- Roles: Manager or Revenue manager.
- Input: one past month (MM.YYYY). The current month is refused with a notice.
- Output: print preview.
Antibiotic consumption analysis (Antibiotikaverbrauchsauswertung) [DE-SPECIFIC]
Idea underneath: a pharmacy that supplies hospitals computes antimicrobial consumption density (defined daily doses per 100 patient-days or 100 cases, by ATC group and route) for infection-control reporting to the public-health authority.
- Licence: clinic edition.
- Legal basis: German infection-protection law (§23(4) IfSG, 2013 definition); hospitals report at least yearly to the RKI. Only certain ATC groups are required.
- Criteria:
- clinic or unit
- patient days and/or cases
- year: at least the last 2 years plus any year with occupancy data
- month range or whole year
- include the previous-year comparison
- A completeness check runs first. If data are missing, a notice is shown.
- Warning: DDD reference data are replaced at each start of year (after confirmation). The previous data state is lost and cannot be restored, so finish the previous year's analyses first.
- Result: ATC code, reference substance, DDD, route, daily doses, density per 100 patient days, density per 100 cases. Detail per ATC: PZN, name, DAR, unit, DDD per pack, packs dispensed, daily doses.
- DDD maintenance:
- filters: only incomplete entries, only incompletely calculated articles, only not-yet-checked updated entries
- ATC codes without a DDD shown in red italics
- icons: self-entered DDD; no or not fully automatic DDD; consumption not computable for all articles; delivered DDD updated, please review
- details: edit, add or delete DDDs per reference substance (substance search)
- article assignments: only articles dispensed in the period by default; can show all articles of the ATC code
- Occupancy data:
- per unit and sub-unit with separate delivery
- year; toggle between patient days and cases
- monthly values Jan–Dec plus a non-editable year total
- "all units of the clinic"
- warning icon with a tooltip when data are incomplete
- Print:
- whole clinic/unit, grouped by sub-unit, or grouped by chemical subgroup
- "trend vs previous year" when the comparison is included
- Excel export from the preview for the clinic
Covid-19 vaccine self-declaration [DE-SPECIFIC]
Idea underneath: a periodic special claim voucher for state-funded items, signed by the manager, with an audit log of every print and a recurring reminder.
- Period (default current month).
- Number of vials per billing position, at most 3 positions per voucher.
- Printed on the special voucher form with the special PZN printed automatically.
- Only for the pharmacy's main IK.
- Handwritten signature by management; submitted with the prescriptions to the billing centre.
- Print history filter/columns: month, IK, operator, print date, time.
- Task series as in §4.2.
EC sales list (Zusammenfassende Meldung) [EU-SPECIFIC]
Idea underneath: a periodic tax export of tax-exempt cross-border B2B sales per customer tax ID.
- Background: VAT-exempt intra-EU B2B supplies (§6a UStG) must be reported monthly and electronically.
- Input: month.
- Rows: per customer VAT ID: country code, VAT ID, amount in whole euros (cents dropped), supply type always "L".
- Export: CSV to a fixed network folder, file name
ZM-YYYY-MM.csv; a confirmation message is shown.
4.11 Cockpit — overview and filters [GENERIC]
- Purpose: a fast economic and financial overview of the pharmacy (and its branches) for the owner or branch manager. KPIs for a day or a month, as gauges, tables and charts.
- Trigger: Office › Cockpit. It opens on today, for the own pharmacy, for all transactions, computed live to the minute.
- Filters:
- Time:
- Day view: default today, full day up to now; any past day via the date picker.
- Month view: the month of the selected day up to now; any past month or year.
- Branch: the pharmacy short code (e.g. a 3-letter code). Switching needs permission and the Profi licence.
- Transaction type: All / Front office / Back office.
- Back office if any of the following holds:
- an invoicing transaction (e.g. advance delivery) last edited at a secondary workstation
- completed outside regular opening hours, or during emergency service outside regular hours
- a GKV sale with prescription status "practice supplies" (Sprechstundenbedarf)
- a customer with role care home, employee or company (non-natural person), or a customer group flagged as back-office customer
- completed at a workstation flagged as back office (secondary workstation)
- Front office = everything else completed within opening hours.
- Back office if any of the following holds:
- Workstation config "Use of POS": a POS in the back office must be set to "back-office POS", and a secondary workstation in the front office to "secondary workstation in front office". Otherwise the classification, and with it the service level and customer frequency, is distorted in both the cockpit and the reports.
- Time:
- Editions:
- Standard (free): day view only; trend icons and trend text only for the 4 main KPIs; no branches.
- Profi (paid): month view; all branch and partner pharmacies; web access; special report queries (§4.13).
- Display:
- Main KPI areas (gross revenue, customers, gross profit and so on) with value, Ø/h and Ø/h(30 days) (or Ø/day and Ø/day(12 months)), trend icon and trend %.
- Expand icon to show component KPIs (e.g. the parts of gross revenue).
- Service-level gauge with coloured zones (steady / better / worse); expandable to its inputs.
- Remaining KPIs in a table; composite KPIs expandable.
- Bold = top-level KPI; normal = component.
4.12 Cockpit — averages, trends, targets [GENERIC] (formulas in §6.4; KPI definitions in §6.2)
- Each KPI has reference values: hourly averages (day view) and daily averages (month view), each for the current period and a longer reference window (30 days or 12 months).
- Trend icons:
- steady / better / worse (better and worse depend on the KPI's polarity)
- rising-edge / falling-edge icons show only direction
- "----" when the trend cannot be computed
- Target and should-be values (day view; gross revenue, number of customers, gross profit; shown coloured):
- Target (Zielwert): the projected end-of-day value if today matches the 30-day average hourly value over all of today's opening hours. The minimum to aim for.
- Should-be (Sollwert): what the KPI should be right now if the 30-day hourly average had been achieved since opening.
- The two converge toward closing time.
4.13 Cockpit Profi report queries [GENERIC]
- In the Reports module, category Pharmacies/Branches, ready-made business-KPI queries are visible to Profi users without the "MMR" reports licence. They are marked with a small cockpit icon.
- No import or export; grouping is unrestricted.
- Editing them or creating new queries needs the Reports licences. (Reports itself is documented elsewhere.)
5. Workflows
W1 – Run any analysis and act on it
- Office › Analyses → pick the analysis → run.
- If it has criteria, set them (optionally "save as default") and confirm.
- Review the result: header (period, criteria), rows, footer totals, detail area.
- Mark rows and choose an action: order (cart dialog), return (return dialog), write off (wizard), change status, change flags, details.
- Print: with no marks the whole list prints; with marks the user chooses marked or all; then preview → print, or e-mail, PDF or Excel from the preview.
- Change criteria and re-run as needed.
W2 – Twice-monthly price change service routine
- Before activation (the service is imported a few days ahead): run the analysis and review the Rx stock articles tab (RxAktuell). Set "preferred for dispensing" on items whose contracts lapse, return part of the stock, and review the fixed amount changes, deleted articles and AV/RR tabs.
- After activation (1st/15th): open the Price change list, filter by storage location, print the price list and shelf labels (own-price cascade, minimum change threshold).
- Open Stock value changes: check losses and gains, capture POR stock if needed. Send electronic claims (manually per manufacturer, or automatically when configured) and print/fax claims for manufacturers that don't support online transmission, optionally adding them to the claims register.
- In Submitted stock value losses: watch the statuses, resend failed claims, record refunds, add notes.
- Optional: set two reminder tasks per month for this analysis.
W3 – Stock-value-loss claim lifecycle
- The service is activated and losses are computed from the stock at activation.
- Send: automatic (all participating manufacturers) or manual (chosen manufacturers), or print/fax.
- Status is in processing; the manufacturer replies accepted or rejected; a transport failure gives transmission error, which can be resent.
- The user records refund received with an amount, or no refund received. A late letter can flip accepted ↔ rejected.
- Printed entries can be deleted from the list. The list shows the last 12 months.
W4 – Stock cleanup
- Run Supplier (no sale since last delivery, expiry within N months), Newly stocked articles (not sold since listing), Article prices (expensive items) or Discontinued articles.
- Mark rows → return to the last supplier, write off (with reason and expiry lines), or change status to negative or POR.
- Use Negative articles with stock ≠ 0 to clean up inconsistent statuses.
W5 – Assortment growth
- Run Suggestions for new stock listings (sales + no-sales of non-stock items ≥ minimum quantity in the period).
- Mark rows → order (fixed quantity or optimisation) → at goods receipt mark them as POS/POR.
W6 – Robot reconciliation
- Make sure all ejected packs are back in the robot and no ejection sales are open; confirm the prompt.
- Choose the difference formula (with or without back-orders).
- In Reconciliation: investigate each difference, then adopt the robot stock for confirmed rows. Shortfalls below the minimum stock are reordered automatically.
- Fix Overstock and Unknown rows manually in article details. Use Robot stocking once when opening a new pharmacy.
W7 – Customer co-payment / purchase statement at the counter
- During a sale, assign the customer and press the co-payment list, prescriptions or purchases button (the customer is preselected).
- Choose the period (current/previous year), branch scope and options (fees, co-payment-free lines), and include family or home residents if applicable.
- Print (preview, optionally "print for tax office", optionally without VK on the co-payment list), produce a PDF, e-mail it, or send it to the customer's app mailbox.
W8 – Batch recall
- Drug recall – purchasing: enter article and batch → the suppliers that delivered it; print the result, or print the negative proof if nothing was found.
- Batch analysis: the movement history of the batch.
- Drug recall – customers: customers who bought it → print a recall letter for each.
W9 – Antibiotic consumption report for a clinic
- Maintain occupancy data (patient days or cases per month per unit).
- Run the analysis (clinic/unit, year, months, previous-year comparison); resolve the completeness notices; maintain missing DDDs.
- Print grouped as required (trend vs previous year) and export to Excel for the clinic.
- Finish the previous year before the yearly DDD update.
W10 – Monthly management routine
- IBV analysis for the last month (print).
- Supplier purchase volume (year-on-year by month), Purchasing structure (last completed month or quarter) for wholesaler negotiations.
- Self-declaration voucher on the first working day (task series).
- EC sales list CSV export if the pharmacy delivers to EU businesses.
- Cockpit month view (Profi) to compare Ø/day with Ø/day(12 months).
W11 – Daily cockpit check
- Open the cockpit (today, own pharmacy, all transactions).
- Compare gross revenue, customers and gross profit with their should-be and target values; read the trend icons against the 30-day hourly average.
- Switch to front office to judge counter performance and customer contacts; switch branch (Profi) to compare branches; open a past day if needed.
6. Business rules and calculations
6.1 Analysis formulas and rules
- Stock value loss/gain per article = stock at the activation date × (Apo-EK new − Apo-EK old). Both prices are net of the statutory reimbursement amount (a §130b SGB V negotiated price reduction) where applicable. Diff = new − old Apo-EK.
- Subtotals: per manufacturer. Grand totals: total loss and total gain.
- Minimum-value filter: per article, or per manufacturer (sum of its articles compared with the minimum).
- Per-manufacturer loss printout: totals net and gross, with the VAT shown separately.
- Price change list: diff € = new − old selling price; diff % relative to the old price. If both Apo-VK and UVP changed, the UVP difference is shown. Blank if the old or new price is missing. Same for Apo-EK.
- Label price cascade: with own prices: own VK → UVP → Apo-VK. Otherwise: UVP → Apo-VK → own VK. An own VK on a label is marked with
*. - Label count: see §4.5(a). Warning above 1,000 entries; hard limit 20,000.
- FB change classification: new (none → some), deleted (some → none), increase (old < new), decrease (old > new). Flags only when |difference| ≥ the configured minimum. Optional flag when the current VK exceeds the updated FB.
- Delivery value sum (Manufacturer analysis) ≈ Σ(stock × average EK), excluding POR articles.
- Estimated stock value (Newly stocked) = Σ(stock × average EK).
- Delivery value (Supplier analysis) = EK at delivery × quantity ordered from that supplier in the period; footer = Σ.
- Supplier purchase volume: net = Σ posted purchases (by invoice date) − Σ posted credit notes (by credit-note date), per month, current year vs previous year. The unposted return value is shown separately.
- Minimum stock shown in POS articles without stock = (fixed minimum + variable minimum) / 2.
- Discontinued flag: no automatic reorder at zero stock for POS articles; status becomes negative after the last pack is sold.
- Status change to POR: stock and reservations are deleted silently.
- Write-off value = EK basis × % (or a fixed amount) × quantity, as implied by the wizard; the exact formula is not stated. An undone write-off stays visible as cancelled.
- Insurer discount change: difference = Σ over discounted positions of (new − old discount). The discount is per Rx pack, so effectively (new − old) × packs. The period must have a single discount rate. Defaults: old 1.75 €, new 2.05 €.
- Prescription billing gross = Σ VK of the prescription − extra costs paid by the patient. Cancellations are counted negative.
- Customer statements: prescription lines are dated at prescription print; other lines at the last activation. The "GKV" sum = co-payments + extra costs.
- Birthday anniversaries: 30, 40, 50, 60, then every 5 years from 65.
- RxAktuell relevance window: payers with prescriptions in the last 3 months. Default dispensing look-back 90 days. Payer importance = the payer group's share of total prescription volume (star rating). Article % = this article's dispensings / all Rx dispensings in the period (GKV-with-contract only).
- Antibiotic density: daily doses (per article) = packs dispensed × DDD per pack. Density = Σ daily doses / patient days × 100 (or / cases × 100), per ATC group and route. This is the standard formula; the help names the result but does not spell out the arithmetic.
- Robot difference:
system − robot, orsystem − (robot + back-order). On adoption, robot stock replaces system stock; if robot stock < minimum stock, the shortfall is auto-ordered via order optimisation. - EC sales list amounts: whole euros (cents dropped).
6.2 Cockpit KPI definitions
| KPI (German) | Definition |
|---|---|
| Gross revenue (Bruttoumsatz) | Σ sales incl. VAT − Σ position discounts (customer discounts + statutory-insurer discounts). Not reduced by receipt-level total discounts |
| Net-net revenue (Netto-Netto-Umsatz) | Revenue of all priced positions (split-pack positions handled separately) excluding insurer discount, customer discounts and VAT. Not reduced by total discounts (these are not allocated to positions) |
| Insurer discounts (KK-Rabatte) | Σ the legally mandated discounts to statutory insurers on Rx dispensing |
| Position discounts (Positionsrabatte) | Σ customer position discounts: manual, instant, customer discount models, free-quantity discounts |
| Total discount (Summenrabatt) | Σ discounts on the receipt total that cannot be attributed to a position |
| VAT (Umsatzsteuer) | Σ VAT contained in the selling prices |
| Cost of goods (Wareneinsatz) | (revenue-relevant quantity sold + free quantity) × stock-weighted effective EK at the time of sale. For split packs, the priced quantities. Stored per sale position. Parenteral preparations: cost of goods EK assumed at 99 % (basis not stated). Wareneinsatz % = cost of goods / net-net revenue |
| Gross profit (Rohertrag) | Net-net revenue − cost of goods. Rohertrag % = gross profit relative to cost of goods (as stated in the help; see §13) |
| Operating costs → operating result (Betriebsergebnis) | Monthly operating costs from company master (Finance). Day view: monthly costs / 30. With the front/back-office filter, costs are split by the ratio of front-office to back-office gross revenue. The help does not state the full formula; the implied result = gross profit − operating costs + cash pay-in/pay-out balance |
| Cash pay-ins/pay-outs (Einzahlungen/Auszahlungen) | Balance of cash movements at the POS (no revenue effect). Positive increases the operating result, negative decreases it. Split front/back by gross revenue ratio |
| Theoretical margin (Theoretische Spanne) | (net VK − stock-weighted effective EK) / net VK, using standard prices before any discount. Theoretical revenue stored per position |
| Net revenue incl. discounts | Net-net revenue + position discounts + insurer discounts |
| Real margin (Reale Spanne) | Same formula with the actually achieved prices (after position discounts) |
| Discounts % (Rabatte) | Theoretical margin − real margin (margin points lost to customer and insurer discounts) |
| Number of customers (Anzahl Kunden) | One per fully completed sale or invoicing order. Counts totals/orders whose subtotals have no predecessor, so only the first total in a chain counts. Activations and pickup settlements with a newly recorded subtotal count. Advance deliveries count when settled. Buy-backs/returns and transfers never count |
| Number of packs (Anzahl Packungen) | Σ revenue-generating packs: article positions, special PZNs, compounding positions; services excluded |
| Number of sales (Anzahl Verkäufe) | Number of sold positions |
| Number of procurements (Anzahl Besorgungen) | Positions requested by customers that had to be procured (negative sales) |
| Procurement rate (Besorgerquote) | Requested-but-not-in-stock positions / sold positions. Includes wanted and unwanted procurements, permanent special orders and no-sales. Excludes deliveries to branches |
| Service level (Lieferbereitschaft) | 100 % − procurement rate (e.g. 30 % → 70 %). Equivalently in-stock positions / sold positions |
| Basket size (Korbumsatz) | Gross revenue / number of customers. For averages: average gross revenue / average customers |
6.3 IBV (internal business comparison) definitions and M-Bon mapping
- Scope: POS sales plus invoicing (all effective revenue from invoicing orders in the month). Ignores daily closing (Z-receipt) boundaries.
- Stock value at month end: at ABDA-EK, average EK, own EK and effective EK. Reduced by back-order goods already paid and waiting for pickup. A stocktaking valuation, by contrast, counts all physical goods.
- High-priced articles: Apo-EK > 1,238.53 € per pack, reported separately.
- Customer count, economic view: every sale in front and back office; follow-up steps with no extra revenue (pickup or credit settlements without an additional sale) are not counted.
| IBV line | Meaning | M-Bon equivalent |
|---|---|---|
| (1) | Revenue, private incl. green prescriptions | "private + green prescription" (b) |
| (2) | – thereof Rx drugs; also "thereof EK > 1,238.53 €", "thereof green non-Rx" | – |
| (3) | Revenue, normal (non-prescription) sales | "normal sale" (a) |
| (4) | Revenue, GKV prescriptions | GKV prescription (c) − thereof insurer discount (d) |
| (5) | – thereof GKV Rx drugs; also "thereof EK > 1,238.53 €" | – |
| (6) | – thereof GKV extra costs | (e) |
| (7) | Number of billed GKV prescriptions (incl. invoicing) | – |
| (8) | Packs, private incl. green | – |
| (9) | – thereof Rx; also "thereof high-price", "thereof green non-Rx" | – |
| (10) | Packs, normal sales | – |
| (11) | Packs, GKV | – |
| (12) | – thereof GKV Rx; also "thereof high-price" | – |
| (13) | Total packs sold | "number of packs" (g) |
| (14) | Customers (economic view) | – |
- M-Bon "packs thereof Rx" (f) = (9) + (12). IBV does not count Rx packs sold in normal sales.
- IBV is comparable only to an M-Bon or T-Bon computed without Z-receipt boundaries, and only for POS values.
6.4 Cockpit averages and trends
- Period value (day or month): all sales in the period regardless of opening hours.
- Day view Ø/h and Ø/h(30 days): € and count KPIs = Σ over sales within opening hours / elapsed opening hours (minute-accurate).
- Before opening: no value.
- Within the first opening hour: extrapolated to one hour (e.g. 1,200 € after 30 min → 2,400 €/h).
- Example: sales of 100 € at 7–8 and 100 € at 8–9 (before opening) and 1,000 € at 9–12 → at 12:00 revenue = 1,200 €, Ø/h = 1,000 / 3 = 333.33 €.
- Month view Ø/day and Ø/day(12 months): Σ over sales within opening hours / (completed opening days, i.e. days with at least one opening minute counted as full days, + the fraction of today's opening time elapsed).
- Example, 3 May 13:00: 1 May 5,000 € (100 € outside hours); 2 May 3,000 € (500 € outside; a short 4-hour day still counts as 1 day); 3 May 1,000 € so far (4 of 8 opening hours = 0.5 day).
- Month value = 9,000 €. Ø/day = (4,900 + 2,500 + 1,000) / 2.5 = 8,400 / 2.5 = 3,360 €.
- Ratio KPIs (%, basket size): numerator and denominator summed separately over the same sales, then divided. The "per hour/day" label is nominal.
- Trend for absolute KPIs = (current − reference) / |reference| × 100 %.
- Example: −100 € vs −200 € → +50 %.
- Example: −300 € vs 1,000 € → −130 %.
- Trend for % KPIs = current − reference, in points. Example: 30 % − 35 % = −5 points.
- No trend ("----") when it cannot be computed (e.g. reference 0).
- Target value = Ø/h(30 days) × today's total opening hours.
- Should-be value = Ø/h(30 days) × opening hours elapsed so far.
- Operating costs in day view = monthly costs / 30.
7. Configuration and settings
| Parameter | Scope | Effect | Default |
|---|---|---|---|
| Saved default criteria (Als Standard speichern) per analysis / per tab | Per analysis (user vs pharmacy scope not stated) | Criteria used on the next run; also used when an analysis is opened from a reminder task | Delivered defaults (e.g. RxAktuell cleanup preset) |
| Automatic online transmission (Automatische Onlineübermittlung) | System parameter, settings of Analyses & Statistics, page "Stock value losses" | Automatically sends stock-value-loss claims to all participating manufacturers after each change-service activation that produces losses | Not stated |
| Type of stock keeping (Art der Lagerhaltung) | System parameter, article management, page "Stock keeping" | POS vs POR stock keeping; affects label counts, POR stock capture, demand statistics (sales vs purchases) | Not stated |
| Storage of negative articles (Einlagerung von Negativartikeln) | System parameter, system maintenance, page "KS system" | Whether negative articles may be stored in the robot; affects robot difference calculation | Not stated |
| Use of POS (Nutzung der Kasse) | Per workstation | Marks a POS as back-office POS or a secondary workstation as front-office, for correct front/back-office classification in the cockpit and reports | Not stated |
| Monthly operating costs | Company master › Finance | Basis for the cockpit operating result | – |
| Company address, tax number, bank details, phone | Company master › Master data / Finance | Required for electronic stock-value-loss claims | – |
| Customer group flag "back-office customer" | Customer group | Sales to these customers count as back office in the cockpit | – |
| Print form "Customer analyses" › sort ascending by date | Print forms module | Line order on customer statements (default newest first) | Descending |
| User-defined write-off reasons | Write-off dialog | Extra reasons in the dropdown, persisted | – |
| Contact e-mail + encryption password | Contact | Enables direct e-mail of customer analyses, encrypted when a password is set | – |
| Occupancy data, DDD overrides | Antibiotic analysis | Inputs for the density calculation | – |
| Insurer discount old/new | Criteria | Defaults 1.75 € / 2.05 € | 1.75 / 2.05 |
| Reminder task defaults | Notes | 1st of month 09:00–09:15, current operator | as stated |
| Licences | Pharmacy | RxAktuell (Rx stock articles tab and counter icons); Cockpit Profi (month view, branches, web access, special report queries); clinic edition (antibiotic analysis); "Meine Apotheke" (digital statements); branch/partner network data exchange (branch scope options) | – |
8. Roles and permissions
| Function | Required role or right |
|---|---|
| Create/edit/delete reminder tasks, see task control | Right "Notes: edit task" (in roles Manager and "Notes: edit task") |
| Write off articles (bulk write-off) | Right "Write off", or role Assortment manager or Manager |
| Write-off book | Right "Run write-off book", or role Assortment manager or Manager |
| Change stock status (bulk), change stock manually | Role Manager or Assortment manager |
| Purchasing structure | Role Manager, Revenue manager or Report manager |
| IBV analysis | Role Manager or Revenue manager |
| Picking-system stock differences | Role Manager or Assortment manager |
| Prescription billing (ARZ) | Role Manager, or right "Analyses: run Prescription billing (ARZ)" |
| Supplier purchase volume, Covid self-declaration | Protected by the permission concept (specific right not named) |
| See hidden/anonymised customer sales in statements | Specific user right (not named) |
| Open cockpit | Role Manager or Revenue manager, or right "Cockpit: start module" |
| Change cockpit branch filter (see branches) | Role Manager or Revenue manager, or rights "Cockpit: start module" + "Cockpit: see branch pharmacy" |
Permissions are enforced only when the pharmacy has activated the permission concept (workstation or user protection).
9. Integrations, hardware and external services
- Notes module: reminder task series for analyses; "Today's tasks" when a user opens their session.
- E-mail mailbox: sending analyses from the print preview or directly to customers, with encrypted attachments when a password is stored.
- Stock-value-loss web service (third-party provider) for electronic claims to participating manufacturers; manufacturers identified by IDF numbers; status feedback (accepted, rejected, error).
- Fax: printed claims to manufacturers without online support.
- Automated picking system (robot): inventory, expiry dates and storage locations read; automatic ejection when returning; stock adoption.
- Label printers: shelf price, base-price and location labels; address labels on an Eltron printer (90 × 35 mm).
- Patient app/web portal ("Meine Apotheke"): digital delivery of customer statements to the in-app mailbox.
- Billing centre (ARZ): comparison basis for prescription billing; special vouchers submitted with prescriptions.
- Tax authority portal: EC sales list CSV for upload (e.g. via the German tax-filing portal).
- National drug data (ABDATA change service twice monthly; DDD reference data updated yearly by the national medical documentation institute).
- Excel/CSV/PDF file outputs.
- Cockpit web access (Profi).
10. Printouts, reports and exports
- Generic analysis list printout (marked or all), via preview, with print, e-mail or PDF.
- Price change list, with sort and initial-letter range.
- Shelf labels from the price change list: price, base-price and location labels, price list for price marking; own-price
*marker. - Stock value changes: total list (with grand totals), or losses per manufacturer (net, VAT, gross totals) for fax.
- Rx stock articles list with criteria and the RV-Info column.
- Write-off book / accounting voucher (quantities, values, voucher no., date, totals).
- Manufacturer analysis, with or without monthly sales statistics.
- Drug recall customer letter; recall purchasing list, or negative-proof page.
- Antibiotic consumption report (whole, by sub-unit, by chemical subgroup, with trend vs previous year) and Excel export.
- Batch movement report.
- Purchasing structure Rx and Purchasing structure total.
- Birthday list; address labels.
- Wholesale stock value losses (preview).
- IBV monthly sheet.
- Insurer discount change calculation (totals, per payer, per manufacturer).
- Robot difference lists.
- Supplier, Supplier purchase volume, Negative articles, Newly stocked, POS without stock, Suggestions for new listings: list printouts.
- Prescription billing statistics and detail list (sort kept).
- Covid-19 vaccine special voucher (special PZN, main IK, max 3 positions), plus print history.
- EC sales list CSV
ZM-YYYY-MM.csv. - Customer statements (purchases, self-medication, prescriptions, combined, co-payment list): window-envelope layout; branch list; tax-office mode; optional VK omission; anonymised variant; PDF; e-mail; app.
11. Dependencies on other modules
- Notes (tasks and reminders).
- Article management: article master, stock data, status date, order optimisation and minimum stock, storage locations.
- Purchasing: carts, order-quantity optimisation, returns, goods receipt, back-orders/pickups.
- POS and invoicing (Faktura): sales data, transaction chains, cancellations, co-payments, discounts, cost of goods per position; POS buttons for customer statements; comparison searches showing RxAktuell icons.
- Prescription management and billing (ARZ).
- Contacts: customers, homes, families, suppliers, manufacturers, payers, e-mail, VAT ID.
- Company master: operating costs, tax/bank data, IK.
- System settings: stock keeping, robot, workstation usage, automatic online transmission.
- Print forms and print settings; e-mail mailbox.
- Reports module: Cockpit Profi queries, report licences (MMR).
- Branch and partner network: data exchange of stock, statistics and contacts.
- Clinic supply: clinic/unit structures, invoicing settings for homes and clinics.
- Picking system interface.
12. Portability notes
- Generic and directly reusable:
- the analysis catalogue pattern (criteria dialog → result list → bulk actions → print/e-mail/export, with saved defaults and recurring reminders)
- slow-mover, newly-listed-not-sold, out-of-stock, data-quality, price-outlier and demand-driven listing analyses
- write-off book with reasons, vouchers and undo
- supplier purchase volume year-on-year
- batch traceability (upstream suppliers, downstream customers, recall letters, negative proof)
- robot reconciliation
- birthday CRM list and labels
- customer annual purchase statements (useful anywhere for insurance or tax evidence)
- the full cockpit KPI model: gross/net revenue, cost of goods at moving effective cost, gross profit, theoretical vs real margin, discount leakage, customers per transaction chain, packs, service level vs procurement rate, basket size, operating result with prorated costs; opening-hours-aware averages, trend formulas, target and should-be pacing lines; front- vs back-office split; branch filter
- For Syria, keep the formulas; replace € and VAT with SYP and local tax; make the opening-hours calendar per branch.
- Germany-specific, with the idea underneath:
- Price change service and stock-value-loss claims → handle supplier or official price-list updates with old/new price snapshots, automatic stock revaluation at the effective date, shelf-label reprint lists, and a claim-tracking register for supplier credit notes when a supplier cuts prices.
- Fixed amounts (Festbetrag) → payer reimbursement ceilings per product, and a warning when the shelf price exceeds the ceiling.
- Discount contracts (RxAktuell) → payer- or formulary-aware assortment: weight payers by their share of the pharmacy's prescription volume and flag stocked items losing formulary status.
- Insurer discount change calculation → what-if recalculation of a per-unit payer rebate over historical claims.
- Prescription billing (ARZ) → reconcile claims submitted to a payer or third-party administrator.
- IBV → a standardised monthly KPI sheet for benchmarking pharmacies (e.g. for a chain or an association).
- Antibiotic consumption → hospital-supply stewardship reporting (DDD per 100 patient days, by ATC).
- Covid self-declaration → periodic signed claim vouchers for state-funded programmes, with a print audit log.
- EC sales list → periodic tax export of exempt cross-border B2B sales.
- Co-payment list legal wording → payer-as-service-recipient notices on patient documents.
13. Open questions
- Scope of "save as default": per user, per workstation or per pharmacy?
- Purchasing structure: which wholesale price tiers and columns appear (only shown as an image)?
- Prescription billing (ARZ): which figures are on the statistics screen (only shown as an image)?
- Gross profit % is stated as "gross profit relative to cost of goods" (a markup on cost), whereas margin is usually relative to revenue. Confirm the intended denominator.
- Operating result: the exact formula (presumably gross profit − prorated operating costs ± cash balance) is not spelled out.
- Cost of goods for parenteral preparations "assumed at 99 %": 99 % of what (of the selling price?)?
- Cockpit: the full list of displayed KPIs per area (beyond the definitions table), the 4 "main KPIs" in the Standard edition, and how the service-level gauge zones are defined numerically.
- Cockpit web access: authentication and refresh behaviour are not described.
- Write-off value formula and the list of purchase-price bases offered are not described.
- Article prices analysis: the list of selectable price bases is not given.
- Price change list print: the available sort criteria are not listed.
- Stock value loss "per EK" minimum option: wording suggests "per article"; confirm.
- Status column thresholds (P / −P) differ between pages (>99 / <−9 vs >999 / <−99), probably depending on column width.
- Birthday list: does "contacts" include non-customer contacts?
- Relative period units available in each analysis (days/weeks/months/years) differ; not fully enumerated.
- Whether results can be exported to a spreadsheet generically (only the antibiotic analysis mentions Excel).
- Self-declaration naming: the start page mentions an emergency-service-fund (Notdienstfonds) self-declaration, the detail pages only the Covid-19 vaccine one. Are these one analysis or two?
- Retention of the stock-at-activation snapshot for older change services (24 services can be browsed; is stock kept for all?).
14. Source pages
- Auswertungen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/01_auswertungen_start.htm
- Artikelliste abschreiben — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/Massendaten/artikelliste_abschreiben.htm
- Artikelliste bestellen (Auswertung) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/Massendaten/artikelliste_bestellen.htm
- Artikelkennzeichen ändern — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/Massendaten/artikelliste_kennz_aend.htm
- Artikelliste retournieren (Auswertung) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/Massendaten/artikelliste_retournieren.htm
- Artikelliste Lagerstatus ändern — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/Massendaten/artikelliste_status_aendern.htm
- Massendatenverarbeitung — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/Massendaten/auswert_massendatenverarbeitung.htm
- Preisänderungsdienst (Auswertung) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/01_start_preisaenderungsdienst.htm
- AV/Z/RR-Artikel auswerten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_av-rr-artikel.htm
- Festbetragsänderungen auswerten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_festbetragsaenderung.htm
- Gelöschte Artikel auswerten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_geloeschte_artikel.htm
- Lagerwertveränderungen - Bestände für POR-Artikel manuell erfassen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertv_best_erfass_por.htm
- Lagerwertveränderungen auswerten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertveraenderungen.htm
- Lagerwertveränderungen drucken — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertveraenderungen_druckkriterien.htm
- Eingereichte Lagerwertverluste — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertverluste_eingereichte.htm
- Elektronischer Lagerwertverlustausgleich - Unterstützende Anbieter — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertverluste_elektronisch_ueb_anbieter.htm
- Anzeigeoptionen für eingereichte Lagerwertverluste — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertverluste_elektronisch_ueb_anzeigeopt.htm
- Meldung zu Lagerwertverlusten bearbeiten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertverluste_elektronisch_ueb_bearb.htm
- Lagerwertverluste manuell an Anbieter senden — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_lagerwertverluste_senden.htm
- Neuaufnahmen auswerten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_neuaufnahmen.htm
- Preisänderungsliste erzeugen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_preisaenderungsliste.htm
- Preisänderungsliste und Etiketten drucken — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_preisaenderungsliste_etiketten_druckkriterien.htm
- Rezeptpflichtige Lagerartikel auswerten (RxAktuell) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_rx-artikel.htm
- Auswertungskriterien für Rx-Lagerartikel einstellen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_rx-artikel_kriterien.htm
- Artikelkennzeichen für in Kürze entfallende Rabattverträge — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/PAD/pad_rx_artikel_artikelkennzeichen_vgl_suchen.htm
- Abschreibebuch — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/abschreibebuch.htm
- Anbieter — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/anbieter.htm
- Artikelpreise — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/artikelpreise.htm
- Arzneimittelrückruf — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/arzneimittelrueckruf.htm
- Arzneimittelrückruf (Einkauf) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/arzneimittelrueckruf_einkauf.htm
- Auslaufartikel — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/auslaufartikel.htm
- Druckoptionen festlegen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/auswertungen_druckoptionen.htm
- Antibiotikaverbrauchsauswertung — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/ava.htm
- Belegungsdaten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/ava_belegungsdaten.htm
- Definierte Tagesdosen verwalten — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/ava_ddd_verwalten.htm
- Antibiotikaverbrauchsauswertung drucken — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/ava_drucken.htm
- Chargenauswertung — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/chargenauswertung.htm
- Einkaufsstruktur — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/einkaufsstruktur.htm
- Geburtstagsliste — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/geburtstagsliste.htm
- Geburtstagsliste oder Adressetiketten drucken — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/geburtstagsliste_druckauswahl.htm
- GH- Lagerwertverluste — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/gh_lagerwertverluste.htm
- IBV-Auswertung — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/ibv-auswertung.htm
- Vergleichbarkeit der monatlichen IBV-Auswertung mit dem M-Bon — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/ibv-auswertung_vergleich_mbon.htm
- Kalkulation Kassenabschlagsänderung — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/kalkulation_kk-aenderung.htm
- KS-Bestandsdifferenzen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/ks_bestandsdifferenzen.htm
- Lieferant — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/lieferant.htm
- Lieferantenumsätze — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/lieferantenumsaetze.htm
- Negativartikel mit Bestand ungleich 0 — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/negativartikel_mit_bestand_ungleich_0.htm
- Neu an Lager gelegte Artikel — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/neu_an_lager_gelegte_artikel.htm
- POS-Artikel ohne Bestand — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/pos-artikel_ohne_bestand.htm
- Rezeptabrechnung (ARZ) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/rezeptabrechnung-arz.htm
- Auswertungsergebnis Rezeptabrechnung (ARZ) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/rezeptabrechnung-arz_ergebnis.htm
- Selbsterklärung für Covid-19-Impfstoffe — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/selbsterklaerung_covid_19_impf_alles.htm
- Aufgabenserie zur Erinnerung an die Selbsterklärung Covid-19-Impfstoffe anlegen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/selbsterklaerung_ndf_aufgabenserie.htm
- Druckhistorie für Selbsterklärungen einsehen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/selbsterklaerung_ndf_historie.htm
- Vorschläge für Lagerneuaufnahmen — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/vorschlaege_lagerneuaufnahme.htm
- Zusammenfassende Meldung — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/zusammenfassende_meldung.htm
- 'Einkäufe insgesamt', 'Verordnungen' , 'AM-Selbstmedikation' und 'Zuzahlungsliste' — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Auswertungen/zuzahlungsliste.htm
- Cockpit — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Cockpit/01_cockpit_start.htm
- Berechnung der Durchschnittswerte — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Cockpit/cockpit_durchschnittswerte_bsp.htm
- Grafische Darstellung der Kennzahlen im Cockpit — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Cockpit/cockpit_grafische_darst.htm
- Kennzahlen im Cockpit — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Cockpit/cockpit_kennzahlen.htm
- Lizenzkonzept und Berechtigungsverwaltung (Cockpit) — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Cockpit/cockpit_lizenzierung.htm
- Spezielle Reportabfragen für Nutzer von Cockpit-Profi — https://ixos-onlinehilfe.pharmatechnik.de/Default/Content/PT6_Buero/Cockpit/cockpit_reports_abfragen.htm