Inventory Tracking and Compliance: Avoiding Controlled Substance Violations

Controlled substance violations usually do not begin with dramatic misconduct. More often, they begin with small operational failures that compound over time: a PDMP file that never went through, a receipt that was never fully posted, an expired bottle still sitting in active stock, a mismatch in counts that no one caught early, or a report that cannot answer a regulator’s question fast enough.

That matters now more than ever. Recent federal action against major pharmacy chains has kept controlled substance dispensing, red-flag review, and documentation under a bright spotlight. In December 2024, the Justice Department alleged CVS filled unlawful controlled substance prescriptions, including dangerous quantities, early fills, and “trinity” combinations.

In April 2025, Walgreens agreed to pay up to $350 million to settle allegations tied to unlawful controlled substance dispensing and agreed to strengthen compliance systems. Even smaller retail pharmacies are still being held accountable for recordkeeping failures: in April 2025, a Connecticut pharmacy paid $192,000 to settle allegations that included incomplete records and failure to perform a biennial inventory.

For an independent pharmacy, that means compliance cannot live in a binder on a shelf. It has to live inside the daily workflow of the pharmacy system. The right pharmacy software does not just help you fill prescriptions. It helps you maintain control over controlled substances, document what happened, and catch problems before they become violations. That is exactly where better pharmacy management software matters most.

Controlled Substance Compliance Is Also an Inventory Discipline Problem

A lot of pharmacies think of controlled substance compliance as a legal issue first. It is that. But operationally, it is just as much an inventory issue.

Controlled substances move through receiving, storage, dispensing, reporting, reconciliation, returns, and destruction. If any one of those steps is weak, the entire chain becomes harder to defend. A pharmacy can have honest people and still have bad controls. And bad controls are exactly what regulators and auditors notice.

CDC describes PDMPs as electronic databases that track controlled substance prescriptions and says they can support point-of-care clinical decision-making. CDC also says PDMP data should ideally be reviewed before every opioid prescription and at least every three months during continuing opioid therapy. That broader oversight environment raises the bar for how clean, timely, and organized pharmacy data needs to be.

At the same time, inventory is already one of the highest costs in an independent pharmacy. Datascan’s own inventory and workflow materials consistently frame inventory control as both a compliance issue and a profitability issue, especially when pharmacies are relying on manual processes, outdated reports, or disconnected systems.

Where Pharmacies Actually Get Exposed

The exposure points are rarely mysterious:

• A PDMP submission gets delayed or rejected, and nobody notices.
• A wholesaler order arrives, but the on-hand quantity in the pharmacy system is not updated correctly.
• Expired or short-dated stock stays mixed into active inventory longer than it should.
• A pharmacist suspects a pattern in dispensing, but the reporting tools are too broad or too clumsy to isolate what happened.
• A count is off, but there is no fast way to trace receipts, fills, adjustments, returns, and user activity in one clean audit trail.

This is why “more careful staff” is not a complete answer. Good people still need systems. Datascan’s automation philosophy is clear on this point: automation should remove workflow friction, not create more screens, more clicks, and more manual follow-up.

What Modern Pharmacy Software Should Do to Help Prevent Controlled Substance Violations and Manage Inventory

1. Scheduled automatic PDMP submissions, with reminders to resubmit when something fails

This is one of the most practical compliance tools a pharmacy can have.

A modern pharmacy system should not rely on someone remembering to generate and send controlled substance reporting files by hand. It should schedule those submissions automatically, keep them moving in the background, and alert the pharmacy when a file fails, partially rejects, or needs to be resubmitted.

That matters because compliance problems are often timing problems before they become legal problems. If reporting is late, incomplete, or quietly rejected, the pharmacy inherits risk it may not even realize it is carrying. In a world where PDMPs are a routine part of controlled substance oversight, exception-based automation is simply safer than manual memory.

Just as important, reminders to resubmit are not a “nice to have.” They are the difference between assuming the work got done and being able to prove it did.

2. Inventory tracking with EDI connections to wholesalers that automatically update inventory when orders are received

This is one of the biggest operational advantages strong pharmacy systems can deliver.

Datascan’s inventory materials emphasize perpetual inventory and wholesaler EDI connections because they reduce manual entry, keep costs updated, and help maintain cleaner on-hand quantities.

When orders are received and the pharmacy system updates inventory through EDI, staff are not stuck re-keying receipts, chasing invoice mismatches, or relying on stale quantities.
That has direct compliance value for controlled substances.

If on-hand quantities are only “mostly right,” your reporting is weaker, your counts are harder to trust, and your ability to answer questions during an audit gets worse fast. A pharmacy computer system should make receiving disciplined, traceable, and current. It should reflect what was actually received, when it was received, and how that receipt changed the pharmacy’s on-hand position.

For independent pharmacies working under reimbursement pressure, that same discipline also protects cash flow. Better receiving data means less overbuying, less guesswork, and fewer unpleasant surprises sitting on the shelf.

3. Expired inventory tracking

Expired inventory tracking is not just about reducing waste. It is about preventing avoidable compliance mistakes.

FDA says expired medical products can be less effective or risky because of changes in chemical composition or decreases in strength, and that once the expiration date has passed, there is no guarantee the medicine will be safe and effective. FDA also says expired or unwanted medicine should be disposed of through preferred methods like take-back or mail-back options when available.

Inside the pharmacy, that means your software should help identify short-dated and expired products before they get anywhere near the fill queue. It should support proactive review, quarantine logic, and reporting that helps staff return eligible product, dispose of what cannot be returned, and work down short-dated inventory before it becomes a loss.

Datascan’s inventory discipline guidance specifically calls out the importance of identifying short-dated medications before they turn into avoidable waste.

When expired inventory tracking is weak, the risk is not only financial. It also creates avoidable exposure around controlled stock handling, documentation, and disposal.

4. Detailed reporting for inventory and controlled substance dispensing, with real filters

This is where many pharmacy systems fall short.

A pharmacy should be able to run detailed reports for controlled substance dispensing and inventory activity with filters that actually help answer questions:

When something looks wrong, a pharmacist should not need to export three spreadsheets and manually reconcile them just to figure out what happened.

Recent federal cases have focused heavily on red flags, early fills, unlawful combinations, internal warnings, and failure to respond appropriately to what the data was already showing. That is exactly why detailed reporting matters.

You need to be able to investigate patterns quickly, document what you found, and act before a concern becomes a violation.

Datascan’s internal blog materials also point out something important: controlled substance reporting is not optional, and some systems still treat core compliance functions like add-ons. Independent pharmacies should be very skeptical of any pharmacy management software that makes this kind of visibility harder, slower, or more expensive than it needs to be.

Other Tools That Matter More Than They Get Credit For

The pharmacies that stay cleaner operationally usually are not doing one heroic thing. They are doing many routine things consistently.

That includes using a scheduler to automate recurring work, using workflow tools that reduce interruptions, and relying on systems that talk to each other instead of forcing staff to bridge gaps manually. Datascan’s recent materials repeatedly make that point: the best automation is the kind that quietly removes repetitive work and keeps the pharmacy moving without adding complexity.

In practice, that can include recurring reminders for cycle counts, compliance checklists, follow-up tasks, unresolved exceptions, reporting confirmations, and routine inventory discipline work that busy pharmacies otherwise push to the end of the day.

A good pharmacy system should also help the pharmacy separate signal from noise. CDC notes that PDMP data can identify risky combinations, including opioids with benzodiazepines, and should support safer clinical decision-making rather than replace judgment. That same mindset applies to reporting inside the pharmacy: the goal is not to drown staff in data. It is to make the right exceptions obvious enough to investigate.

What Independent Pharmacies Should Expect From Their Pharmacy Software

If your current pharmacy software is supposed to support compliance, these are fair questions to ask:

• Can PDMP submissions be scheduled automatically?
• If a file fails, who gets alerted, and how quickly?
• Does the pharmacy system update inventory automatically when wholesaler receipts are posted through EDI?
• Can the system flag short-dated or expired stock before dispensing?
• Can you run detailed controlled substance dispensing and inventory reports without exporting everything to spreadsheets?
• Can you trace activity by drug, user, transaction type, and date when something needs to be reviewed?

If the answer to those questions is vague, slow, or expensive, the problem is not your team. The problem may be your pharmacy management system.

Final Thoughts

Controlled substance compliance is not about hoping nothing goes wrong. It is about building a pharmacy operation where the system helps prevent avoidable mistakes in the first place.

For independent pharmacies, that means better pharmacy software. Not more complexity. Not more manual cleanup. Not more disconnected tools.

It means scheduled PDMP submissions with resubmission reminders. It means EDI-connected inventory that updates when orders are received. It means expired inventory tracking that catches problems early. It means detailed reporting that helps you investigate controlled substance dispensing with real speed and real confidence.

That is how pharmacies avoid violations the right way: not with panic after the fact, but with discipline built into the workflow every day.

FAQs

Why do automatic PDMP submissions matter so much?

Because PDMPs are now a routine part of controlled substance oversight, and manual reporting creates too many opportunities for late, missed, or rejected submissions. Automation reduces that risk, and reminder-based resubmission helps catch exceptions before they become bigger problems.

How does EDI inventory help with controlled substance compliance?

EDI helps keep receipts, costs, and on-hand quantities current. That improves perpetual inventory accuracy and makes reconciliation, reporting, and audit response much easier.

Why is expired inventory tracking a compliance issue, not just a waste issue?

FDA says expired medicines can be less effective or risky, and once the expiration date passes, there is no guarantee they remain safe and effective. Pharmacies need systems that help prevent expired stock from staying active too long. (U.S. Food and Drug Administration)

What kind of controlled substance reports should a pharmacy be able to run?

At minimum, a pharmacy should be able to filter dispensing and inventory activity by date, drug, NDC, schedule, patient, prescriber, quantity, user, and transaction type so unusual patterns can be investigated quickly and documented clearly.