The Stock -> Inventory section contains an overview of all items inventory levels in stock and allows to update the inventory levels after a stocktake.

The Stock -> Inventory page allows

  • entering/updating current inventory levels/quantities (for the current date only),
  • seeing the inventory levels of each item on any historical date,
  • uploading a CSV file with new inventory levels and costs,
  • seeing the number of items that were consumed in unfinished production (WIP) on any historical date.

Jump to:

  1. Demo video: Setting up inventory levels.
  2. Enter initial inventory values.
  3. Adjust inventory levels.
  4. Tips, tricks, and warnings.
  5. Check historical inventory levels.
  6. Distorted or negative numbers in the stock history.
  7. WIP (Work in Progress) values meaning.

Tips, tricks, and warnings

  • Use this function with caution. Changing inventory values at Stock -> Inventory can terminate existing bookings and, as an extension, break stock history.
  • Back up your database before entering new quantities.
  • If inventory count values differ, reasons need to be investigated carefully.
  • It is not possible to change historical inventory levels. Only the inventory levels of the current date can be updated.

Historical inventory information

For any historical date, at Stock -> Inventory, it is possible to see:

  • the total "In stock" quantity of every item,
  • the quantity which had been consumed in unfinished production,
  • the inventory value.

NB! It is not possible to change historical inventory levels. Only the inventory levels of the current date can be updated.

Distorted or negative historical inventory numbers

If some planned item is counted off stock before it was received, this will distort historical inventory levels, as negative adjustments are before positive adjustments. Even a negative number may appear in the inventory history.

The software works as follows:

  1. If the software setting "Use planned goods = Yes" is used, then it is possible to consume (ship, write off, etc.) an item before its receipt has been reported into stock.
  2. When a planned item is consumed, the transaction is saved, but it is hidden from the stock history.
    - This means, that when looking at today, you will never see negative numbers.
  3. When the planned item is finally received, then all its transactions are written into stock history.
    - This means that if the receipt date is after the consumption date, then numbers are distorted in the lapse between those two dates.

Example, how an inventory report may be distorted if item receipt or consumption dates are incorrect:

Date  Event Inventory change  Running total (A) Actual running total (B) Difference (A-B)
Jan 1 Starting balance +5 5 5 0
Jan 1 PO is created, item is ordered. 0 5 5 0
Jan 10 PO is received, but the receipt is not reported. 0 5 15 -10
Jan 20 Items are consumed in manufacturing.
*Note that this line is considered in stock history only once the PO is marked as received.
-5* 0*
10 -10
Jan 25 Items are consumed in manufacturing.
*Note that this line is considered in stock history only once the PO is marked as received.
-5* -5* 5 -10
Feb 1 PO is marked as received with the current date. +10 5 5 0

To prevent this situation:

  1. Enter data in real-time: PO receipt, parts consumption in MOs, shipments to customers, etc.
  2. Report PO receipt with the correct date, when reporting receipt later, it is possible to backdate the arrival date.
  3. Consider that it is not possible to backdate parts consumption or shipments.
  4. When using "Finish production as planned", before using it, make sure that MO start and finish dates correspond to actual dates.
    - Materials will be consumed according to "Start date" if it is in the past.
    - Finished products will be counted to stock according to "Finish date" if it is in the past.
  5. Use the software setting "Use planned goods = No".

Inventory cycle count, updating inventory values after a stocktake

Jump to:

Where to adjust inventory levels

When making a physical inventory count, stock levels for items can be adjusted:

  • At Stock -> Inventory to have MRPeasy automatically create stock lots or write-offs.
  • At Stock -> Stock lots by creating new stock lots to add new items.
  • at Stock -> Write-offs by writing off extra items.

Generally, the Stock -> Stock lots and Stock -> Write-offs should be preferred when inventory values differ because these allow manually setting all the variables, choosing the stock lots, entering comments, or using special write-off codes. The Stock -> Inventory page creates stock lots and write-offs automatically.

Updating inventory levels at Stock -> Inventory

For updating the stock levels:

  1. Choose the current date.
  2. Choose the Site, if you have several warehouses.
  3. Choose the Location, if you wish to update inventory levels only in a particular location, e.g. shelf.
    Or choose the By location value to see and update each storage location separately.
    By default, the software shows locations where an item exists or existed before. If you want to see all possible locations, find the item by the part number or description.
  4. Enter the new total quantity.
  5. Click Save or Save all.

If the new quantity for an item is greater than the previous quantity:

  • A new stock lot is created.
  • The new stock lot will have the same cost per unit as the latest stock lot of the same item.
  • If this item has not been in stock previously, the vendor's price will be used. If the item has several purchase terms, the price with the highest priority will be used.
  • If the item has neither previous stock lots nor purchase terms, the software will ask to enter the cost manually.

If the new quantity for an item is smaller than the previous quantity:

  • A new write-off is created from existing stock lots in status Received, by FIFO (FEFO, if expiry dates are used).
  • First, the software tries to write off items that are available, not reserved.
  • If more items should be written off than is available at the stock, then software tries to cancel bookings by LIFO until it is possible to create a write-off.

Updating a stock lot quantity

If you have labeled your physical products with stock lot numbers, and the quantities do not match in stock and in the software, this can mean one of the following:

  1. Some actions are not yet reported in the software (materials are used in manufacturing, but not yet reported consumed).
  2. Stock lot's source document is incorrect (e.g. PO or MO quantity is wrong).
  3. Consumption actions are reported incorrectly (e.g. materials in MO are consumed in the wrong quantity or from the wrong lot).

To correct a stock lot quantity, there are two options:

  1. Find the root cause, and correct the wrong document in the software (e.g. correct a wrong consumption in an MO).
  2. Make an adjustment:
    - for a negative adjustment, create a write-off.
    - for a positive adjustment, create a new manual stock lot. Number it accordingly (e.g. take the original lot number and add a suffix) and re-label the physical item.

Work in progress: WIP cost and WIP quantity

The "WIP Quantity" and "WIP cost" numbers are not included in the inventory balance.

  • The column WIP quantity shows the number of raw materials that have been consumed for manufacturing orders, which are still in progress.
  • The column WIP cost shows the cost of materials in work in progress.
  • At the moment when materials are marked as consumed in production, they are moved from inventory to Work in Progress (WIP). When the Manufacturing Order is finished, the WIP is cleared (the value is counted in the cost of the finished products).

Entering initial inventory levels into MRPeasy

There are several ways of entering initial inventory levels:

  • At Stock -> Items -> Import from CSV. Together with the initial article creation upload, it's possible to include the quantities and net costs.
    From there it not possible to upload inventory at particular locations or sites.
    Read: How to import articles?;
  • Stock -> Inventory (-> Import from CSV). It is possible to update or initiate inventory levels. It's also possible to upload a CSV file - it's possible to import both quantities and costs, at several sites and locations. 
    Read: How to import inventory levels?;
  • Stock -> Stock Lots -> Add a stock lot or Import from CSV. It is possible to manually create stock lots (batches). Caution: use this in case of critical need only.
  • Procurement -> Purchase orders -> Add new Purchase Order. Fill out a PO and mark its arrival date to mark it received.
  • Last but not least - here is demo-video: /demo-videos/entering-parts-and-products/
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