User Manual

Stock Lots

The Stock -> Stock lots section contains shows a list of all stock lots that are either currently in stock or scheduled to arrive, plus the history of all stock lots in the system.

General advice about stock lots:

It is an internal business object in the MRPeasy software, used for providing FIFO method of using goods, and also for specific functionality, like expiry date.

In your daily business, you should not operate with stock lots.

The Stock -> Stock lots page allows

  • viewing, sorting, and filtering of the stock lots,
  • editing viewing stock lots,
  • accessing reports of stock lots,
  • looking up the history of a stock lot,
  • manually adding items to stock,
  • moving items between internal storage locations (shelves),
  • printing lot labels.

Jump to:

  1. Tips and tricks.
  2. What is a stock lot?
  3. How does stock lot tracking work in MRPeasy?
  4. How to move items between internal storage locations?
  5. How to transfer items to another warehouse?
  6. How to perform quality control?
  7. How to track serial numbers?
  8. How to print a stock lot label?

Tips and tricks

  • Click Create to create a new Stock Lot for manually adding items into inventory.
  • Click Choose columns to choose which columns to display.
  • Drag the columns to rearrange them.
  • Click Reports for seeing the stock lot's reports.
  • The Source column shows where this stock lot originated from.
  • The table can be searched and filtered (see Usage tips for wildcards).
  • Depleted stock lots are not shown by default. For finding these, search by lot number or filter by "0" total quantity.

What is a stock lot?

Generally, one stock lot is one batch of some item. They let you record the detailed history of each item that is processed in your company.

For example, each time you purchase a material, you will receive a new batch, therefore a new stock lot number (aka “a batch number”) is created to identify it.

You may have many stock lots of the same item - purchased at different times, with different costs, possibly from different vendors, with different expiry dates, stored in different locations/shelves, some of which have certificates, files or notes attached, etc.

How does a lot/batch tracking work in MRPeasy?

MRPeasy inventory management is designed for batch inventory and serial number traceability. Lot tracking helps to ensure that the history of every product and material is known. Technically this means the following:

  • Each batch (a stock lot) of an item is tracked and identified separately. Unique lot numbers are automatically generated.
  • Every time a material is purchased, a unique lot number is recorded for it.
  • Each production run produces a new lot (batch) of products.
  • During production planning, MRPeasy automatically proposes which lots to pick materials from (FIFO or FEFO principle). The materials will be reserved.
  • No product or material can be overbooked, MRPeasy manages the reservations.
  • During production, workers see which materials they need to pick - the lot numbers, quantities, and location(s) - and can report materials they've used. (Section "My production plan")
  • For each sale, the specific stock lots from where products are reserved and will be given out are recorded.
  • Defects in products can be traced back to specific production operations or material purchases in seconds. For a defective batch of materials, it is easy to identify all products which are affected.
  • Expiry dates can be recorded in stock lots.
  • The actual cost of each batch of products is known (from direct materials cost, manufacturing, and labor cost).
  • If an item is subject to Quality Control then the stock lots will be quarantined until inspected and approved.
  • Service/repair orders can be scheduled for items which failed quality control or were returned by the customer.
  • Individual serial numbers can be tracked within stock lots.
  • Notes and files, e.g. certificates, can be attached to individual stock lots.