Orders held by inventory shortage or credit hold in Sage Intacct, ranked by revenue at stake. The morning unblocking queue.
At a glance
Sage Intacct Orders that are blocked, ranked by dollar value. Block reasons include credit hold (customer over credit limit or terms-violated), inventory shortage (Order line cannot allocate stock), pending approval (workflow approver offline), pending Project authorisation, or pending Department-head sign-off where the merchant uses dimension-based approval. The morning unblocking queue.
| What it counts | Open Orders WHERE (ONHOLD = TRUE) OR (CREDITHOLD = TRUE) OR (allocated_qty < ordered_qty AND fulfilment_pending) OR (workflow_state = 'Pending Approval' AND age > threshold). Each row carries the block reason + dollar value + Customer + dimension tags + days-blocked. |
| Tax treatment | Inclusive of estimated tax (Order Total). |
| Shipping | Included. |
| Discounts | Already deducted. |
| Refunds and Credit Memos | n/a. |
| Cancelled / voided orders | Excluded. |
| Currency | Order in entity base currency, FX-translated to reporting currency. |
| Block categories | Credit Hold, Inventory Hold, Approval Hold, Project Authorisation Hold, Custom Workflow Hold. Configurable. |
| Dimensions | Each blocked Order carries Department, Location, Project, Customer through. Lets the Controller filter to “blocked Orders for East Coast Sales (Department 200)” and ping that team only. |
| Time window | Real-time snapshot (RT) |
| Alert trigger | >0 high-value blocked (default: any Order > $10K blocked > 24 hours), tunable per workspace |
| Sentiment key | blocked_so |
| Roles | owner, finance, operations |
Calculation
Calculated automatically from your Sage data. See the At a glance summary above for what the metric tracks and the worked example below for a typical reading.Worked example
A US B2B distributor on Sage Intacct Multi-Entity Console. Snapshot 14 Apr 26, 9:00am.| Block reason | Order count | Value at stake | Median days blocked |
|---|---|---|---|
| Credit Hold | 12 | $284,000 | 4.2 |
| Inventory Hold (allocation short) | 8 | $186,000 | 2.8 |
| Approval Hold (pending Department-head) | 6 | $94,000 | 1.6 |
| Project Authorisation Hold | 3 | $48,000 | 5.4 |
| Total blocked (this card) | 29 | $612,000 | 3.4 |
| Order | Customer | Block reason | Value | Days blocked | Dimensions |
|---|---|---|---|---|---|
| SO-00012-2026 | Apex Industrial Supply | Credit Hold (over $250K limit) | $84,000 | 6 | Dept 200 East, Loc Newark |
| SO-00014-2026 | Northwind Manufacturing | Inventory Hold (SKU-44A short 120) | $62,000 | 3 | Dept 100 West, Loc Oakland |
| SO-00018-2026 | Apex Industrial Supply | Credit Hold (cascading) | $48,000 | 6 | Dept 200 East, Loc Newark |
| SO-00021-2026 | Vortex Energy LLC | Project Authorisation Hold | $36,000 | 7 | Project PRJ-NOVA, Dept 300 |
| SO-00024-2026 | Helios Wholesale | Approval Hold | $28,000 | 2 | Dept 200 East |
- **Apex Industrial Supply: 132K Invoice within 7 days, ~$132K cash within 35 days.
- Inventory Hold on SKU-44A: 120 units short blocking $62K. Procurement: confirm next inbound PO date. If >7 days, partial-ship the Order with the available 80 units and back-order the rest. Customer notified.
- Project Authorisation Hold sitting 7 days on PRJ-NOVA. Project Manager has been on PTO. Backup approver should have been delegated; Operations to set up auto-delegation.
- Cascading credit holds. Apex’s two Orders together push them to 145% of credit limit; raising the limit clears both. Without the Customer Credit Utilisation card, the cascade isn’t visible.
- Cumulative cash impact: clearing 80% of the queue this week unlocks ~490K of cash within 5 weeks. The morning unblocking ritual is the single highest-leverage Operations habit a B2B Intacct merchant has.
Sibling cards merchants should reference together
| Card | Why pair it with Open Orders Blocked |
|---|---|
| Open Order Value | The denominator. Blocked Orders as a % of total Open Orders is the operational health ratio. |
| Customer Credit Utilisation | Why credit holds happen. Customers near 100% utilisation will keep tripping the hold. |
| Credit Hold Spike | Alert when credit holds rise sharply. |
| Low Stock Alerts | Why inventory holds happen. Inbound POs vs short SKUs. |
| Order to Invoice Lead Time | If lead time is rising, blocked Orders are typically the cause. |
| Order State Breakdown | The state distribution in which Blocked Orders sit. |
| Top B2B Accounts by Revenue | If a top account appears here repeatedly, the customer health is at risk. |
Reconciling against the vendor’s own dashboard
Where to look in Sage Intacct:Order Entry → List View → Filter: On Hold = TRUE Reports → Order Entry → Sales Order Register → Hold filter Customer → List View → Filter: Credit Hold = TRUE Interactive Custom Report (ICR) combining Order Entry + Customer + Inventory data sourcesIntacct does not surface a single “blocked Orders by reason” view natively; the merchant must combine three filters (Order hold, credit hold, inventory short). Vortex IQ joins them automatically. Why our list may legitimately differ from a manual check:
| Reason | Direction | Why |
|---|---|---|
| Hold flag latency | Card slightly delayed | New holds applied within last 5-15 minutes may not appear yet. |
| Approval workflow definition | Either | Some merchants treat “Pending Approval > 24h” as blocked; others wait 72h. Default is 24h, configurable. |
| Inventory allocation | Either | Allocation logic varies (FIFO vs zone-based vs reservation). Card uses Intacct’s native allocation result. |
| Custom block flags | Material | Merchants who use a custom field for hold reasons must map it via the field map. |