Lots, serial numbers and expiry dates

Lots and serial numbers have a switch in Business settings, and expiry dates, on lots and on products you only count, have one switch of their own. Both stay off until you turn them on.


A lot is one delivery of a product kept apart under its own label: a roll of fabric, a carton, a batch. A serial number marks a single unit, such as a phone with its IMEI, and PointLit keeps each such unit as a lot of one. Expiry dates can be kept on lots, on serial units and on products you only count, while “Expiry dates” is switched on. This article uses PointLit's own words, lot and serial number. A business can rename them, and its screens, labels and receipts then use its own word.

Turning it on

The switch is on the Pro and Enterprise plans. On Starter and Counter it cannot be turned on, because those plans do not include lots. Turning it off later hides lots again and deletes nothing that was recorded, and while it is off a product kept in lots is sold and received like any product whose quantity is counted.

  1. Open Manage → Settings → Business.
  2. Under “Lots, serial numbers & expiry”, turn on “Lots & serial numbers” and press Save.
  3. The menu now shows Manage → Inventory → Lots, and the Stock dialog of a product offers lots and serial numbers.

Naming your lots and serial numbers

Under “What do you call a lot?”, pick one of the ready words, Lot, Roll, Carton or Batch, or choose Your own word and type it in English, one and many, and in Arabic, one and many, saying whether the Arabic word is masculine or feminine. A word has at most 30 characters and may not contain curly or angle brackets or the # sign. “What do you call a serial number?” works the same way, with Serial number or IMEI ready. How it reads shows three sentences in your word before you save, and from then on every screen, label and receipt of the business uses it.

Setting up a product

A new product starts as “Tracks quantity” unless the business chose otherwise under “Stock for new products” in Manage → Settings → Business: every product created from then on, on the New product page, from a spreadsheet or by the AI assistant, gets that tracking, and the products you already have keep theirs.

On Manage → Catalog → Products, choose the product and press Stock… to open its Stock dialog, which asks how the product keeps its stock:

  • “Tracks quantity”: one figure per branch, as for most products.
  • “Tracked in lots”: each delivery is received as lots, each with its own label, the quantity received and what is left.
  • “Tracked by serial number”: each unit is received and sold on its own, with its maker's serial number scanned at receiving and at the till.
  • “Does not track stock”: a fee or a service that is sold but never stocked.

Expiry, the order of lots, and lots the till must use

A product tracked in lots or by serial number has three more settings in the same dialog. “Expires”, FEFO and LEFO are offered only while “Expiry dates” is switched on, as described below.

  • “Expires”: every new lot of the product must have an expiry date, when it is received, when stock is put into lots and when it is produced. A product that only tracks quantity can tick it too, as described below.
  • “Stock Control Option”: the order in which the till offers the product's lots. FIFO, the default, offers the oldest lot first and LIFO the newest. While Expires is ticked, FEFO offers the soonest expiry first and LEFO the latest; LEFO sells the freshest stock first, so older stock can expire on the shelf. The option only sorts the list: the cashier still confirms the lot, and it does not change how cost is worked out. While “Expiry dates” is off, the lots of a product set to FEFO or LEFO are offered as FIFO, oldest first, and the product keeps its choice for when the switch is on again.
  • “Must sell from a lot”: the till will not sell the product without choosing its lot. To set this for every lot product at once, turn on “Every lot product must sell from a lot” in Business settings. A product tracked by serial number always needs its unit.

Stock you already have

Switching a product to lots or serial numbers keeps the stock it has, which starts as “not in any lot”. To put it into lots, open the product on Manage → Inventory → Lots and press Put into lots: each row becomes a new lot with its own label, and for a serial product each unit gets its serial number. A product that must sell from a lot cannot sell stock that is in no lot, so put it into lots first. A product with open lots cannot switch between lots and serial numbers until its lots are sold, written off or received from their transfers.

Receiving lots and serial numbers

Lots are optional for a product that need not sell from a lot: a line posted without them arrives as stock that is in no lot. For a product that must sell from a lot, the receipt cannot be posted until the whole line is in lots.

  1. On Manage → Purchasing → Goods receipts, add the line with its quantity as usual. A product kept in lots shows its lots under the line.
  2. Type “How many lots to add” and press Add lots, or press Add one lot, then fill each row: the quantity received, the expiry date while “Expiry dates” is on (required when the product expires), the supplier's reference, and a note if it helps.
  3. For a serial product, scan one serial number for every unit. The line shows how many are scanned out of its quantity, and a serial number typed twice, already in the business for that item, or equal to a product's barcode is refused. A serial number has at most 64 characters.
  4. Post the receipt. Each lot gets its own code: print the labels now, or later from Manage → Inventory → Lots.

Lots from a packing list

With Inbound shipments switched on, a product tracked in lots can arrive on a packing list lot by lot. Receiving it with “All arrived except…” keeps each lot that arrived as a lot of its own, with its own label, its “Supplier’s reference” from the packing list as its reference and, when the product records a second figure, its own figure per unit, such as kg per metre, so every sale from it later is costed from that lot. When the product has attributes set to “Filled per lot”, the packing list holds each lot’s value of each one, under the attribute’s own name, such as a shade, and the lot received keeps those values. Print the lot labels when the receipt is posted, or later from Manage → Inventory → Lots.

Expiry dates, and products you only count

Expiry dates have one switch of their own: under “Lots, serial numbers & expiry” in Business settings, turn on “Expiry dates”, on the Pro and Enterprise plans. It covers products kept in lots or by serial number and products you only count, and it does not need lots. A product that tracks quantity can then tick Expires, and its expiry date is typed on each goods receipt line and the receipt cannot be posted without it, so a delivery with two dates is two lines of the same product. A transfer line carries a date too; left empty, it sends the oldest date the sending branch holds. While the switch is off, no screen asks for a date or shows one, the till sells without the expiry question, and the Expiring soon report is not offered; a product keeps its Expires tick and its Stock Control Option, every lot keeps its date, and turning the switch on again shows them all as they were.

PointLit cannot know which pack was sold, so it estimates what is left of each date, assuming the oldest stock sells first. The Stock dialog shows “Next expiry (estimated)” for each branch, with any stock whose date is not known, and the Expiring soon report lists the estimate beside the exact dates of lots, with the stock whose date is not known on a line of its own, “No date”. A stock count corrects the quantity the estimate starts from. The till asks nothing for these products.

Selling from a lot at the till

Scan a lot's label and the till sells from that lot straight away. Tap the product, or scan its own barcode, and the till asks which lot. The list holds the open lots at this shop in the product's Stock Control Option order, each with what is left and, while “Expiry dates” is on, its expiry date: Expires soon when 30 days or fewer are left, and Expired once the date has passed. The first lot is already selected, so pressing Add from and the lot's code, or Enter, sells from it; pick another lot to change it. A product with add-ons asks for its lot too.

When the product need not sell from a lot, the list also offers “Sell with no lot”. When it must, that choice is gone, and an item with no open lot at this shop cannot be added until stock is received or put into lots.

While “Expiry dates” is on, choosing a lot that has expired asks whether to sell it anyway. Sell anyway adds it, and the audit log records that an expired lot was sold and by whom; Choose another lot goes back to the list. A lot counts as expired from the business day after its date, so a lot that expires today is sold without the question.

Selling by serial number

Scan the unit's serial number and the till adds that unit on a line of its own, with no quantity to change: two phones are two lines. Tap the product instead and the till asks which serial number, in the same order as lots. A serial number already in the sale is refused. The receipt, the invoice and the delivery note print the unit's serial number.

Sales made while the till was offline

A till that loses its connection keeps selling and sends its sales when the line returns, and PointLit never refuses them. If such a sale took an item that must sell from a lot without naming the lot, the sale stands, and Manage → Inventory → Lots lists it, newest first, under Sold without a lot at that branch. Count the item or check its lots to put the figures right.

Returns

When a refund takes back a line that was sold from a lot, it asks where the goods go back to: “A new lot (a new label)”, which is linked to the lot they were sold from, or back onto that same lot while it is still open at this shop. “Not in any lot” is offered only for a product that need not sell from a lot. A serial unit always goes back onto its own lot, which opens again at the shop that takes the refund; a serial line sold without its unit while the till was offline goes back as stock that is in no lot.

To find the sale of a unit, open Manage → Sales → Sales and use Find by serial number.

A lot's note, photos and values

Open a lot on Manage → Inventory → Lots to see its history and its details. Edit note and values… takes a note of up to 500 characters, such as where a roll has a flaw. Add a photo adds pictures of the lot itself, at most 10; a video cannot be added. When product attributes are on, an attribute can be set to “Filled per lot” in the product's attributes, and each lot then gets its own value when it is received, such as a shade; a value that changes the price must stay a variant. While “Expiry dates” is on, the expiry date can be added or changed at any time, even after the lot has sold some of its stock, and on a product that expires it cannot be removed.

Counting and transferring lots

A stock count takes lots one at a time: scan a lot's label, or a unit's serial number, to jump to its row and type what it holds. A lot you do not scan stays as it is, and so does the stock “Not in any lot” until you count it.

A transfer moves whole lots. Type how much of a lot to send, and that much is split off into a new lot with its own label when the transfer is sent. A serial unit travels whole and is never split.

Finding what expires soon

On Manage → Inventory → Lots, the Expiry filter shows the lots already expired, or those expiring within the number of days you choose, the expired ones included. Under Manage → Reports → Reports, the Expiring soon report lists the exact dates of lots and the estimates for products you only count, within 7 days unless you choose another number, with the value of what is left at its average cost for those allowed to see costs. A product you only count also has one “No date” line for its stock whose date is not known, after its dated lines, whatever the number of days. The Expiry filter and the report are there only while “Expiry dates” is on, and the report lists lots only while “Lots & serial numbers” is on too.

Questions and answers

Does the till choose the lot without asking?
No. It lists the lots in the product's Stock Control Option order and selects the first one, and the cashier confirms it or picks another. Scanning a lot's label or a unit's serial number sells from that lot or that unit directly.
Can an expired lot still be sold?
Yes, once the cashier confirms it. The sale goes through, and the audit log records the lot, its date and the cashier. While “Expiry dates” is off, the till shows no dates and asks nothing.
Which plans include lots and serial numbers?
Pro and Enterprise. The switch is off for every business until someone turns it on in Business settings, and it cannot be turned on on Starter or Counter. Expiry dates, for lots and for products you only count, are on the same two plans, under one switch of their own.
Can we call them rolls, cartons or IMEIs?
Yes. Choose a ready word for lots or for serial numbers, or type your own in English and Arabic. One word applies to the whole business.