Missing important data
i
- How
- Records with something missing, grouped by what the absence costs rather than by how untidy it looks.
- Where from
- The nightly store and the daily sales series.
- Split
- CRITICAL blocks something — a number that cannot exist. IMPORTANT is a gap to close that nothing stops on. Split by consequence, not by taste.
- How many
- 2 gap(s) exist at this severity, counted over the whole store and capped by nothing. This response carries 2 of them: each flag returns at most 100 rows, so the LIST is a page of the problem while the COUNT is its size. The rows are the deliverable; ask for a longer list to act on more of them.
- Caution
- Erply reports credit limit 2,147,483,647 (INT_MAX) for accounts meant to be unlimited. A limit is a sentinel as often as a policy and must never be summed.
Gaps in the records, and what each one stops you doing.
What these gaps are doing to the numbers beside them
| Figure | This flag makes it | Why |
|---|---|---|
| Any total or average of credit limits | overstated | One account at 2,147,483,647 outweighs every real limit in the file together, so a sum or an average of limits is that account and nothing else. Nothing here sums them, and this flag is why. |
| The headroom those accounts appear to have | overstated | Erply computes available credit as limit minus balance, so a sentinel limit reads as unlimited headroom. It means 'no limit was set', not 'this customer was trusted with two billion dollars'. |
| What is owed | not affected | A receivable is the customer's account balance and never their limit, so Collections' figures are untouched by this. |
| Matching a product to a vendor catalogue | cannot be computed at all | With no code there is nothing to match on. It is one half of the gap that stops a 'never received from a purchase order' flag existing at all: 3,691 CareCraft lines do not join to Erply products and the one documented code rule explains 8% of them (dashboard 13). |
| Every figure on this page | not affected | A missing code costs a person the ability to look a product up; it moves no number. That is what makes this flag important rather than critical — nothing here is wrong, something here cannot be done. |
2
2 of them fetched, 2 on this page. The count is over the whole store; the list is capped per flag. 1 of the rows carries an id of 0, which is the absence of a record rather than one of them, so which product or customer the gap is on is not established for those.
| Gap | What | Detail | What it costs |
|---|---|---|---|
| credit limit is a sentinel | DPM Internet Archived | INT_MAX (2,147,483,647) — unlimited | not a policy: it must never be summed or compared |
| no product code | Which product — not established the record reads “psfp-157” | cannot be matched to a vendor catalogue by code |
Export — 2 row(s)
Download CSV — 2 row(s), the rows this panel fetched — at most 100 per flag, which is a cap and not the size of the problem. The panel's headline count is the uncapped total; this file holds what the tool returned. The link asks the tool again, so a panel read live from Erply can have moved since this page was drawn; the box below is this page's own rows.
This page carries no JavaScript by decision, so the last two keystrokes are yours: click in the box, select all (Ctrl/Cmd-A), copy (Ctrl/Cmd-C). It is TAB separated, so it pastes into a spreadsheet as columns rather than as a paragraph.