Inventory Detail Table
Operational stock view with coverage and distributor status
| Distributor | POS Sales Prv Q | Run rate (prior yr POS) | Monthly stock (prior yr inv) | Available inv. | Projected inv. | Committed SF | Final Q stock | Needed | Status |
|---|
Demand Flow
Opportunity to POS demand
Actual Bookings By Distributor
Bookings by year · click anywhere here for details
Monthly Coverage
Final Q stock / run rate POS
Needed / Excess Bridge
Visual summary of distributor gaps
Balance By Distributor
Total available inventory value ($) per distributor
Top Product Families
Highest available-value families (share of total)
Top Items
Highest available-value individual SKUs
Inventory Items
Itemized stock by distributor and product — respects the filters above, plus its own search
| Distributor | Group | Class | Product # | Description | On hand | Committed | Available | On order | Backorder | Amount avail. |
|---|
Top Customers
Share of total POS sales — top 7 accounts, rest grouped as Other
EC Profile
End Customer level only (not Bill To) — navigate by sales rep to see their accounts, sliced by the filters above
| Account | Transactions | Total POS sales |
|---|
Opportunity Details
Filtered by Distributor/Region/Country/Year/Quarter above and search below. Distributor is resolved via the Account's link to a Distributor-type record — covers ~85% of opportunities; the rest are non-distributor account types (Integrator, Direct, VAR, etc.) and show as "—".
| Opp # | Name | Type | Account | Distributor | Sales Person | Supporting Seller | End Customer | Amount | Expected Rev. | Forecast | Prob. |
|---|
Quote Details
Filtered by Distributor/Region/Country/Year/Quarter above and search below. Distributor is resolved via the Account's link to a Distributor-type record — covers ~92% of quotes; the rest show as "—".
| Quote # | Opp # | Account | Distributor | Bill To | End Customer | Product | Qty | List Price | Sales Price | Total Price | Total Cost |
|---|
Booking Details
AGG_BOOKING is already an aggregate (distributor/year/quarter grain) — this is that grain as a sortable, searchable table. Filtered by Distributor/Year/Quarter above.
| Distributor | Year | Quarter | Total amount |
|---|
POS Details
FACT_POS at the transaction grain. Filtered by all filters above.
| POS # | Year | Qtr | Distributor | End Customer | Bill To | Product | Sales Person | Supporting Seller | Qty | Net After Rebates | Customer Category |
|---|