Summary
The Cash Flow Dashboard (SIOP > Cash Flow Dashboard) projects when money leaves the business to pay suppliers and when it arrives from customers, day by day, using each order's payment terms. It answers three questions for a finance or S&OP lead:
- How much cash goes out and comes in, and when? Payables (AP) and receivables (AR) per day, week or month, with net and cumulative net.
- How much of that is committed? Firm orders alone, firm plus StockIQ's planned purchases, or firm plus planned plus forecast sales.
- Who is it owed to, or owed by? The top 10 suppliers and top 10 customers, each with a drill-in by period.
The dashboard has one projection chart across the top and two top-10 grids below it. It covers every site the user is allowed to see; there is no site or date picker on the screen.
Key definitions
- Scenario adds components rather than switching data sets: Firm, then Firm + Planned, then Firm + Planned + Forecast.
- Forecast is inflow only. StockIQ forecasts demand, not future purchasing, so "+ Forecast" never changes the outflow bars.
- Net = inflows − outflows for the period. Cumulative Net runs from the start of the horizon.
- Discount available is tracked but not applied. The full amount is projected on the net due date, and the possible early-pay saving is shown beside it.
- Units follow the same split as the money. A 100-unit line paid in three installments counts 100 units in total, not 300.
Cash Flow Projection chart
| Series | Shown as | Meaning |
|---|---|---|
| Inflows (AR) | Green bars | Cash expected from customers |
| Outflows (AP) | Red bars | Cash expected to go to suppliers |
| Net Cash Flow | Blue line | Inflows minus outflows in the period |
| Cumulative Net | Orange line | Running total of net cash flow across the horizon |
Two button groups in the chart header control it:
| Control | Options | Default |
|---|---|---|
| Scenario | Firm, + Planned, + Forecast | + Forecast |
| Interval | Daily, Weekly, Monthly | Daily |
- Firm: open purchase orders and open sales orders only.
- + Planned: adds the purchases StockIQ is suggesting (planned supply).
- + Forecast: adds revenue from forecast demand not yet covered by a sales order.
Top Outflows (Suppliers) and Top Inflows (Customers)
Each grid lists the 10 counterparties with the largest total over the horizon for the selected scenario. Both have the standard grid toolbar, including export and email.
Counterparty drill-in
Click a row in either grid to open Cash Flow Detail for that supplier or customer
- A chart of firm and planned amounts stacked per period, with a cumulative line.
- A By Period grid with firm, planned, total, cumulative, and discount available, plus firm and planned quantities in the column chooser. Columns are totaled.
- The drill-in uses the dashboard's current interval.
The dialog explains three states rather than showing an empty grid:
- On + Forecast it says the detail covers firm and planned only. Forecast revenue has no customer attached, so the detail will not add up to the chart.
- "No cash-flow projection has been calculated" means the projection has not run yet for that counterparty.
- "Nothing falls due over the horizon" means a projection exists with nothing owed.
Payment terms and related settings
The dashboard has no settings screen of its own. Its accuracy depends on the payment terms fed from the ERP, which the Implementation team shapes into StockIQ's Payment Terms format.
Payment terms types
| Type | How the due date is set |
|---|---|
| Net | Invoice date + payment days |
| Cash or Prepaid | Paid up front |
| Discount / Net | Net terms with an early-pay discount (for example 2% 10, net 30) |
| End of Month | Due at month end, optionally some months later |
| Day of Month | Due on a set day of the month |
| Due on Receipt | Due on the invoice date |
| Scheduled | Milestone installments (below) |
| None Specified | Treated as due on the ship or receipt date |
Each term can be limited to customers, vendors, or both.
Scheduled (milestone) terms
A Scheduled term splits an order into installments. Each installment pays a percentage of the order a set number of days after a milestone: Order, Invoice, Ship or Receipt. For example, 10% at order, 40% at ship and 50% 30 days after receipt. Percentages must total 100%. If they do not, or the schedule is malformed, the order falls back to one full payment on the invoice date, so no money is lost or double-counted.
Where terms come from
| Order type | Terms used, first match wins |
|---|---|
| Open purchase order | The order's own terms, then the supplier's default |
| Open sales order | The order line's terms, then the ship-to's default, then the customer's default |
| Planned purchase | The supplier's default |
| Forecast revenue | No terms; lands on the forecast day |
Related settings elsewhere
| Setting | Where | Effect |
|---|---|---|
| View Cash Flow Dashboard permission | Security roles | Required to see the SIOP menu item, the dashboard, the drill-in and the Edison tool |
| Show the Payment Terms dropdown when placing orders | System Configuration > Integration Configuration | Adds a Payment Terms selector to Place Orders, defaulted from the supplier and written back to the ERP |
Supplier-level security applies: a user limited to certain suppliers sees only their payables.
How cash flows are calculated
Each amount is dated from when goods are expected to ship or arrive, then pushed out by payment terms. The order creation date is not used.
| Flow | Source | Amount | Timing anchor |
|---|---|---|---|
| Firm outflow (AP) | Open purchase order lines | Remaining quantity × cost | Planned receipt date |
| Firm inflow (AR) | Open sales orders | Remaining quantity × invoice price | Requested ship date |
| Planned outflow (AP) | StockIQ suggested purchases | Suggested quantity × cost | Suggested receipt date |
| Forecast inflow (AR) | Replenishment forecast, less demand already on sales orders | Quantity × item-site standard price | The forecast day, no terms lag |