Skip to content
ENS.EG

Pharmacy Stock: Batch and Expiry, Not Quantity Alone

31 Oct 2026

Two packs with the same name can be two batches with two expiry dates. Pharmacy software shows the batch, the expiry, and a list of what is getting close. That is narrower than the general stock-and-sales guide, and different from a supplies order website.

A pharmacy that counts stock by name and quantity alone discovers late that the shelf holds packs expiring this month and packs expiring next year, and the sale took whichever pack was in the hand. Pharmacy inventory software starts from the batch: a lot code, an expiry date, and the quantity inside that lot. The trade name is a catalog unit. The real balance is rows of batches, not one number.

The general inventory and sales guide explains purchasing, selling, and warehouse movement for a broad business. This page does not repeat that guide. It is the difference that matters on a pharmacy shelf: expiry and batch. Read the guide when the question is wider than the drug shelf, such as branches, a shop, and a general sales invoice. Stay here when staff cannot tell which pack should leave first.

What is recorded when goods arrive?

  • The item as it is sold, not a free name that changes each time.
  • The batch code as printed on the pack.
  • The expiry date, and the quantity of this batch.
  • The shelf place if it matters for a count.
  • The supplier invoice reference so quantity can be checked later.

If the same batch arrives on two invoices, quantity is added on the same row. A duplicate batch is not created with a wrong date. If the date differs, the rows stay separate even when the written code looks alike. A simple rule stops an older date swallowing a newer one. Write it for the person who receives goods before the screen is built, because the screen will keep whatever is entered in the first week.

Which batch leaves on a sale?

You choose the rule. Either the screen suggests the batch that expires sooner and the pharmacist confirms, or the pharmacist picks the row and the screen shows both dates. What matters is that stock is not reduced from a nameless total, because then the trace is gone. No legal order is imposed here, and no claim is made that one sequence is required by an authority. If your reviewers require a written sequence, send that text with the request.

A near-expiry list is an operating report: items whose date falls inside a window you set, thirty days or ninety or another window. The list is for a shelf review, not for an automatic sale and not for a discount invented here. What you do with the close quantity, a return to the supplier, an offer, or a write-off, is the pharmacy decision and is stored as a movement with a reason, so balance does not vanish with no trace.

This is not a supplies order website

Laborex is a published example of something else: a website and an online order path for a pharmaceutical and medical supplies company. The customer there submits a supply order. There is no pharmacy till deducting a batch from a public shelf. The line is drawn so Laborex is not used as proof of a dispensary system. If you are a supplier who needs an order site, that is another scope. If you dispense from a shelf with an expiry date, the scope is the batch and the movement.

The count and the gap

A count checks batches, not names alone. A surplus or a shortage is recorded on the batch that was counted. A shortage with no batch cannot be explained: an expired pack may have left with no movement, or a sale may have hit the wrong row. No acceptable shortage ratio is set. The fields are what make the question possible at month end.

What to send in the first message

  • One item that has a batch and two dates if you have that case.
  • Who receives the supplier invoice and who dispenses to the customer.
  • The warning window before expiry, as you want it.
  • Whether there is more than one store or branch.
  • The name of any current program and what gets lost in it.

Shelf questions

Does the program print a barcode label?

If the manufacturer barcode is scanned as it is, a new label is not required. An internal label is discussed when the pack has no clear code. A printer is not assumed in the scope until you mention it.

Is the customer sale included?

The movement out of the batch is included, because otherwise stock does not fall. A full cashier screen with shifts and a drawer is another article if the pain is the till rather than expiry. Say which pain is first.

Can opening balances be imported?

Yes, from a table with item, batch, expiry, and quantity. A row with no date does not enter as a batch. It is completed before import, or it stays outside the controlled balance.

Stock and sales in the wider sense are in the inventory and sales guide. The different supplies order site is Laborex.

Send one item with two expiry dates through start your project. The WhatsApp button under the article can take a pack photo with any price hidden.

Have an idea or a system that needs building?

Tell us about your project in three short steps. We will review it and contact you to agree on the next step.

Start a project