Book a free consultation (opens in a new tab)

Inventory Module

ERP Inventory Management Module Services

What to buy, what you can promise a customer, what your margin actually was. All of it comes off the stock position.

  • 98%+Stock record accuracy target
  • 20 / 80A class items to stock value
  • 12xA class cycle counts a year

Why It Matters

Accuracy is the whole game, and it is not a software feature

Record the movement when it happens, or do not bother

Almost every accuracy problem traces back to the same thing: material moved and the transaction was entered later, or by somebody else, or not at all. Stock issued against a verbal request on a Friday afternoon. A receipt booked on Monday for goods that went straight to the line.

  • No movement without a document, and no document without a moment
  • Adjustment rights restricted and every adjustment given a reason code
  • Shrinkage, damage and count correction reported separately, not lumped together

Most stock arguments are two people reading two numbers

On hand is what is physically in the building. Allocated is the part of it already committed to open orders and work orders. Free is what is left, and it is the only number anyone should quote to a customer.

  • Available to promise uses free stock plus confirmed incoming, with dates
  • Allocation happens at order confirmation, not at picking, so the commitment is visible
  • Goods in transit held in its own state rather than counted at either end

The stock movement lifecycle, from receipt to adjustment

  1. Receipt

    Goods arrive against a purchase or transfer document, quantity and batch or serial captured, and a cost attached so the value posts at the same moment as the quantity.

  2. Put into stock

    The quantity lands at a location and becomes part of the on hand position. The stock ledger takes a line and the control account moves by the same value.

  3. Allocation

    A sales order or work order reserves part of the balance. On hand does not change, free stock falls, and available to promise reflects it immediately.

  4. Issue or despatch

    Stock leaves against the order it was reserved for. Quantity and value come out together at the costing method you chose, and the batch or serial record follows the customer.

  5. Count and adjust

    A cycle count compares record to shelf. Any difference is posted as an adjustment with a reason code, so the pattern can be investigated rather than quietly written off.

What we set up when we build this module

  • Item master and UoM design

    A coding scheme, attribute and variant structure, purchase to stock to sales unit conversions, and a de-duplicated master loaded and reconciled.

  • Traceability configuration

    Batch, lot or serial per item group, expiry and shelf life rules, FEFO picking order and a forward and backward trace report you can run in a recall.

  • Valuation and GL mapping

    Costing method chosen per item group with the margin effect written down, stock accounts mapped, and variance accounts set up if you go standard cost.

  • Stock ledger reconciliation

    A monthly routine that ties the stock ledger to the control account, with the common causes of divergence closed off at source rather than journalled away.

  • Cycle count programme

    ABC classification from your own value and movement data, a count calendar per class, count sheets, tolerance rules and an accuracy measure that gets reported.

  • Reorder and adjustment controls

    Reorder point and min max rules per item and location, plus a reason code list for adjustments, write-offs and shrinkage with approval limits behind it.

Why teams bring us in to set up inventory

  • We start with the item master

    Codes, units and variants get designed and de-duplicated before anything is configured, because every other decision in the module inherits that structure.

  • Valuation is agreed with finance

    The costing method is chosen jointly with your controller, with the margin effect and the period end workload spelled out before it is switched on.

  • Traceability decided at design time

    We ask the recall question at the start, not in year three: batch and serial identity cannot be applied backwards to existing stock.

  • We are blunt about discipline

    No configuration produces accurate stock on its own. We will tell you which of your habits has to change, and we will say it before you sign rather than after.

  • Reconciliation built in, not bolted on

    The stock ledger to control account routine is set up and run with your finance team during the project, so the first month end is a check.

  • Platform neutral

    We deliver on ERPNext, Odoo and SAP. Each handles valuation and traceability differently, and we will tell you where the one you already own will fight you.

Inventory module questions

Which stock valuation method should we choose?

For most distributors and general manufacturers, weighted average is the sensible default. It is simple to explain, it smooths price movement, and it needs almost no ongoing maintenance. Choose FIFO when you hold dated or perishable stock and want reported cost to follow the physical flow, or when your auditor or tax regime expects it. Choose standard cost only if you genuinely want variance analysis, because standard cost commits you to setting standards, posting purchase price and usage variances every period, and revaluing when the standard is reset.

How do we actually get stock accuracy up?

By recording every movement at the moment it happens, and by removing the ways people can move stock without recording it. The software will not fix accuracy on its own. Lock down who can post an adjustment, require a reason code on every one, stop issuing material against a verbal request, and put a cycle count programme in place so errors surface in days instead of at year end. Well run operations hold stock record accuracy above 98 percent at item and location level. Getting there is a process and discipline problem that the system can support but cannot solve for you.

Do we need batch and serial tracking, and can we add it later?

You need it if you are in food, pharmaceuticals, chemicals, medical devices, automotive or anything with a shelf life or a recall obligation. Serial suits high value discrete units, batch or lot suits anything produced or bought in runs. The honest point is that traceability has to be designed in at the start, because it cannot be retrofitted onto history. If you switch it on in year three, everything already in stock and every movement before that date has no batch identity, so a recall still turns into a manual reconstruction.

Can cycle counting replace the annual stocktake?

Operationally, yes, and it should. Counting a subset of items continuously, weighted by value and movement using ABC classification, finds and corrects errors far faster than shutting the business for two days once a year. A class items might be counted monthly, B class quarterly, C class once or twice a year, so every item is covered and the high value lines are checked often. Whether it replaces the statutory count is a question for your auditor.

Why does the stock ledger not agree with the general ledger?

Almost always because a movement was posted outside the process. The usual suspects are manual journals written straight to the stock control account, receipts entered without a costed purchase document, adjustments posted to the wrong account, goods in transit sitting in neither location, and backdated entries made after a period was reported.

How does the module handle the same item across several locations?

One item code, one set of item attributes, and a separate stock balance and valuation per location, so you can see the group position and the site position from the same record. Transfers between sites are a document, not an edit. When stock leaves site A it moves into a goods in transit state that belongs to neither site, and it only lands at site B when someone receives it. That state matters, because without it stock vanishes for the days it is on a truck, and the receiving site orders more of something it already owns.

Related

The other services in this section, and related pages from TCB Infotech.

Get Your Stock Figure Right

No commitment. A practical review of your stock data and your movement process, whichever ERP you run.