Two numbers describe most inventory functions. The first is how often they run out, which is measured, discussed and acted upon. The second is how much cash is sitting in stock that will never sell at full value, which is discovered annually during a provision review.

Both are visible in the same data, and the second one is usually larger.

Movement History
Velocity
Slow Moving
Stockout Risk
Transfers
Demand Change
Replenishment

Movement History Is What Makes This Possible

The distinction that matters is between a balance and a movement history. A balance tells you what is there now. The item ledger records every transaction against an item, which is what allows you to ask how long that stock has been sitting.

That is the difference between reporting stock value and reporting stock age, and only the second one supports a provision discussion or a disposal decision.

Every movement: Receipts, issues, transfers and adjustments recorded with document type and date.
True ageing: How long the current quantity has been held, rather than an average.
Velocity: Consumption rate by item and location over comparable periods.
Seasonality: Whether apparent slowness is a genuine problem or a predictable annual pattern.
ChatFin connects to JD Edwards and your wider ERP stack as the AI layer on top

Faster data, earlier decisions

Stockout and slow-mover analysis in JD Edwards used to wait for a month-end extract. By then the reorder decision had already been made on instinct.

The more you can automate and speed up your data, the more time you have to analyze.

Dave Sackett, on the AgentCFO podcast

Reading movement history continuously moves that analysis ahead of the decision. The planner gets the time to act on it rather than explain it afterwards.

Slow Moving Stock, the Silent Cost

Slow moving inventory is uniquely easy to ignore because it generates no operational pressure. Nobody complains, no customer is affected, and the cost appears once a year as a provision that surprises everybody.

Reviewing it continuously changes the conversation from a year end write down into a series of small commercial decisions taken while the stock still has value.

No movement in period: Items with no issues over a defined window, valued and aged.
Cover far beyond demand: Quantities representing years of consumption at the current rate.
Obsolescence indicators: Superseded items, discontinued lines and stock tied to inactive customers.
Provision consequence: The likely financial effect, quantified before period end rather than during it.

Predicting Stockouts Properly

Static reorder points fail in two directions at once. They trigger too late for items whose demand has grown and hold unnecessary stock for items whose demand has fallen, and they are rarely revisited after the initial setup.

A better prediction uses actual recent consumption, actual supplier lead time rather than the quoted figure, and the reliability of that supplier. Because purchasing history sits in the same system, all three are available.

Recent consumption: Actual usage rate weighted toward recent periods rather than a long term average.
Real lead time: Order to receipt in practice for this supplier and item, not the quoted number.
Supplier reliability: Variance around that lead time, which is what should drive safety stock.
Committed demand: Open sales orders already consuming the available quantity.
ChatFin analytics agent producing sourced financial insight

Transfers, the Cheapest Available Fix

In any multi site business, a proportion of stockouts coexist with surplus stock of the same item at another branch. The fix costs a transfer rather than a purchase order and a lead time.

It goes unused because spotting it requires comparing availability across every branch for every item, continuously, which nobody does. It is a natural task for an agent and one of the fastest returns available.

Match shortage to surplus: Locations short of an item paired with locations holding excess.
Net benefit: Whether the transfer cost is justified by the shortage it resolves.
Do not create a new gap: Confirm the source location retains adequate cover after the move.
Draft the transfer: Assemble the transaction for approval rather than producing a suggestion nobody actions.

Detecting Demand Change Early

Most replenishment problems are detection problems. Demand changed, the parameters did not, and the consequence arrived weeks later as either a stockout or a pile of unwanted stock.

Watching consumption against its own recent pattern surfaces the change while it is still cheap to respond to, and distinguishes a genuine shift from ordinary noise.

Rate change: Consumption departing from its recent pattern beyond normal variation.
New concentration: Demand increasingly driven by one customer, which is a risk as well as an opportunity.
Substitution: One item declining as a related one grows, which is a product transition rather than a demand fall.
Parameters stale: Reorder points that no longer reflect actual consumption, flagged explicitly.

"Everybody reviews stockouts because customers complain. Nobody reviews the stock that has not moved in a year, because it complains to nobody."

Variance reporting with the drivers named

The Finance View of Inventory

Inventory is the working capital line finance has least visibility over, because it is reported as a value and managed as physical units in another department.

Reading movement data directly connects the two. Slow moving stock becomes a quantified provision exposure. Cover levels become a cash conversation. And cost drift on individual items becomes visible as the margin effect it is.

Cash in inventory: Value held by ageing band, so the trapped cash is visible.
Provision exposure: Quantified continuously rather than assessed once a year.
Cover cost: What the current holding policy is costing in working capital terms.
Cost drift: Item cost movement and its effect on margin, tied back to the ledger.

How ChatFin Runs It

ChatFin reads JD Edwards item ledger movement, item location availability, open orders and purchasing history together, so ageing, velocity, stockout risk and transfer opportunities are all derived from the same live position.

Findings arrive with the specific items and locations attached, and where the answer is a transfer or a replenishment the agent drafts the transaction for approval rather than leaving a suggestion in a report.

ChatFin as the finance system of intelligence

Look at Both Sides of the Inventory Problem

ChatFin identifies slow moving stock with its provision consequence, predicts stockouts from real consumption and actual supplier lead times, finds transfer opportunities across branches, and drafts the resulting transaction for approval.

Stockouts get attention because customers complain. The stock that has not moved since last year is usually the bigger number.

Book a Demo

Frequently Asked Questions

How does AI identify slow moving inventory in JD Edwards?

By reading the item ledger, which records every movement against an item rather than just the current balance. That is what makes genuine ageing possible: how long the current quantity has been held, not an average. Combined with consumption velocity and seasonality, it separates items that are dead from those with a predictable annual pattern, and quantifies the provision consequence before period end rather than during it.

Why are static reorder points inadequate for stockout prediction?

Because they fail in two directions at once and are rarely revisited after setup. They trigger too late for items whose demand has grown and hold unnecessary stock for items whose demand has fallen. A better prediction uses recent actual consumption, real order to receipt lead time for that supplier and item rather than the quoted figure, the variance around that lead time, and open sales orders already consuming availability.

What makes transfer opportunities worth automating?

They are the cheapest fix available and almost entirely unused. In any multi site business a proportion of stockouts coexist with surplus of the same item at another branch, resolvable by a transfer rather than a purchase order and a lead time. It goes unnoticed because spotting it means comparing availability across every branch for every item continuously, which is what a person will not do and an agent does cheaply.

Related Articles