Top Materials Ordered ranks the materials you order most. It’s the buying-negotiation and
stock-holding report.
Figure 1 — Materials Ordered, ranked by value. Top N is how many rows you get back — 10 is the usual setting; raise it when you’re planning a bulk buy.
Parameter
Notes
Date From / Date To The period
Top N How many to return — 10 for a headline, higher to see the tail
Column
Meaning
Material The material
Type / Colour / Product Group How it’s classified
Qty How much was ordered
Value What it cost
Orders How many separate orders it appeared on
High Qty, low Value — a cheap staple. Worth holding stock and negotiating on volume.Low Qty, high Value — expensive and occasional. Order as needed; don’t tie up cash.High Orders count — ordered constantly in small amounts. The best candidate for a standing
arrangement, and the most annoying to keep running out of. Run it for the same quarter across two years to see what’s growing before you commit to stock.
Question
Answer
A material I order often is missing
Raise Top N — it’s below the cut-off.
Value looks low
It’s cost, not sale value. Use Products Analysis for what you sold it for.
