Skip to content
P4 Software P4 Software / logisticaHQ-en

Add these docs to Claude

Ask Claude questions about these docs. Claude reads the published pages and links you back to them. Copy this address:

https://p4-software.opendocs.page/mcp

In claude.ai or Claude Desktop: open Settings, then Connectors, choose Add custom connector and paste the address.

In Claude Code, run:

claude mcp add --transport http docs https://p4-software.opendocs.page/mcp

Order matrix

Order Matrix
Fulfillment › Order Matrix

The Order Matrix is a self-service pivot of your open orders. You choose what goes down the side (the rows) and what goes across the top (the columns), and every cell shows how many orders, lines and units sit at that crossing. A header above the matrix summarizes all open orders at a glance.

A number is a count of open packslips, and clicking it opens something you can act on. A plain click on a number in the matrix opens a side panel with that cell's figures; from the panel, Open the Pick tickets opens the Pick tickets list filtered to exactly the orders behind the number. The totals (row, column and grand) are links to the Pick tickets list.

1. What the Order Matrix is, and what counts as an open order

  • An open order is any packslip (pick ticket) whose state is not Closed. Draft, Unallocated, Held short, Pending letdown, Ready to pick, Waved, Being picked, Rating, Shipped and every other state except Closed are all counted. A shipped order that has not been closed yet is still open.
  • You only see your own scope. If you are signed in as a user of one client (a 3PL's customer), the matrix, the header and the exports cover that client only. Office Users with access to every client see all of them.
  • Each cell shows orders (lines/units). Orders is the number of distinct packslips, lines the sum of their line counts and units the sum of their quantities. For example 107 (119/323) is 107 orders holding 119 lines and 323 units.
  • Rows and columns that hold no orders at all are called blanks; see Hide blanks below.
  • If your Setup would produce more than 500 rows or columns, the server refuses it with a message ("Too many values"). See Troubleshooting.

2. The header: four cards about all open orders

The header always describes all open orders. It ignores the matrix's own rows, columns and filters, so it does not change when you change the Setup below it. As soon as at least one filter has been applied (a filter counts once you press Reload, not while you are still typing it), a short line above the header says so: "All open orders: the filters below do not apply here." The attention rows (name, hint, count and bar) are all clickable and open the Pick tickets list on that state. It is refreshed when the page opens and every time you press Reload. If a card cannot be built (for example your Tenant lacks a dimension it needs, or its request failed), that card is simply left out, without an error message; if no card can be built, the whole header is hidden.

Open orders by state

Element What it shows How it is computed
Doughnut One slice per state, with the total number of open orders in the centre. Orders are summed per state. The six biggest states each get a slice; every smaller state is grouped into one slice named after the largest state inside it, for example Waved · other (a group with a single state just shows that state).
Legend Each slice's name and count (maximum seven rows). The same figures as the doughnut, written out so they line up and can be read by a screen reader.
Caption 13,344 lines · 87,134 units · 129 Customers · 13 Clients Lines and units are totals over all open orders. Clients is the number of Clients with open orders. Customers is the number of distinct Customers; if that figure cannot be obtained, the caption simply leaves "Customers" out.

Needs attention

  • The big number is the count of orders in exactly three states: Unallocated, Pending letdown and Held short. These are the orders that cannot move on their own: they wait for stock to be assigned, for a replenishment, or for stock that is not enough. The percentage next to it is that count's share of all open orders.
  • Three bars show the split: Unallocated ("waiting for stock to be assigned"), Pending letdown ("replenishment first") and Held short ("not enough stock"). The bar width is each state's share of the attention total. A state with no orders is not shown; if there are none at all, the whole card is hidden.
  • Each bar opens the Pick tickets list on that state. Click a bar, or tab to the (visually hidden until focused) link list under the card and press Enter.
  • Note: this uses these three states only. It deliberately does not use the wider "not allocated" list the server uses elsewhere.

Still to ship, by client

  • The big number is total orders minus the orders that already left, over all Clients. "Already left" means the states Shipped, Pending Delivery count and Pending Delivery signature: those are still open on the server, but the goods are on their way, so they are not counted as still to ship.
  • The chart shows the six Clients with the most orders still to ship, as horizontal bars (the largest bar is full width) with the client name and the count.
  • The footnote says how many other Clients are left and what they hold, for example "7 more Clients hold 1,884" (or "1 more client holds 270" for one). When the spread is even, it adds "the spread is even: no client is starved." The spread counts as even when the median client (among Clients with orders still to ship) holds at least 60% of what the biggest client holds and the smallest client holds at least 25% of it. Otherwise the sentence is not shown.

Shipping method · carrier

  • A single 100% bar splits open orders by shipping method (Truck Load, Small Parcel, Private fleet, External); methods with no orders are not shown. A legend under it gives the counts.
  • Under a line, the Carriers are listed in three columns, biggest first: the top five Carriers, then Other Carriers if there are more than five. An order with no carrier appears as No carrier yet, last and in the warning colour.
  • When at least one order has no carrier, a note says so: "42 orders have no carrier: a shipping rule may be missing." (Shipping rules decide the carrier of a new order; see the Shipping rules documentation.)

3. Presets

A preset saves your whole Setup: rows, columns, Hide blanks, Pre-select rows and every filter.

Control What it does What happens next
Preset picker (top right, shows the current preset's name, or Default) Opens a list of presets with a Search presets box. Your own presets come first, then Shared ones (older presets everyone sees). Choosing one replaces the whole page state and reloads the matrix. Choosing Default Returns to Customer code by State with no filters.
Save as preset Asks for a name and saves the current Setup as your own preset. A name that already exists is overwritten. The list is limited to 50 presets per user; the server refuses the 51st with a message asking you to delete one. Shared presets cannot be changed or deleted.
Delete preset (the X, only visible when one of your own presets is selected) Asks for confirmation, then deletes the preset. The matrix stays as it is and the picker Returns to Default. Never shown for Default or a Shared preset.
Search presets Narrows the list as you type. "No presets match." if nothing fits.

If a preset's stored Setup cannot be read, the screen keeps your current Setup, does not select the preset, and shows "This preset could not be read."

Changing Rows, Columns or pressing Swap axes also Returns the picker to Default, because the Setup no longer matches the saved preset.

4. Pivot

Control What it does What happens next
Rows Chooses the dimension down the side (Client, Customer code, State, Warehouse, Shipping, Carrier, Wave, Route, dates, and so on). The matrix reloads at once.
Columns Chooses the dimension across the top. The matrix reloads at once.
Swap axes Exchanges rows and columns. The matrix reloads and the cell panel closes. When State ends up on the rows, its values are drawn as coloured pills in the row heads.
Hide blanks (switch) Hides rows and columns that hold no orders. Never reloads: it only changes what is drawn. Totals still cover every order. The text beside it says "N empty rows or columns hidden", "showing empty rows and columns too" (switch off, and the data has blanks) or "nothing empty to hide". The cell panel closes when you flip it.
Pre-select rows (switch) Makes the links in the matrix open the Pick tickets list with every row already ticked, ready for a bulk action. Never reloads. It adds &s=1 to the links. The Pick tickets list ticks at most 2,000 rows.

Date dimensions group by day and number dimensions group in bands. Next to the title, the caption Each cell: orders (lines/units) reminds you how to read a cell.

5. Filters

Filters narrow the matrix (not the header). Edits are not applied until you press Reload, so typing does not trigger a request per keystroke. The heading counts the complete filters: "· 2 active, edits apply on Reload".

Control What it does
Add filter Adds an empty row (first dimension, operator is). It filters nothing until it has a value.
Field The dimension to filter on. Changing it resets the operator (if the new field does not take it) and clears the values.
Operator Depends on the field: text fields offer is, is not, is one of, contains, is blank, is not blank; number fields is, is not, is one of, between, is blank, is not blank; date fields is, between, is blank, is not blank.
Value One box for is, is not, contains; for is one of, several values separated by commas; for between, two boxes (From and To; dates use a date picker); a day picker for a date is; nothing for is blank / is not blank. Pressing Enter in a value box reloads.
Remove filter (X) Removes the row and reloads.
Reload Applies the filters and refreshes the matrix and the header. Disabled while loading.

Rules and limits:

  • An incomplete filter stays on the screen but is not sent (no value, a number that is not a number, a day that is not a date). It never narrows the result and never reaches the links.
  • A filter row on a between with only one end filled uses that end alone (an empty From means no lower limit, an empty To no upper limit).
  • The server accepts at most 20 filters, and at most 500 values in one "is one of" filter. If the result would have more than 500 rows or columns, it answers "Too many values: the matrix would have more than 500 rows. Add a filter to narrow it down." The message appears above the matrix. Add a filter (for example one client) or choose a coarser dimension.
  • Whether a text is filter treats upper and lower case alike follows your database's collation, exactly as the equality filter of the Pick tickets list does.

6. The matrix

  • Title: "Customer code × State · 102 orders": the row dimension, the column dimension and how many orders the matrix covers. On the right: "showing 9 of 16 columns, blanks hidden" (or "showing all 16 columns"; when the columns are states it says "states" instead of "columns", for example "showing 9 of 16 states, blanks hidden" or "showing all 16 states"), followed by "darker cells hold more orders" and "click a number to see what is behind it".
  • Reading a cell: the bold number is the orders; (lines/units) is in grey beside it. An empty crossing shows an en dash (–).
  • Heat shading: every cell with orders gets a blue wash. The wash is stronger for more orders: its strength is 0.05 + 0.37 × √(orders ÷ largest), never more than 0.42, where largest is the biggest cell currently visible. So the darkest cell is always the busiest one on screen, and even one-order cells are tinted.
  • State pills: when State is on the columns (or the rows), its labels are coloured pills following the Pick tickets list's status colours (grey for Draft, blue for in-progress states, amber for waiting states, green for Shipped, red for held states). Every other dimension is plain text in the row heads. In the column heads it is shown in a neutral grey pill so all column heads have the same shape; only the blank group stays plain text.
  • The blank group: orders that have no value on an axis (no client, no carrier, no date, and so on) form a row or column named (Blanks). In the header cards the same orders are named No client (Still to ship, by client) and No shipping method (Shipping method · carrier).
  • Row head: the row's name and, underneath, "375 orders · 5%" (its orders and its share of all orders), or "no open orders".
  • Sticky headers: the header row and the first column stay in view while you scroll.
  • Totals: the right column, the bottom row and the corner (grand total) add up everything, even rows and columns Hide blanks removes. Each total is a link that opens the Pick tickets list filtered to that row, column or everything; on State the links say "State is not blank".
  • Selected cell: outlined in blue while its panel is open.
  • Below the table: "Export to xlsx writes exactly this matrix, with the same rows and columns you see."

7. The cell panel

A plain click on a number (or Enter on it) opens the panel on the right of the matrix; below the matrix on narrow windows. A click with Ctrl, Cmd or Shift, or a middle click, does not open the panel but follows the link normally (for example in a new tab).

  • Selected cell: the row's name, the column as a pill (or a plain chip), and a Close button.
  • Orders, Lines, Units: the cell's figures.
  • Share of this row / of this column: "34% of Alimentos Chiriqui", with a bar. It is the cell's orders divided by the row's (or column's) total orders, rounded.
  • The sentence: "Opens the Pick tickets list filtered to Client is X and State is Y, plus the filter above / plus the 2 filters above." The matrix's own complete filters travel with the link, and the sentence says how many. For a blank group it reads "Client is blank". The second sentence says "Every row arrives ticked, ready for a bulk action." (Pre-select rows on) or "Rows arrive unticked."
  • Open the Pick tickets: opens the list.
  • Copy link: copies the full address of that list; the button says "Copied", or "Could not copy" if the browser refuses, for two seconds.
  • Filter the matrix to this: adds the filter rows row axis is X and column axis is Y (or is blank), removes any existing filter rows on those same two fields so they cannot contradict the new ones, clears the selected preset, and reloads at once. It is not offered when either axis is a number dimension: number axes group in bands whose lower edge is excluded, while the between filter includes both ends, so for numbers that can have decimals no exact filter exists.
  • When the panel closes by itself: whenever a new matrix is drawn (you press Reload, change Rows or Columns, press Swap axes or choose a preset), when you flip Hide blanks, and after Filter the matrix to this. Flipping Pre-select rows does not close it: the last sentence of the panel just changes. Typing in a filter row does not close it either, and the "plus N filters" part of the sentence counts only the filters you have already applied with Reload.
  • Keyboard: arrow keys move between cells that have orders (empty cells are skipped), Enter selects the focused cell, Escape closes the preset list if it is open, otherwise it closes the panel and puts focus back on the cell.

8. The address and sharing a view

The whole Setup (rows, columns, switches and filters) is kept in the browser address (?f=...). Copy the address to share the exact view; opening it restores the Setup. Saved presets store the same thing. The cell selection is not part of the address.

9. Export to xlsx

Export to xlsx (top right; disabled until a matrix is shown) downloads exactly what you see: the same rows and columns (hidden blanks are not exported). The first line is the header, in bold; each row ends with its total; the last line is the totals. A cell is written as text, orders (lines/units). A row whose total is zero is written blank, matching the dash on screen (an empty total column is blank too). The file is named Order Matrix - <Rows> x <Columns>.xlsx; the worksheet has the same name, cleaned of the characters Excel does not allow ([ ] : * ? / \) and cut to 31 characters.

10. Troubleshooting

What you see What it means What to do
The page is empty and says "The matrix could not be loaded." The list of dimensions or presets could not be read. Reload the page; if it persists, tell your administrator.
"Too many values: the matrix would have more than 500 rows..." above the matrix The chosen axes have more than 500 values. Add a filter, or choose a coarser dimension.
"There are no open packslips for these filters." Your filters match nothing. Remove or loosen a filter and press Reload.
A carrier note: "N orders have no carrier" Orders were created with no carrier chosen. Check the Shipping rules for the Clients involved.
"This preset could not be read." The preset's stored Setup is damaged. Pick another preset and save the Setup again under the same name.
The header is missing, or a card is missing A request for it failed or your Tenant lacks a dimension it needs. Press Reload. The matrix works without it.

Screenshots to capture

  1. order-matrix-01-Overview.png: the whole screen with a matrix.
  2. order-matrix-02-header.png: the four KPI cards.
  3. order-matrix-03-presets.png: the preset picker open with the search box.
  4. order-matrix-04-filters.png: two filter rows, one with a range.
  5. order-matrix-05-matrix.png: the heat-shaded matrix with state pills.
  6. order-matrix-06-panel.png: the cell panel beside a selected cell.

Screenshots are pending: they could not be captured without access to a running Tenant.

Was this page helpful?