Skip to the page content

Batches and expiry dates

Record the batch and expiry date of every intake, sell what expires first, get a warning, and trace one batch for a recall.

On this page

For medicine, food or cosmetics, you need to know when each item expires. With batches, every intake records a batch number and an expiry date.

This is an extra feature. If its menu is missing, contact the Vende team to switch it on.

Turning on batches for one product

  1. Open the product under Master Data → Products.
  2. In the Tracking section, turn on Track batches & expiry.
  3. If your shop uses the Production feature and this is a product you make yourself, also fill in the Shelf life (see Automatic batch from production). This field only shows while the Production feature is on.
  4. Press Save changes.

The exact expiry date, for example 12/11/2027 or 11/2027, is not entered on the product page. It is entered per batch when the goods come in, as in the next section.

Recording a batch when goods come in

A batch is recorded when goods come in through a purchase, a goods receipt or a stock adjustment in.

  1. On the purchase screen, add the product as usual.
  2. Open the line details of that product: tap or click its name, written in colour like a link.
  3. Fill in the batch number, the expiry date, or both.
  4. Save the note.

The expiry may be typed as just the month, for example 10/2030, or just its digits 1030. Vende takes it as the end of that month.

By default one of the two is enough: the batch number or the expiry date. If your shop turns on Goods coming in must have a batch number and an expiry date in the batch rules, both must be filled in on purchases, goods receipts, stock adjustments in, opening stock (including the opening stock import) and production output. If something is missing, Vende names the product and what is not filled in on its line.

Automatic batch from production

For finished goods you do not need to type the batch number and expiry date. When you receive production output (Receive Goods on a production order and on the Production Board, or Transactions → Productions), both fill in by themselves:

  • The Batch number comes from the production date as year, month, day. Production on 5 November 2026 becomes 261105. If the product already has a batch with that number, the next one gets the ending -2, -3 and so on.
  • The Expiry is the production date plus the product's Shelf life. Six months from 5 November 2026 is 5 May 2027. One month from 31 January is 28 February (the end of the month, never March). A product without a shelf life is left without a date.

Both are only a starting value and can be changed before saving. If you leave them empty, Vende uses the same starting values. Changing the production date in Receive Goods refreshes the batch number too, unless you typed the number yourself.

Fill in the shelf life on the product page, in the Tracking section, once Track batches & expiry and the Production feature are on: type the number, then pick the unit Days, Months or Years. The AI assistant can fill it in too when it edits a product.

Batches are not made by hand in the batch list. A batch is recorded automatically from the document the goods came in with.

Batch production record (PDF)

For a batch made by production, Vende prepares the Batch Production Record (CPOB) as an A4 PDF: the product, batch number, production and expiry dates, the goods received, the materials taken out of stock with their own batch numbers, the stages of the production order with who did them and when (subcontracting included), the QC results, the yield (output against plan), and three signature boxes: Production, QC and Responsible person.

  • From a batch: Master Data → Batches, the Print menu on the batch's row, Print Batch Record.
  • From a production order: the Print menu on its row or on its page. An order that made several batches prints one record per batch.

The menu is not shown for a batch that production did not make (bought or adjusted in) nor for an order that has not received goods with a batch. Every print is written on the batch's or the order's history. A batch without a QC check gets empty lines in the QC part to fill in by hand. A material that is not batch-tracked is written without a number, and a stage without recorded work is marked as not recorded.

When selling

A sale automatically takes the batch that expires first.

While Production QC is on, a batch rejected by a QC check is passed over and cannot be sold. A raw material batch can also be held in quarantine from the moment it comes in on a purchase until QC passes it. See Production QC per batch.

For a stock adjustment out, a stock transfer and a return to the supplier, you can choose the batch in the line details. When none is chosen, the batch that expires first is used.

Returning batch-tracked goods from a sale

When a customer returns batch-tracked goods on a note (Invoice Mode picks or types the batch on the return line; the till takes it from the original note or from the batch saved on the note) or when the goods of a later return are received, the batch that comes back follows the Batch on sales returns choice in the batch rules:

  • May be empty: the batch may be left out. The goods come back without a batch.
  • Required: the batch must be filled in. A batch number not recorded yet is recorded as a new batch, which suits stock left from before Vende.
  • Strict: only a batch that was sold to that customer, and no more than they received minus what they already returned. The data is the same as Customers that received it in Batch Tracing. A buyer without a name counts as one customer, Walk-in customer.

If the return line names its original note and its goods once left from a single batch, that batch fills in by itself. If they left from several batches, Vende asks you to pick one on the return line. A refusal names the batch, the customer and the quantity that may be returned, with the way out.

A draft note is not checked against this rule yet; the check runs when the note is posted.

Setting the batch rules

Open Settings → Batch. There are two choices:

  1. Batch on sales returns: May be empty, Required or Strict (see the previous section).
  2. Goods coming in must have a batch number and an expiry date: turn it on when every batch-tracked item that comes in must have both.

A shop that already runs stays on May be empty with the incoming rule off, so nothing changes until you change it. A new shop with Invoice mode starts with Strict, one without it with May be empty (the till has no batch choice for a return line yet, so the batch is filled in on the return line of Invoice mode); for a pharmacy, toko obat and drug factory the incoming rule is on as well. Press Save changes after changing.

Seeing the stock left per batch

  • Master Data → Batches: every batch with its Batch number, Expiry, Stock left and the stock left Per warehouse. Filter by product, warehouse, stock or expiry.
  • The product page has a Batches section with the stock left of each batch per warehouse.
  • Reports → Stock can be broken down by batch.

Typed a batch number or an expiry date wrong? Press Edit on the row of that batch. The stock of a batch is not changed here, but through stock documents.

Tracing a batch for a recall

When a batch has a problem, open Reports → Batch Tracing and search the batch by its number. The report shows both directions:

  • Origin: how the batch came in (a purchase from which supplier, a production, or opening stock) and, for the result of a production, which batches of material went into it, with their suppliers. If a material is itself the result of a production, the trace goes on to the materials behind it.
  • Destinations: every sale, delivery, return, transfer, outgoing adjustment and use as a production material. When the batch was used to make another batch, the report goes on to the batch it made and the customers that received it (the Step column, up to 5 steps).

The Customers that received it part sums up each customer with their phone number, the quantity received, returned and still with them. A sale without a customer shows as Walk-in customer. The report only reads the stock records, follows the branch picked, and can be downloaded as a PDF or Excel. Open to the owner and the Warehouse Manager; holders of General Reports and Auditor can open it too.

Warning for goods about to expire

The bell gives a "Stock expiring soon" warning per warehouse, for batches that expire within a number of days or have already expired. The day limit is set under Settings → Alerts, in the About to Expire field.

Goods that have expired are best taken out through a stock adjustment with the Expired category.

Tip: Use the expiry filter under Master Data → Batches to find goods that are close to their date, then sell them first.

Supporting reading

Articles on the background and the arithmetic.

Still not answered?

Ask us directly. We help until it is clear.

Ask on WhatsApp