Stock Lots

The Stock -> Stock lots section contains 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, usually created automatically, and used for providing the FIFO method for consuming goods, and also for some other functionality, like, for example, expiry date.

In your daily business, usually, you should not operate with these automatically created stock lots.

The Stock -> Stock lots page allows

  • viewing, sorting, and filtering,
  • editing and viewing stock lot details,
  • accessing reports,
  • looking up the history of a stock lot,
  • manually adding goods to stock by creating a stock lot manually (not recommended),
  • moving items between internal storage locations,
  • 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. What are the stock lot statuses?
  5. How to move items between internal storage locations?
  6. How to transfer items to another warehouse?
  7. How to perform quality control?
  8. How to track serial numbers?
  9. How to print a stock lot label?

Tips and tricks

  • Click Choose columns to choose which columns to display.
  • Drag the columns to rearrange them.
  • Click Saved searches to save a search or use a saved search.
  • 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 them, search by lot number or filter by "0" total quantity.

What is a stock lot?

The stock lot keeps the detailed history of each item that is processed in your company.

For example, each time you purchase a material, a new stock lot 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 attached, or notes, etc.

Stock lots and batch tracking

Stock lot functionality can be used for batch tracking, as technically it provides the traceability.

However, a stock lot is not always equivalent to a (manufacturing) batch number. For example, it may be that you receive goods from the same batch of products from your vendor in two deliveries - in this case, there will be two stock lots, created by the system.

When you wish to track some batch number, which is not equivalent to the stock lot number, you can act as follows:

  1. it is possible to encode the batch number in the stock lot number, e.g. by adding it as a suffix.
  2. it is possible to use a custom field to keep your batch number.

How does a stock lot work in MRPeasy?

MRPeasy inventory management is designed for lot/batch 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 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 created for it.
  • Each production run produces a new stock lot of products.
  • During production planning, MRPeasy automatically proposes which lot to pick materials from (FIFO or FEFO principle). The materials will be booked.
  • No product or material can be overbooked, MRPeasy manages bookings.
  • 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, specific stock lots from where products are booked 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 are recorded in stock lots.
  • The actual cost of each lot of products is known (from direct materials cost, manufacturing and labor cost).
  • If an item is subject to Quality Control then the stock lot will be quarantined until inspected and approved, or rejected, fully or partly. 
  • Service/repair orders can be scheduled for items that 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.
  • To keep a lot number the same after transfer to another stock/production site, use a persistent custom field.

Packaged items

When the Enterprise function Packing is turned On, a column „Packaged“ can be added to the stock list view. This column shows how many items of those in this lot are packaged.

Stock lot statuses

Requested – required items are requested from:

  • The purchasing manager, if the item is procured. A purchase order in status New is created. Goods are requested to be ordered from the vendor.
  • The production manager, if the item is manufactured. A manufacturing order is created.
    If the Enterprise function Approval System is enabled, the order must be approved.
    If the Professional function Unscheduled Manufacturing Orders is enabled, the order must be scheduled.

Requested items cannot be consumed in manufacturing orders or picked in shipments and transfer orders.

Planned – items are expected to arrive in some future. Purchase orders are ordered. Manufacturing orders are scheduled or started.

The software setting Use planned goods controls whether planned items can be consumed in manufacturing orders and picked in shipments and transfer orders, or not.

On hold – if the Professional function Quality Control is enabled, this stock lot waits for inspection.

Received – items are received. If the Professional function Quality Control is enabled, this stock lot passed quality control.

Rejected – if the Professional function Quality Control is enabled, this lot is received, but did not pass the quality control.

Canceled – the stock lot is deleted.

RMA waiting for inspection – RMA order is created, the item is received and waiting for inspection. RMA statuses are available when the Enterprise function Return Merchandise Authorization (RMA) is enabled.

RMA waiting for repair – item is inspected and should be repaired.

RMA ready for shipment – item is repaired and can be shipped back to the customer.

RMA returned – item is returned by the customer. It can be added to the inventory.

We use cookies to enhance your experience on our website. If you continue using this website, we assume that you agree with these. Agree Learn more Ok