How to prepare stock management in a software system

A stock system must explain where items are, their condition and which are already committed. Recording only a total quantity does not resolve reservations, returns or damaged products. This guide helps prepare rules and tests so the figures match operations.

By Lyntev. Updated on .
About 5 minutes to read.

From data to the next decisionChoose the question, define the calculation and act on the result.

Translation published on . Original Portuguese guide; source revision .

By the end, you can:

  • Distinguish quantities and statuses
  • Define replenishment with clear assumptions
  • Check physical stock against records

Define the item and unit before the quantity

Each item should have a stable reference and a description distinguishing it. Decide when colour, size or packaging represent separate variants. A barcode can help identify an item, but does not replace its definition. Confirm how supplier codes and internal codes are handled.

Choose the stock-control unit and permitted conversions. Buying a box and consuming individual units requires knowing how many units that box contains. In the fictional Oficina Horizonte example, filter F-10 is controlled by the unit and purchased in boxes of ten. Receiving three boxes adds thirty units, not three. The conversion should belong to the item and be tested.

Define the item and unit before the quantity
FieldFictional exampleDecision needed
ReferenceF-10Stable identifier
DescriptionReplacement filter, model ADistinguish variants
Stock-control unitUnitBasis for receipts and issues
Purchase packagingBox of 10 unitsConversion and multiple
LocationWarehouse A, shelf 2Where to count and pick

Separate physical, usable and available stock

Define every displayed quantity. Physical stock indicates what is at a location; some may be quarantined or damaged. Usable stock excludes what cannot be delivered. The quantity available for new requests also depends on reservations and the commitment rule used.

In a fictional scenario there are 100 physical units, of which 5 are quarantined and 20 reserved. If reservations apply only to usable units, 95 remain usable and 75 available for new requests. A purchase of 30 units expected next week does not increase today’s physical availability. It should appear separately with its date and status.

The system must make these assumptions visible. If the team subtracts a reservation already deducted in the availability indicator, it counts the same obligation twice. Write each indicator’s formula in the project dictionary.

Record movements with their source and reason

Receipts, issues, transfers, returns and adjustments have different meanings. Each movement should state item, quantity, unit, location, time and responsible person or source system. Link it to the operational document where one exists so you can explain why the balance changed.

A transfer between locations is neither a purchase nor a sale. A return may need inspection before rejoining usable stock. If the process requires batch or individual-unit tracking, define when that identification is collected and how its journey is followed. Do not enable fields without preparing the team to complete them at the right times.

Fictional return journey
  1. Receive

    Link the return to the original movement.

  2. Separate

    Place in an inspection location or status.

  3. Decide

    Approve reuse, repair or permanent removal.

  4. Record

    Apply the authorised movement and reason.

Prepare replenishment using lead time, demand and commitments

Before automating purchases, define how requirements are calculated. A simple approximation for the reorder point adds expected consumption during the supply lead time to a chosen allowance for uncertainty. Assumptions need review for seasonality, delays or limited information. The formula does not guarantee an absence of stockouts.

In a fictional example, consumption of 6 units per day, a lead time of 5 days and an allowance of 10 units produce a reorder point of 40 units. For this test, the position considered is 28 usable + 12 confirmed incoming − 8 committed = 32. Incoming items and commitments belong to the defined horizon and have not already been deducted from the 28.

If the policy proposes replenishing up to 70, another 38 units are needed. With boxes of ten, the proposal would be 40 units and the position would become 72. Odoo documentation shows minimum, maximum and multiple rules; confirm the definition used in your system. Start with suggestions reviewed by a person before authorising automatic orders.

Compare records with physical quantities

Define a counting routine by item, location or risk group. Odoo documentation presents cycle counts by location, an operational alternative to waiting solely for a full count. Frequency should reflect movement, value and your business’s history of discrepancies.

During counting, control movements or record a point in time enabling reconciliation. If someone removes five units while another person counts, the difference may be timing rather than loss. Request review where the discrepancy warrants it. A balance adjustment should retain the previous quantity, new quantity, reason and necessary approval.

Test operations most likely to change the balance

Use a small set of fictional items and run a complete cycle: receipt, reservation, partial delivery, return and count. Confirm the balance after each step and that its explanation can be consulted. A partial sale should not automatically consume the full quantity unless that is the rule.

Also test concurrency: two people try to reserve the last units. The system must apply the agreed policy without allowing a silently incompatible commitment. Define whether negative stock is accepted, in which circumstances and who can authorise it. A negative balance may be a deliberate operational exception or an error; do not hide it without investigation.

Test operations most likely to change the balance
Common errorPreventive test
Confusing boxes with unitsReceive two boxes and check the conversion.
Adding future purchases to current availabilityCompare incoming dates and statuses.
Deducting the same reservation twiceReconstruct the indicator’s formula.
Returning directly to usable stockTest the inspection journey.
Adjusting without explaining the differenceRequire a reason and check recent movements.

Document the rules the team will follow

Choose the first items and locations for a pilot, train the people receiving and issuing material, and monitor discrepancies. Confidence in stock comes from combining rules, timely recording and checks. Software should make that work easier and show exceptions requiring a decision.

Worksheet for your project

Stock management worksheet
Items, variants and identifiers:
Stock-control unit and conversions:
Locations and usage statuses:
Definitions of physical, usable, reserved and available:
Movements and source documents:
Handling partial deliveries and returns:
Batch or individual-unit rules, if needed:
Replenishment lead time, demand and assumed allowance:
Position formula and horizon considered:
Minimums, targets, multiples and purchase approval:
Counts, movement control and adjustments:
Pilot tests, discrepancies and responsible people:

Sources and criteria

Content prepared with AI assistance and research using technical sources, with checks of the relevant examples and calculations. The references support the guide’s decisions; examples identified as fictitious let you try out the method.

Wellinton Oliveira

Written by

CEO of Lyntev

Technology with context, original analysis and sources you can consult.