Datanovel know-how
How many suppliers do you have?
Vendor numbers, legal entities and supplier groups answer different questions.
Counting rows in a vendor file tells you how many records exist. It does not necessarily tell you how many businesses you buy from, or how much spend sits within a supplier group.
Separate the three views
Operational records support transactions in a particular system, company code, location or payment arrangement. Legal entities identify the businesses behind those records. Supplier groups connect distinct entities through evidenced relationships.
All three views can be useful. The problem arises when a record count is treated as a supplier count, or when separate businesses are collapsed into one identity merely because their names look similar.
Make the connections explicit
Link records to an entity using appropriate registration information, names, addresses and corroborating evidence. Retain the jurisdiction and identifier type. Then assess group relationships separately, with their source and effective date.
Illustrative example: three vendor numbers cover the ordering and payment arrangements of one legal entity. A fourth belongs to its sister company. That is four operational records, two legal entities and one evidenced group relationship. Each count serves a different management question.
Use the right count for the decision
Entity-level grouping helps avoid contacting the same business repeatedly during cleansing. Group-level reporting can reveal spend concentration and possible negotiating scope. Record-level reporting remains necessary for system operations and reconciliation.
Datanovel develops these relationships within the client environment and makes uncertain matches visible for review. The result supports more reliable supplier counts without losing the operational detail behind them.